CM>create a new table
the first UI displays so unnecessary information such as
"type: table" -> I have already clicked a menu "create a table" what else the type can be?
"schema type" -> what else? necessary to display?
the user should click the [Add] button to define columns. Why?
column setting table should be editable. the current column setting is one column after one column.
for example, I enter a column name, and select a type, check the option for column constraints, and move to the next line for 2nd column.
Why PK/FK is not displayed in the same UI? why in a separate button?
DEFAULT <value_specification> } |
AUTO_INCREMENT [ (seed, increment) ]
NOT NULL | UNIQUE | PRIMARY KEY | FOREIGN KEY
Ths constraints above should be able to set in a single UI.
and additionally, this UI should provide "create table like" which replicates the existing table schema.
Let's consider user's behavior when creating a table.
How many columns usually have in a table?
How many constraints are defined in a column?
How many clicks is the current CM UI asking to users to create a table? Have you tried?
Are they easy way to re-use the table schema, column schema, index to apply a new table?