SWIFT SDK 6.0
When utilizing table autogenerating, the scheme created has wrong data types for the following
Date
Int
Both types are represented as Double
Trying to manually change it in the console has the following error
Updating column type failed. Changing column to type DATETIME will lead to loss of data.
The backend cannot always deduce the right type. Datetime values are sent by the client side as the number of milliseconds since epoch. As a result, to the backend it looks like a number (because it is a number), hence it will create the column as Int. In cases like these, it is recommended to create the schema either manually, or use the same API that the console uses to declare the columns.
Regards,
Mark