V8iKMuZW

1DROP TABLE IF EXISTS INCLUDED;
2DROP TABLE IF EXISTS ARTWORK;
3DROP TABLE IF EXISTS TYPEOFWORK;
4DROP TABLE IF EXISTS ARTIST;
5DROP TABLE IF EXISTS AUCTION;
6DROP TABLE IF EXISTS AUCTIONHOUSE;
7
8-- Table: AUCTIONHOUSE
9CREATE TABLE AUCTIONHOUSE (
10	AuctionHouseID TEXT,
11	Name TEXT NOT NULL UNIQUE,
12	Address TEXT,
13	Website TEXT,
14	PRIMARY KEY(AuctionHouseID)
15);
16
17-- Table: AUCTION
18CREATE TABLE AUCTION (
19	AuctionID TEXT NOT NULL,
20	Name TEXT NOT NULL UNIQUE,
21	Overview TEXT,
22	Date TEXT NOT NULL,
23	Location TEXT,
24	WebLink TEXT,
25	AuctionHouseID TEXT,
26	PRIMARY KEY(AuctionID), 
27	foreign key (AuctionHouseID) references AUCTIONHOUSE(AuctionHouseID)
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,
53	Name TEXT NOT NULL,
54	Description TEXT,
55	YearOfCreation TEXT,
56	Photo TEXT,
57	TypeID text not null,
58	ArtistID text,
59	PRIMARY KEY(ArtWorkID),
60	 FOREIGN KEY(TypeID)references TYPEOFWORK(TypeID),
61	 foreign key (ArtistID) references ARTIST (ArtistID) 
62);
63
64create table included(
65valuedFrom integer,
66valuedto integer,
67soldfor integer,
68AuctionID text not null,
69ArtWorkID  text not null,
70foreign key (AuctionID) references AUCTION(AuctionID),
71foreign key (ArtWorkID) references ARTWORK(ArtWorkID));