Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Writters (
- writerid int NOT NULL UNIQUE,
- firstname varchar(20) NOT NULL,
- lastname varchar(20) NOT NULL,
- age int NOT NULL
- PRIMARY KEY(writerid)
- )
- CREATE TABLE reviews (
- reviewid int NOT NULL UNIQUE,
- writerid int NOT NULL UNIQUE,
- rate int NOT NULL,
- opinion varchar (255) DEFAULT 'Good',
- CHECK (rate>=0),
- PRIMARY KEY (reviewid),
- FOREIGN KEY (writerid) REFERENCES Writters(writerid)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement