At the moment when using postgres datastore we are using JSONB type for each column created. Now we need to use proper datatypes for "plain" fileds like text, url etc. Some fileds will create two columns. Full list to be added
Name Description Suggested Data Type Boolean true or false BOOLEAN Color Stores a color as string VARCHAR Coordinates Stores value in GeoJSON GEOGRAPHY Date Stores a date, as in a day in calendar, without time. DATE Datetime Stores a timestamp as ms since epoch. Timezone-independent. TIMESTAMP Email An email address VARCHAR Enum Allows only values from a predefined list VARCHAR EnumMultiple Stores an array of predefined strings VARCHAR[] File Any kind of file VARCHAR Float Any real number FLOAT Html Takes text containing HTML and sanitizes it to prevent js injection TEXT, TEXT (_original, _safe) Image An image. Can be scaled to different sizes automatically VARCHAR Int An integer. Takes only whole numbers INTEGER JsonObject Takes in arbitrary objects. Could be unsafe, requires investigation. JSONB Money Keeps float value and provides ability to format as string with decode method NUMERIC Password A hashed password. Used in the users collection VARCHAR SecretToken Attaches a secret token when creating an item. The token cannot be read without SuperContext VARCHAR SessionID Basically a mutable uuid UUID StructuredArray An array of objects. Each object has the same defined field structure JSONB[]?? Text A text field TEXT, TEXT Uuid Stores an automatically generated UUID string UUID Url Accepts valid url links. You can also put some restrictions regardless valid domains and protocols VARCHAR