dartbrief.push_subscriptions

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
auth	text		true
created_at	timestamp with time zone	now()	false
endpoint	text		false
id	bigint	nextval('push_subscriptions_id_seq'::regclass)	false
p256dh	text		true
user_id	bigint		false		dartbrief.users

Constraints

Name	Type	Definition
push_subscriptions_pkey	PRIMARY KEY	PRIMARY KEY (id)
push_subscriptions_user_id_endpoint_key	UNIQUE	UNIQUE (user_id, endpoint)
push_subscriptions_user_id_fkey	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE

Indexes

Name	Definition
push_subscriptions_pkey	CREATE UNIQUE INDEX push_subscriptions_pkey ON dartbrief.push_subscriptions USING btree (id)
push_subscriptions_user_id_endpoint_key	CREATE UNIQUE INDEX push_subscriptions_user_id_endpoint_key ON dartbrief.push_subscriptions USING btree (user_id, endpoint)

Relations

erDiagram

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

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

---

Generated by tbls