CREATE TABLE [Zamowienie] (
	id bigint NOT NULL,
	kwota_calkowita decimal NOT NULL,
	data_zamowienia datetime NOT NULL,
	status decimal NOT NULL,
	uzytkownik_id bigint NOT NULL,
	kwota_po_rabacie decimal NOT NULL,
	rabat_kod decimal NOT NULL,
  CONSTRAINT [PK_ZAMOWIENIE] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [StatusZamowienia] (
	id varchar(5) NOT NULL,
	opis varchar(40) NOT NULL,
  CONSTRAINT [PK_STATUSZAMOWIENIA] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Produkt] (
	id bigint NOT NULL,
	nazwa varchar(30) NOT NULL,
	cena money NOT NULL,
	czy_dostepny bit(30) NOT NULL,
	kategoria_id varchar(5) NOT NULL,
  CONSTRAINT [PK_PRODUKT] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Kategoria] (
	id varchar(5) NOT NULL,
	nazwa varchar(30) NOT NULL,
  CONSTRAINT [PK_KATEGORIA] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Produkt_Zamowienie] (
	id bigint NOT NULL,
	produkt_id bigint NOT NULL,
	zamowienie_id bigint NOT NULL,
	ilosc smallint NOT NULL,
  CONSTRAINT [PK_PRODUKT_ZAMOWIENIE] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Uzytkownik] (
	id bigint NOT NULL,
	login varchar(20) NOT NULL UNIQUE,
	haslo varchar(20) NOT NULL,
	czy_aktywny bit NOT NULL,
	email varchar(50) NOT NULL,
	dane_osobowe_id bigint NOT NULL,
  CONSTRAINT [PK_UZYTKOWNIK] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Dane_Osobowe] (
	id bigint NOT NULL,
	imie varchar(30) NOT NULL,
	nazwisko varchar(30) NOT NULL,
	telefon numeric(10) NOT NULL,
	adres_id bigint NOT NULL,
  CONSTRAINT [PK_DANE_OSOBOWE] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Adres] (
	id bigint NOT NULL,
	miejscowosc varchar(30) NOT NULL,
	kod_pocztowy varchar(6) NOT NULL,
	ulica varchar(100) NOT NULL,
  CONSTRAINT [PK_ADRES] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [ZamowienieStan] (
	id bigint NOT NULL,
	zamowienie_id bigint NOT NULL,
	stan_przed varchar(5) NOT NULL,
	stan_po varchar(5) NOT NULL,
	data_zmiany timestamp NOT NULL,
  CONSTRAINT [PK_ZAMOWIENIESTAN] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
CREATE TABLE [Rabat] (
	kod varchar NOT NULL,
	czy_procentowy bit NOT NULL,
	czy_kwotowy bit NOT NULL,
	obowiazuje_od datetime NOT NULL,
	obowiazuje_do datetime NOT NULL,
	wartosc float NOT NULL,
  CONSTRAINT [PK_RABAT] PRIMARY KEY CLUSTERED
  (
  [kod] ASC
  ) WITH (IGNORE_DUP_KEY = OFF)

)
GO
ALTER TABLE [Zamowienie] WITH CHECK ADD CONSTRAINT [Zamowienie_fk0] FOREIGN KEY ([status]) REFERENCES [StatusZamowienia]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Zamowienie] CHECK CONSTRAINT [Zamowienie_fk0]
GO
ALTER TABLE [Zamowienie] WITH CHECK ADD CONSTRAINT [Zamowienie_fk1] FOREIGN KEY ([uzytkownik_id]) REFERENCES [Uzytkownik]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Zamowienie] CHECK CONSTRAINT [Zamowienie_fk1]
GO
ALTER TABLE [Zamowienie] WITH CHECK ADD CONSTRAINT [Zamowienie_fk2] FOREIGN KEY ([rabat_kod]) REFERENCES [Rabat]([kod])
ON UPDATE CASCADE
GO
ALTER TABLE [Zamowienie] CHECK CONSTRAINT [Zamowienie_fk2]
GO


ALTER TABLE [Produkt] WITH CHECK ADD CONSTRAINT [Produkt_fk0] FOREIGN KEY ([kategoria_id]) REFERENCES [Kategoria]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Produkt] CHECK CONSTRAINT [Produkt_fk0]
GO


ALTER TABLE [Produkt_Zamowienie] WITH CHECK ADD CONSTRAINT [Produkt_Zamowienie_fk0] FOREIGN KEY ([produkt_id]) REFERENCES [Produkt]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Produkt_Zamowienie] CHECK CONSTRAINT [Produkt_Zamowienie_fk0]
GO
ALTER TABLE [Produkt_Zamowienie] WITH CHECK ADD CONSTRAINT [Produkt_Zamowienie_fk1] FOREIGN KEY ([zamowienie_id]) REFERENCES [Zamowienie]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Produkt_Zamowienie] CHECK CONSTRAINT [Produkt_Zamowienie_fk1]
GO

ALTER TABLE [Uzytkownik] WITH CHECK ADD CONSTRAINT [Uzytkownik_fk0] FOREIGN KEY ([dane_osobowe_id]) REFERENCES [Dane_Osobowe]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Uzytkownik] CHECK CONSTRAINT [Uzytkownik_fk0]
GO

ALTER TABLE [Dane_Osobowe] WITH CHECK ADD CONSTRAINT [Dane_Osobowe_fk0] FOREIGN KEY ([adres_id]) REFERENCES [Adres]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [Dane_Osobowe] CHECK CONSTRAINT [Dane_Osobowe_fk0]
GO


ALTER TABLE [ZamowienieStan] WITH CHECK ADD CONSTRAINT [ZamowienieStan_fk0] FOREIGN KEY ([zamowienie_id]) REFERENCES [Zamowienie]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [ZamowienieStan] CHECK CONSTRAINT [ZamowienieStan_fk0]
GO
ALTER TABLE [ZamowienieStan] WITH CHECK ADD CONSTRAINT [ZamowienieStan_fk1] FOREIGN KEY ([stan_przed]) REFERENCES [StatusZamowienia]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [ZamowienieStan] CHECK CONSTRAINT [ZamowienieStan_fk1]
GO
ALTER TABLE [ZamowienieStan] WITH CHECK ADD CONSTRAINT [ZamowienieStan_fk2] FOREIGN KEY ([stan_po]) REFERENCES [StatusZamowienia]([id])
ON UPDATE CASCADE
GO
ALTER TABLE [ZamowienieStan] CHECK CONSTRAINT [ZamowienieStan_fk2]
GO