CREATE TABLE reporter
(
    rid     NUMERIC (5, 0)  PRIMARY KEY NOT NULL,
    fname   CHAR(15)    NOT NULL,
    lname   CHAR(30)    NOT NULL,
    spec    CHAR(15)    NOT NULL,
    syear   numeric (4, 0)
);


CREATE TABLE item(
    iid     NUMERIC (5, 0)  PRIMARY KEY NOT NULL,
    title   VARCHAR(50) NOT NULL,
    pdate   DATE        NOT NULL,
    stext   CHAR(15)    NOT NULL,
    ftext   CHAR(15)    NOT NULL
);

CREATE TABLE onpage(
    iid     NUMERIC (5, 0)  NOT NULL,
    pid CHAR(15)    NOT NULL,
    fdate   DATE        NOT NULL,
    tdate   DATE,
    PRIMARY KEY(iid, pid),
    FOREIGN KEY (iid)   REFERENCES item
);

CREATE TABLE report(
    iid     NUMERIC (5, 0)  NOT NULL,
    rid NUMERIC (5, 0)  NOT NULL,
    PRIMARY KEY(iid, rid),
    FOREIGN KEY (iid)   REFERENCES item,
    FOREIGN KEY (rid)   REFERENCES reporter
);

CREATE TABLE keyword(
    kword   CHAR(15)    NOT NULL,
    subject CHAR(15)    NOT NULL,
    PRIMARY KEY(kword, subject)
);

CREATE TABLE map(
    iid     NUMERIC (5, 0)  NOT NULL,
    kword   CHAR(15)    NOT NULL,
    PRIMARY KEY(iid, kword),
    FOREIGN KEY (iid)   REFERENCES item,
    FOREIGN KEY (kword) REFERENCES keyword
);