50PsX9HT

1
2create table if not exists Produkt
3(
4	produkt_ID integer PRIMARY KEY,
5	nazwa text not null,
6	cena money not null,
7	dostepnosc boolean not null,	
8);
9
10create table if not exists Koszyk
11(
12	koszyk_ID integer PRIMARY KEY,
13	ID_produkt integer not null,
14	ilosc integer not null,
15	cena_razem money not null
16);
17
18create table if not exists Zamowienie
19(
20	zamowienie_ID integer PRIMARY KEY,
21	data_zamowienia date not null,
22	status text not null,
23	platnosc text not null,
24	ID_koszyka integer PRIMARY KEY,
25	ID_klienta integer PRIMARY KEY,
26);
27
28create table if not exists Klient
29(
30	klient_ID integer PRIMARY KEY,
31	imie text not null,
32	nazwisko text not null,
33	adres text not null,
34	kod_pocztowy
35	email text not null,
36	nr_tel integer not null,
37	NIP integer not null
38);