CREATE TABLE EDIZM (
    ED_ID INTEGER NOT NULL,
    ED_NAME VARCHAR( 128 ));


CREATE TABLE GROUP_T (
    G_ID INTEGER NOT NULL,
    G_NAME VARCHAR( 128 ));


CREATE TABLE KONTR_TYPE (
    KT_ID INTEGER NOT NULL,
    KT_NAME VARCHAR( 50 ));


CREATE TABLE KONTRAGENT (
    KON_ID INTEGER NOT NULL,
    NAME VARCHAR( 128 ),
    KON_TYPE INTEGER,
    KONTAKT VARCHAR( 256 ));


CREATE TABLE OSTATKI (
    O_KONTR INTEGER,
    O_TOVAR INTEGER,
    O_KOLVO INTEGER);


CREATE TABLE PROVOD_TYPE (
    PRT_ID INTEGER NOT NULL,
    PRT_NAME VARCHAR( 60 ));


CREATE TABLE PROVODKI (
    PR_ID INTEGER NOT NULL,
    PR_TYPE INTEGER,
    PR_TOVAR INTEGER,
    PR_OTKOGO INTEGER,
    PR_KOMU INTEGER,
    PR_KOLVO INTEGER,
    PR_DATE INTEGER);


CREATE TABLE TOVAR (
    T_ID INTEGER NOT NULL,
    T_GROUP INTEGER,
    T_NAME INTEGER,
    T_EDIZM INTEGER);
/***                              Primary keys                              ***/
ALTER TABLE EDIZM ADD CONSTRAINT PK_EDIZM PRIMARY KEY (ED_ID);
ALTER TABLE GROUP_T ADD CONSTRAINT PK_GROUP_T PRIMARY KEY (G_ID);
ALTER TABLE KONTR_TYPE ADD CONSTRAINT PK_KONTR_TYPE PRIMARY KEY (KT_ID);
ALTER TABLE KONTRAGENT ADD CONSTRAINT PK_KONTRAGENT PRIMARY KEY (KON_ID);
ALTER TABLE PROVOD_TYPE ADD CONSTRAINT PK_PROVOD_TYPE PRIMARY KEY (PRT_ID);
ALTER TABLE PROVODKI ADD CONSTRAINT PK_PROVODKI PRIMARY KEY (PR_ID);
ALTER TABLE TOVAR ADD CONSTRAINT PK_TOVAR PRIMARY KEY (T_ID);
/***                              Foreign keys                              ***/
ALTER TABLE KONTRAGENT ADD CONSTRAINT FK_KONTRAGENT FOREIGN KEY (KON_TYPE) REFERENCES KONTR_TYPE (KT_ID);
ALTER TABLE OSTATKI ADD CONSTRAINT FK_OST_KONTR FOREIGN KEY (O_KONTR) REFERENCES KONTRAGENT (KON_ID);
ALTER TABLE OSTATKI ADD CONSTRAINT FK_OST_TOVAR FOREIGN KEY (O_TOVAR) REFERENCES TOVAR (T_ID);
ALTER TABLE PROVODKI ADD CONSTRAINT FK_PROVODKI_O FOREIGN KEY (PR_TYPE) REFERENCES PROVOD_TYPE (PRT_ID);
ALTER TABLE PROVODKI ADD CONSTRAINT FK_PROVODKI_T FOREIGN KEY (PR_TOVAR) REFERENCES TOVAR (T_ID);
ALTER TABLE PROVODKI ADD CONSTRAINT FK_PROVODKI_KONTR1 FOREIGN KEY (PR_OTKOGO) REFERENCES KONTRAGENT (KON_ID);
ALTER TABLE PROVODKI ADD CONSTRAINT FK_PROVODKI_KONTR2 FOREIGN KEY (PR_KOMU) REFERENCES KONTRAGENT (KON_ID);
ALTER TABLE TOVAR ADD CONSTRAINT FK_TOVAR_1 FOREIGN KEY (T_GROUP) REFERENCES GROUP_T (G_ID);
ALTER TABLE TOVAR ADD CONSTRAINT FK_TOVAR_2 FOREIGN KEY (T_EDIZM) REFERENCES EDIZM (ED_ID);