Data type of ID

[aditmehta9]

Problem

Right now we can select only integer for the datatype of ID. But if a user clicks on ID dropdown -> Number-> Number Type. In Number Types, multiple options are shown i.e Float, decimal, integer. But can't select the other 2 number type. Either this option should not be shown or the user should be able to define this data type.

Proposed solution

Either this option should not be shown or the user should be able to define this data type.

Additional context

[silentninja]

We don't support changing the type of columns with dynamic defaults. In this case, id column has a autoincrement default, so the request gets rejected by the backend. The frontend should not allow such an operation to happen or show an error proper response. @pavish @seancolsen @kgodey Can anyone confirm the expected behaviour for this error.

[kgodey]

We have a design issue for handling primary keys. We'll handle the problems listed in this issue there, I've linked to this issue in the issue description for #439. I'm going to close this issue since there's no work to be done here yet.

[kgodey]

I wanted to add: Thanks for reporting, @aditmehta9! Some of our features are still unfinished since we're still working towards our first release. Please continue to report any issues you see.