public.users¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval('users_id_seq'::regclass) | false | public.user_answers public.user_app_settings | ||
| identity_id | varchar(255) | false | ||||
| created_at | timestamp with time zone | CURRENT_TIMESTAMP | true | |||
| updated_at | timestamp with time zone | CURRENT_TIMESTAMP | true | |||
| display_name | varchar(255) | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| users_id_not_null | n | NOT NULL id |
| users_identity_id_not_null | n | NOT NULL identity_id |
| users_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| users_identity_id_key | UNIQUE | UNIQUE (identity_id) |
Indexes¶
| Name | Definition |
|---|---|
| users_pkey | CREATE UNIQUE INDEX users_pkey ON public.users USING btree (id) |
| users_identity_id_key | CREATE UNIQUE INDEX users_identity_id_key ON public.users USING btree (identity_id) |
Relations¶
Generated by tbls