Tables

CREATE TABLE Miasta (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL COLLATE PXW_PLK,
  CONSTRAINT Miasta_U UNIQUE (Nazwa),
  CONSTRAINT Miasta_PK PRIMARY KEY (ID)
);

CREATE TABLE Dominujace_kuchnie (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  CONSTRAINT Dominujace_kuchnie_U UNIQUE (Nazwa),
  CONSTRAINT Dominujace_kuchnie_PK PRIMARY KEY (ID)
);

CREATE TABLE Typy_dania (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  CONSTRAINT dania_U UNIQUE (Nazwa),
  CONSTRAINT dania_PK PRIMARY KEY (ID)
);

CREATE TABLE Typy_skladniki (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  CONSTRAINT Typy_skladniki_U UNIQUE (Nazwa),
  CONSTRAINT Typy_skladniki_PK PRIMARY KEY (ID)
);

CREATE TABLE Typy_alergeny (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  CONSTRAINT Typy_alergeny_U UNIQUE (Nazwa),
  CONSTRAINT Typy_alergeny_PK PRIMARY KEY (ID)
);

CREATE TABLE Restauracje (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  Adres VARCHAR(32) NOT NULL,
  ID_Miasta INTEGER NOT NULL,
  Numer_tel INTEGER,
  NIP INTEGER,
  Ocena INTEGER,
  ID_Dominujace_kuchnie INTEGER,
  Notatka VARCHAR(1024),
  CONSTRAINT Restauracje_U UNIQUE (Numer_tel, NIP),
  CONSTRAINT Restauracje_PK PRIMARY KEY (ID),
  CONSTRAINT Restauracje_FK_M FOREIGN KEY (ID_Miasta) REFERENCES Miasta(ID)
    ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT Restauracje_FK_D FOREIGN KEY (ID_Dominujace_kuchnie) REFERENCES Dominujace_kuchnie(ID)
    ON UPDATE CASCADE ON DELETE SET NULL
);

CREATE TABLE Dania (
  ID INTEGER NOT NULL,
  Nazwa VARCHAR(32) NOT NULL,
  ID_typy_dania INTEGER,
  CONSTRAINT DaniaPK PRIMARY KEY (ID),
  CONSTRAINT DaniaFK_TD FOREIGN KEY (ID_typy_dania) REFERENCES Typy_dania(ID)
    ON UPDATE CASCADE ON DELETE SET NULL
);

CREATE TABLE Potrawy (
  ID INTEGER NOT NULL,
  Cena INTEGER NOT NULL,
  Gramatura INTEGER,
  Zdjecie VARCHAR(1024),
  ID_Dania INTEGER NOT NULL,
  ID_Restauracje INTEGER NOT NULL,
  Notatka VARCHAR(1024),
  CONSTRAINT Potrawy_PK PRIMARY KEY (ID),
  CONSTRAINT Potrawy_FK_R FOREIGN KEY (ID_Dania) REFERENCES Dania(ID)
    ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT Potrawy_FK_D FOREIGN KEY (ID_Restauracje) REFERENCES Restauracje(ID)
    ON UPDATE CASCADE ON DELETE CASCADE
);



CREATE TABLE Skladniki (
  ID INTEGER NOT NULL,
  ID_Potrawy INTEGER NOT NULL,
  ID_Typy_skladniki INTEGER NOT NULL,
  CONSTRAINT Skladniki_FK_P FOREIGN KEY (ID_Potrawy) REFERENCES Potrawy(ID)
    ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT Skladniki_FK_TS FOREIGN KEY (ID_Typy_skladniki) REFERENCES Typy_skladniki(ID)
    ON UPDATE CASCADE ON DELETE CASCADE
);

CREATE TABLE Alergeny (
  ID INTEGER NOT NULL,
  ID_Typy_alergeny INTEGER NOT NULL,
  ID_Potrawy INTEGER NOT NULL,
  CONSTRAINT Alergeny_FK_TA FOREIGN KEY (ID_Typy_alergeny) REFERENCES Typy_alergeny(ID)
    ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT Alergeny_FK_P FOREIGN KEY (ID_Potrawy) REFERENCES Potrawy(ID)
    ON UPDATE CASCADE ON DELETE CASCADE
);