GUI for creating table #33

New issue

Open

opened 2018-11-30 18:34:55 +00:00 by eelke · 1 comment

eelke commented

2018-11-30 18:34:55 +00:00

(Migrated from gitlab.com)

ASCII mockup of possible layout

table name: _________________
+------+------+--------+-----------+---------+----------+---------+------+--------+---------+
| name | type | length | scale     | collate | not null | default | pkey | unique | comment |
+------+------+--------+-----------+---------+----------+---------+------+--------+---------+

Behavior when entering column definitions into grid

pkey column use space to add/remove column from pkey (columns are numbered in order, use +- to change ordering)
unique press space to make unique gets a check mark, check marked columns are unique on their own press a number or letter to group unique colums. Col
automatically create new lines as needed
skip columns that are not applicable
use comboboxes with auto complete where possible
not null is checkbox
or maybe + next line

Constraints

pkey
unique
foreign key
check

GUI for defining tables. Should be more efficient then typing the sql yourself. Problem with pgAdmin is that commonly needed values are spread over multiple tabs which slows user down. We need to have commonly used fields on a single page ## ASCII mockup of possible layout ``` table name: _________________ +------+------+--------+-----------+---------+----------+---------+------+--------+---------+ | name | type | length | scale | collate | not null | default | pkey | unique | comment | +------+------+--------+-----------+---------+----------+---------+------+--------+---------+ ``` Behavior when entering column definitions into grid - pkey column use space to add/remove column from pkey (columns are numbered in order, use +- to change ordering) - unique press space to make unique gets a check mark, check marked columns are unique on their own press a number or letter to group unique colums. Col - automatically create new lines as needed - skip columns that are not applicable - use comboboxes with auto complete where possible - not null is checkbox - <enter> or maybe <ctrl>+<enter> next line ## Constraints - pkey - unique - foreign key - check

eelke commented

2018-12-01 07:43:17 +00:00

(Migrated from gitlab.com)

changed the description