public.document_approval

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			(DC2Type:uuid)
user_id	uuid		false		public.user	(DC2Type:uuid)
document_id	uuid		false		public.document	(DC2Type:uuid)
approved_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)

Constraints

Name	Type	Definition
document_approval_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_99216472c33f7837	FOREIGN KEY	FOREIGN KEY (document_id) REFERENCES document(id)
fk_99216472a76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)

Indexes

Name	Definition
document_approval_pkey	CREATE UNIQUE INDEX document_approval_pkey ON public.document_approval USING btree (id)
idx_99216472a76ed395	CREATE INDEX idx_99216472a76ed395 ON public.document_approval USING btree (user_id)
idx_99216472c33f7837	CREATE INDEX idx_99216472c33f7837 ON public.document_approval USING btree (document_id)

Relations

---

Generated by tbls