postgreSQL_def/view/create_view_public.document_details.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;