public.user_options
July 8, 2020 ยท View on GitHub
Description
User options table
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| user_id | integer | false | public.users | |||
| show_email | boolean | false | false | |||
| created | timestamp without time zone | false | ||||
| updated | timestamp without time zone | true |
Constraints
| Name | Type | Definition | Comment |
|---|---|---|---|
| user_options_user_id_fk | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE | FK |
| user_options_pkey | PRIMARY KEY | PRIMARY KEY (user_id) |
Indexes
| Name | Definition | Comment |
|---|---|---|
| user_options_pkey | CREATE UNIQUE INDEX user_options_pkey ON public.user_options USING btree (user_id) | PRIMARY KEY |
Relations
Generated by tbls