dartbrief.push_subscriptions

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
created_at	timestamp with time zone	now()	false
fcm_token	text		false
id	bigint	nextval('push_subscriptions_id_seq'::regclass)	false
platform	varchar(10)		false
updated_at	timestamp with time zone	now()	false
user_id	bigint		false		dartbrief.users

Constraints

Name	Type	Definition
push_subscriptions_fcm_token_key	UNIQUE	UNIQUE (fcm_token)
push_subscriptions_pkey	PRIMARY KEY	PRIMARY KEY (id)
push_subscriptions_user_id_fkey	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE

Indexes

Name	Definition
idx_push_subscriptions_user_id	CREATE INDEX idx_push_subscriptions_user_id ON dartbrief.push_subscriptions USING btree (user_id)
push_subscriptions_fcm_token_key	CREATE UNIQUE INDEX push_subscriptions_fcm_token_key ON dartbrief.push_subscriptions USING btree (fcm_token)
push_subscriptions_pkey	CREATE UNIQUE INDEX push_subscriptions_pkey ON dartbrief.push_subscriptions USING btree (id)

Relations

erDiagram

"dartbrief.push_subscriptions" }o--|| "dartbrief.users" : ""

"dartbrief.push_subscriptions" {
  bigint user_id FK
}
"dartbrief.users" {
  bigint id
}

---

Generated by tbls