IDAS2_SEM

CREATE TABLE SEM_Kategorie
  ( Typ NUMBER NOT NULL , Nazev VARCHAR2 (100)
  ) ;
ALTER TABLE SEM_Kategorie ADD CONSTRAINT SEM_Kategorie_PK PRIMARY KEY ( Typ ) ;

CREATE TABLE SEM_LogTable
  ( ID NUMBER NOT NULL , User_ID NUMBER , Datum DATE
  ) ;
ALTER TABLE SEM_LogTable ADD CONSTRAINT SEM_LogTable_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_Meny
  ( Kod VARCHAR2 (3) NOT NULL , Nazev VARCHAR2 (50)
  ) ;
ALTER TABLE SEM_Meny ADD CONSTRAINT SEM_Meny_PK PRIMARY KEY ( Kod ) ;

CREATE TABLE SEM_Objednavky
  (
    ID          NUMBER NOT NULL ,
    Datum       DATE NOT NULL ,
    Stav        VARCHAR2 (100) NOT NULL ,
    Obsah       VARCHAR2 (500) NOT NULL ,
    Produkty_ID NUMBER NOT NULL ,
    Users_ID    NUMBER NOT NULL
  ) ;
ALTER TABLE SEM_Objednavky ADD CONSTRAINT SEM_Objednavky_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_Produkty
  (
    ID            NUMBER NOT NULL ,
    Nazev         VARCHAR2 (100) ,
    Cena          NUMBER ,
    Kategorie_Typ NUMBER NOT NULL
  ) ;
ALTER TABLE SEM_Produkty ADD CONSTRAINT SEM_Produkty_PK PRIMARY KEY ( ID ) ;

CREATE TABLE "SEM_Produkty-foto"
  (
    ID NUMBER NOT NULL ,
    Data BLOB ,
    Pripona_souboru VARCHAR2 (4) ,
    Datum_nahrani   DATE ,
    Produkty_ID     NUMBER NOT NULL
  ) ;
ALTER TABLE "SEM_Produkty-foto" ADD CONSTRAINT "SEM_Produkty-foto_PK" PRIMARY KEY ( ID ) ;

CREATE TABLE "SEM_Produkty-parametry"
  (
    Popis       VARCHAR2 (300) ,
    Upozorneni  VARCHAR2 (200) ,
    Schnuti     VARCHAR2 (50) ,
    Obsah       VARCHAR2 (50) ,
    ID          NUMBER NOT NULL ,
    Produkty_ID NUMBER NOT NULL
  ) ;
ALTER TABLE "SEM_Produkty-parametry" ADD CONSTRAINT "SEM_Produkty-parametry_PK" PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_Role
  ( ID NUMBER NOT NULL , Nazev VARCHAR2 (100)
  ) ;
ALTER TABLE SEM_Role ADD CONSTRAINT SEM_Role_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_Staty
  (
    ID       NUMBER NOT NULL ,
    Nazev    VARCHAR2 (100) ,
    Meny_Kod VARCHAR2 (3) NOT NULL
  ) ;
ALTER TABLE SEM_Staty ADD CONSTRAINT SEM_Staty_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_TEMPORARY
  (
    ID    NUMBER NOT NULL ,
    Datum DATE ,
    LOG   VARCHAR2 (500)
  ) ;
ALTER TABLE SEM_TEMPORARY ADD CONSTRAINT SEM_Temporary_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_Users
  (
    ID       NUMBER NOT NULL ,
    Jmeno    VARCHAR2 (100) ,
    Prijmeni VARCHAR2 (100) ,
    Email    VARCHAR2 (100) ,
    Heslo    VARCHAR2 (200) ,
    Role_ID  NUMBER NOT NULL ,
    Staty_ID NUMBER NOT NULL
  ) ;
ALTER TABLE SEM_Users ADD CONSTRAINT SEM_Users_PK PRIMARY KEY ( ID ) ;

CREATE TABLE SEM_UsersToLogTable
  (
    Users_ID    NUMBER NOT NULL ,
    LogTable_ID NUMBER NOT NULL
  ) ;
ALTER TABLE SEM_UsersToLogTable ADD CONSTRAINT Relation_12__IDX PRIMARY KEY ( Users_ID, LogTable_ID ) ;

ALTER TABLE SEM_UsersToLogTable ADD CONSTRAINT FK_ASS_7 FOREIGN KEY ( Users_ID ) REFERENCES SEM_Users ( ID ) ;

ALTER TABLE SEM_UsersToLogTable ADD CONSTRAINT FK_ASS_8 FOREIGN KEY ( LogTable_ID ) REFERENCES SEM_LogTable ( ID ) ;

ALTER TABLE SEM_Objednavky ADD CONSTRAINT SEM_Objednavky_Produkty_FK FOREIGN KEY ( Produkty_ID ) REFERENCES SEM_Produkty ( ID ) ;

ALTER TABLE SEM_Objednavky ADD CONSTRAINT Objednavky_Users_FK FOREIGN KEY ( Users_ID ) REFERENCES SEM_Users ( ID ) ;

ALTER TABLE "SEM_Produkty-foto" ADD CONSTRAINT "SEM_Produkty-foto_Produkty_FK" FOREIGN KEY ( Produkty_ID ) REFERENCES SEM_Produkty ( ID ) ;

ALTER TABLE "SEM_Produkty-parametry" ADD CONSTRAINT "SEM_parametry_Produkty_FK" FOREIGN KEY ( Produkty_ID ) REFERENCES SEM_Produkty ( ID ) ;

ALTER TABLE SEM_Produkty ADD CONSTRAINT SEM_Produkty_Kategorie_FK FOREIGN KEY ( Kategorie_Typ ) REFERENCES SEM_Kategorie ( Typ ) ;

ALTER TABLE SEM_Staty ADD CONSTRAINT SEM_Staty_Meny_FK FOREIGN KEY ( Meny_Kod ) REFERENCES SEM_Meny ( Kod ) ;

ALTER TABLE SEM_Users ADD CONSTRAINT SEM_Users_Role_FK FOREIGN KEY ( Role_ID ) REFERENCES SEM_Role ( ID ) ;

ALTER TABLE SEM_Users ADD CONSTRAINT Users_Staty_FK FOREIGN KEY ( Staty_ID ) REFERENCES SEM_Staty ( ID ) ;