Skip to content

public.notifications

Columns

Name Type Default Nullable Children Parents Comment
body varchar(1024) false
created_at timestamp with time zone false
data jsonb true
id bigint false
is_fcm_sent boolean false
is_read boolean false
should_send_fcm boolean false
title varchar(255) false
type varchar(50) false
user_id bigint false public.users

Constraints

Name Type Definition
notifications_pkey PRIMARY KEY PRIMARY KEY (id)
notifications_user_id_468e288d_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
notificatio_created_e4c995_idx CREATE INDEX notificatio_created_e4c995_idx ON public.notifications USING btree (created_at)
notificatio_is_fcm__54571e_idx CREATE INDEX notificatio_is_fcm__54571e_idx ON public.notifications USING btree (is_fcm_sent)
notificatio_is_read_3f8c44_idx CREATE INDEX notificatio_is_read_3f8c44_idx ON public.notifications USING btree (is_read)
notificatio_type_8a8a78_idx CREATE INDEX notificatio_type_8a8a78_idx ON public.notifications USING btree (type)
notificatio_user_id_e78525_idx CREATE INDEX notificatio_user_id_e78525_idx ON public.notifications USING btree (user_id)
notifications_pkey CREATE UNIQUE INDEX notifications_pkey ON public.notifications USING btree (id)
notifications_user_id_468e288d CREATE INDEX notifications_user_id_468e288d ON public.notifications USING btree (user_id)

Generated by tbls