Креирање и пополнување на база на податоци (DDL, DML)

DDL

CREATE TABLE public.author (
author_id BIGINT NOT NULL,
first_name VARCHAR(100),
last_name VARCHAR(100),
birth_date DATE,
nationality VARCHAR(100),
CONSTRAINT author_pkey PRIMARY KEY (author_id)
);

CREATE TABLE public.author_book (
author_id BIGINT NOT NULL,
book_id BIGINT NOT NULL,
CONSTRAINT author_book_pkey PRIMARY KEY (author_id, book_id),
CONSTRAINT author_book_author_id_fkey
FOREIGN KEY (author_id)
REFERENCES public.author(author_id)
);

CREATE TABLE public.book (
book_id BIGINT NOT NULL,
title VARCHAR(255) NOT NULL,
isbn VARCHAR(20) NOT NULL,
publication_year INT NOT NULL,
total_copies INT NOT NULL,
edition BIGINT,
publisher_id BIGINT,
author_id BIGINT,
location_id BIGINT,
CONSTRAINT book_pkey PRIMARY KEY (book_id)
);

...