dartbrief.user_revealed_disclosures

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
rcept_no	text		false
revealed_at	timestamp with time zone	now()	false
user_id	bigint		false		dartbrief.users

Constraints

Name	Type	Definition
user_revealed_disclosures_pkey	PRIMARY KEY	PRIMARY KEY (user_id, rcept_no)
user_revealed_disclosures_user_id_fkey	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE

Indexes

Name	Definition
idx_revealed_user_time	CREATE INDEX idx_revealed_user_time ON dartbrief.user_revealed_disclosures USING btree (user_id, revealed_at DESC)
user_revealed_disclosures_pkey	CREATE UNIQUE INDEX user_revealed_disclosures_pkey ON dartbrief.user_revealed_disclosures USING btree (user_id, rcept_no)

Relations

erDiagram

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

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

---

Generated by tbls