rendered paste bodyCREATE TABLE syllogh ( syl_kwd_syl serial PRIMARY KEY, syl_onoma varchar(32) UNIQUE, syl_perigrafh varchar(1024));CREATE TABLE antik ( at_kwdikos serial PRIMARY KEY, at_perigrafh varchar(1024), at_titlos varchar(32), at_yliko varchar(16), at_styl varchar(16), at_katagwgh varchar(16), at_epoxh varchar(16), at_ypsos integer CHECK (at_ypsos > 0), at_platos integer CHECK (at_platos > 0), at_paxos integer CHECK (at_paxos > 0), at_daneiko boolean, at_se_ekthesh boolean, at_kwd_syl integer REFERENCES syllogh(syl_kwd_syl));CREATE TABLE pinakas ( pin_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE CASCADE, pin_typos varchar(16), pin_texnotr varchar(16));CREATE TABLE glypto ( gl_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE CASCADE, gl_texnotr varchar(16), gl_is_statue boolean);CREATE TABLE allo ( allo_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE CASCADE, allo_typos varchar(16));CREATE TABLE eks_syllogh ( eks_kwdikos serial PRIMARY KEY, eks_typos varchar(32), eks_kwd_ypefth char(8), eks_on_ypefth varchar(16), eks_ep_ypefth varchar(16) UNIQUE, --epwnymo eks_odos_yp varchar(16), eks_ar_ypefth varchar(16));CREATE TABLE se_dan ( se_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE RESTRICT, se_eks_kwdikos integer REFERENCES eks_syllogh(eks_kwdikos) ON DELETE RESTRICT, se_imer_dan date NOT NULL, se_imer_ep date NOT NULL CHECK (se_imer_ep>se_imer_dan), PRIMARY KEY (se_at_kwdikos, se_eks_kwdikos, se_imer_dan));CREATE TABLE til_ypefth ( til_ep_ypefth varchar(16) REFERENCES eks_syllogh(eks_ep_ypefth) ON DELETE CASCADE, til_til varchar(16), PRIMARY KEY (til_ep_ypefth, til_til));CREATE TABLE dan_se ( dan_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE RESTRICT, dan_eks_kwdikos integer REFERENCES eks_syllogh(eks_kwdikos), dan_imer_dan date NOT NULL, dan_imer_ep date NOT NULL CHECK (dan_imer_ep>dan_imer_dan), PRIMARY KEY (dan_at_kwdikos, dan_eks_kwdikos, dan_imer_dan));CREATE TABLE artist ( art_kwdikos serial PRIMARY KEY, art_onoma varchar(16) UNIQUE, art_eponymo varchar(16) UNIQUE, art_epoxi varchar(16), art_xwra varchar(16), art_perigrafi varchar(1024), art_im_genn date CHECK (art_im_genn<CURRENT_DATE), art_im_than date CHECK (art_im_than>art_im_genn and art_im_than<=CURRENT_DATE));CREATE TABLE filot_apo ( fa_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE CASCADE, fa_art_kwdik integer REFERENCES artist(art_kwdikos) ON DELETE RESTRICT, fa_date char(4) CHECK (fa_date<CURRENT_DATE), PRIMARY KEY (fa_at_kwdikos, fa_art_kwdik));CREATE TABLE ekthesi ( ekth_kwdikos serial PRIMARY KEY, ekth_onoma varchar(64) UNIQUE, ekth_thema varchar(128), ekth_ticket money, ekth_visitors integer, ekth_im_enarks date, ekth_im_liks date CHECK (ekth_im_liks>ekth_im_enarks));CREATE TABLE ektith ( ekth_at_kwdikos integer REFERENCES antik(at_kwdikos) ON DELETE CASCADE, --na allaxte se RESTRICT ekth_ekth_kwdikos integer REFERENCES ekthesi(ekth_kwdikos) ON DELETE CASCADE, PRIMARY KEY (ekth_at_kwdikos, ekth_ekth_kwdikos));CREATE TABLE meso ( mes_kwdikos serial PRIMARY KEY, mes_onoma varchar(16) UNIQUE, mes_typos varchar(16));CREATE TABLE diafimisi ( diaf_ekth_kwdik integer REFERENCES ekthesi(ekth_kwdikos) ON DELETE RESTRICT, diaf_mes_kwdik integer REFERENCES meso(mes_kwdikos) ON DELETE RESTRICT, diaf_date date, diaf_kostos money, PRIMARY KEY (diaf_ekth_kwdik, diaf_mes_kwdik, diaf_date));