Field Data Type

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


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


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

Prisma Boolean


Integer value type.

Prisma Int


Floating point number.

Prisma Float


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


Date and time type.

Prisma DateTime