L7hi4Xq7

1CREATE   TABLE IF NOT EXISTS reporter
2(rid     NUMERIC(5,0)
3,fname   CHAR(15) 		NOT NULL
4,lname   CHAR(30) 		NOT NULL
5,spec    CHAR(15)
6,syear   NUMERIC(4,0)
7,PRIMARY KEY (rid));
8
9CREATE   TABLE IF NOT EXISTS item
10(iid     NUMERIC(5,0)
11,title   VARCHAR(50) 	NOT NULL
12,pdate   DATE			NOT NULL	--Publication year
13,stext   CHAR(15)		NOT NULL	--Short text
14,ftext   CHAR(15)		NOT NULL	--Full text
15,PRIMARY KEY (iid));
16
17CREATE   TABLE IF NOT EXISTS onpage
18(iid     NUMERIC(5,0)
19,pid     CHAR(15)
20,fdate   DATE			NOT NULL
21,tdate   DATE
22,PRIMARY KEY (iid, pid)
23,FOREIGN KEY (iid) REFERENCES item);
24
25CREATE   TABLE IF NOT EXISTS report
26(iid     NUMERIC(5,0)
27,rid     NUMERIC(5,0)
28,PRIMARY KEY (iid,rid));
29
30CREATE   TABLE IF NOT EXISTS keyword
31(kword   CHAR(15)
32,subject CHAR(15)
33,PRIMARY KEY (kword, subject));
34
35CREATE   TABLE IF NOT EXISTS map
36(iid     NUMERIC(5,0)
37,kword   CHAR(15)
38,PRIMARY KEY (iid, kword)
39,FOREIGN KEY (iid) REFERENCES item);