24 lines
735 B
SQL
24 lines
735 B
SQL
-- Table: public.document_authors
|
|
|
|
-- DROP TABLE IF EXISTS public.document_authors;
|
|
|
|
CREATE TABLE IF NOT EXISTS public.document_authors
|
|
(
|
|
doc_id integer NOT NULL,
|
|
author_id integer NOT NULL,
|
|
CONSTRAINT document_authors_pkey PRIMARY KEY (doc_id, author_id),
|
|
CONSTRAINT document_authors_author_id_fkey FOREIGN KEY (author_id)
|
|
REFERENCES public.authors (author_id) MATCH SIMPLE
|
|
ON UPDATE NO ACTION
|
|
ON DELETE NO ACTION,
|
|
CONSTRAINT document_authors_doc_id_fkey FOREIGN KEY (doc_id)
|
|
REFERENCES public.documents (doc_id) MATCH SIMPLE
|
|
ON UPDATE NO ACTION
|
|
ON DELETE NO ACTION
|
|
)
|
|
|
|
TABLESPACE pg_default;
|
|
|
|
ALTER TABLE IF EXISTS public.document_authors
|
|
OWNER to dbuser01;
|
|
|