Skip to content

public.notification_preferences

Columns

Name Type Default Nullable Children Parents Comment
category varchar(20) false
email_enabled boolean false
id bigint false
push_enabled boolean false
user_id bigint false public.users

Constraints

Name Type Definition
notification_preferences_pkey PRIMARY KEY PRIMARY KEY (id)
notification_preferences_user_id_08802827_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
unique_user_category UNIQUE UNIQUE (user_id, category)

Indexes

Name Definition
notification_preferences_pkey CREATE UNIQUE INDEX notification_preferences_pkey ON public.notification_preferences USING btree (id)
notification_preferences_user_id_08802827 CREATE INDEX notification_preferences_user_id_08802827 ON public.notification_preferences USING btree (user_id)
unique_user_category CREATE UNIQUE INDEX unique_user_category ON public.notification_preferences USING btree (user_id, category)

Generated by tbls