Skip to content

public.fcm_django_fcmdevice

Columns

Name Type Default Nullable Children Parents Comment
active boolean false
date_created timestamp with time zone true
device_id varchar(255) true
id integer false
name varchar(255) true
registration_id text false
type varchar(10) false
user_id bigint true public.users

Constraints

Name Type Definition
fcm_django_fcmdevice_pkey PRIMARY KEY PRIMARY KEY (id)
fcm_django_fcmdevice_registration_id_9918b353_uniq UNIQUE UNIQUE (registration_id)
fcm_django_fcmdevice_user_id_6cdfc0a2_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
fcm_django__registr_dacdb2_idx CREATE INDEX fcm_django__registr_dacdb2_idx ON public.fcm_django_fcmdevice USING btree (registration_id, user_id)
fcm_django_fcmdevice_device_id_a9406c36 CREATE INDEX fcm_django_fcmdevice_device_id_a9406c36 ON public.fcm_django_fcmdevice USING btree (device_id)
fcm_django_fcmdevice_pkey CREATE UNIQUE INDEX fcm_django_fcmdevice_pkey ON public.fcm_django_fcmdevice USING btree (id)
fcm_django_fcmdevice_registration_id_9918b353_like CREATE INDEX fcm_django_fcmdevice_registration_id_9918b353_like ON public.fcm_django_fcmdevice USING btree (registration_id text_pattern_ops)
fcm_django_fcmdevice_registration_id_9918b353_uniq CREATE UNIQUE INDEX fcm_django_fcmdevice_registration_id_9918b353_uniq ON public.fcm_django_fcmdevice USING btree (registration_id)
fcm_django_fcmdevice_user_id_6cdfc0a2 CREATE INDEX fcm_django_fcmdevice_user_id_6cdfc0a2 ON public.fcm_django_fcmdevice USING btree (user_id)

Generated by tbls