kXz0R4LM

1DROP TABLE IF EXISTS ARTWORK CASCADE;
2DROP TABLE IF EXISTS TYPEOFWORK CASCADE;
3DROP TABLE IF EXISTS ARTIST CASCADE;
4DROP TABLE IF EXISTS AUCTION CASCADE;
5DROP TABLE IF EXISTS AUCTIONHOUSE CASCADE;
6DROP TABLE IF EXISTS INCLUDED CASCADE;
7
8-- Table: AUCTIONHOUSE
9CREATE TABLE AUCTIONHOUSE (
10	AuctionHouseID TEXT NOT NULL,
11	Name TEXT NOT NULL UNIQUE,
12	Address TEXT,
13	Website TEXT,
14	primary key (AuctionHouseID)
15	
16);
17
18-- Table: AUCTION
19CREATE TABLE AUCTION (
20	AuctionID TEXT NOT NULL,
21	Name TEXT NOT NULL UNIQUE,
22	Overview TEXT,
23	Date TEXT NOT NULL,
24	Location TEXT,
25	WebLink TEXT,
26	AuctionHouseID TEXT references AUCTIONHOUSE(AuctionHouseID) ON DELETE CASCADE,
27	primary key(AuctionID)
28);
29
30-- Table: ARTIST
31CREATE TABLE ARTIST (
32	ArtistID TEXT NOT NULL,
33	Name TEXT NOT NULL, 
34	Nationality TEXT, 
35	YearOfBirth TEXT NOT NULL, 
36	YearOfDeath TEXT, 
37	ShortCV TEXT, 
38	WebLink TEXT,
39    primary key (ArtistID)
40);
41
42-- Table: TYPEOFWORK
43CREATE TABLE TYPEOFWORK (
44	TypeID TEXT NOT NULL,
45	Name TEXT NOT NULL UNIQUE, 
46	WebLink TEXT, 
47	primary key (TypeID)
48);
49
50-- Table: ARTWORK
51CREATE TABLE ARTWORK (
52	ArtWorkID TEXT NOT NULL,
53	Name TEXT NOT NULL,
54	Description TEXT,
55	YearOfCreation TEXT,
56	Photo TEXT,
57	ArtistID TEXT references ARTIST(ArtistID) ON DELETE CASCADE,
58	TypeID TEXT references TYPEOFWORK(TypeID) ON DELETE CASCADE,
59	primary key (ArtWorkID)
60);
61
62CREATE TABLE INCLUDED (
63	ArtWorkID TEXT references AUCTION(AuctionID) ON DELETE CASCADE,
64	AuctionID TEXT references ARTWORK(ArtWorkID) ON DELETE CASCADE,
65	ValuedFrom INT,
66	ValuedTo INT,
67	SoldFor INT,
68	primary key(ArtWorkID,AuctionID)
69
70);
71
72
73select Name, YearOfBirth from ARTIST where YearOfDeath=NULL;