All pastes #895671 Raw Edit

Someone

public sql v1 · immutable
·published 2008-02-07 23:58 UTC
rendered paste body
CREATE 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));