19 lines
414 B
SQL
19 lines
414 B
SQL
-- View: public.document_details
|
|
|
|
-- DROP VIEW public.document_details;
|
|
|
|
CREATE OR REPLACE VIEW public.document_details
|
|
AS
|
|
SELECT d.doc_id,
|
|
d.title,
|
|
dt.type_name,
|
|
ldv.content,
|
|
ldv.updated_at
|
|
FROM documents d
|
|
JOIN document_types dt ON d.type_id = dt.type_id
|
|
LEFT JOIN latest_document_versions ldv ON d.doc_id = ldv.doc_id;
|
|
|
|
ALTER TABLE public.document_details
|
|
OWNER TO dbuser01;
|
|
|