Field Data Type

CreateAppAI supports following field data types, inline with Prisma Schema Field Types.

String

Variable Length string.

Note: You can provide length and will be used to generate schema with corresponding data length for database that support it.

Prisma String

Boolean

True or False Value. Based on the database, it will be mapped to Boolean or Integer field.

Prisma Boolean

Integer

Integer value type.

Prisma Int

Float

Floating point number.

Prisma Float

Decimal

Decimal number, used for money, currency etc. You can provide data length and data scale. Data Length = precision, the maximum total number of decimal digits to be stored. Data Scale = scale, the number of digits to the right of the decimal point.

Prisma Decimal

DateTime

Date and time type.

Prisma DateTime