public.user_options

July 8, 2020 ยท View on GitHub

Description

User options table

Columns

NameTypeDefaultNullableChildrenParentsComment
user_idintegerfalsepublic.users
show_emailbooleanfalsefalse
createdtimestamp without time zonefalse
updatedtimestamp without time zonetrue

Constraints

NameTypeDefinitionComment
user_options_user_id_fkFOREIGN KEYFOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADEFK
user_options_pkeyPRIMARY KEYPRIMARY KEY (user_id)

Indexes

NameDefinitionComment
user_options_pkeyCREATE UNIQUE INDEX user_options_pkey ON public.user_options USING btree (user_id)PRIMARY KEY

Relations

er


Generated by tbls