StudentDatabaseSQLBackup.txt

-- This script was generated by a beta version of the ERD tool in pgAdmin 4.
-- Please log an issue at https://redmine.postgresql.org/projects/pgadmin4/issues/new if you find any bugs, including reproduction steps.
BEGIN;


CREATE TABLE IF NOT EXISTS public.student
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    first_name character varying COLLATE pg_catalog."default",
    group_id integer,
    CONSTRAINT student_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.student_group
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    faculty character varying(50) COLLATE pg_catalog."default",
    name character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT student_group_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.student_role
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    role_name character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT role_name_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.student_role_link
(
    student_id integer NOT NULL,
    role_id integer NOT NULL,
    CONSTRAINT student_role_pkey PRIMARY KEY (student_id, role_id)
);

ALTER TABLE IF EXISTS public.student
    ADD CONSTRAINT group_id FOREIGN KEY (group_id)
    REFERENCES public.student_group (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.student_role_link
    ADD CONSTRAINT role_id FOREIGN KEY (role_id)
    REFERENCES public.student_role (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.student_role_link
    ADD CONSTRAINT student_id FOREIGN KEY (student_id)
    REFERENCES public.student (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;

END;