Advertisement
Guest User

sdfsdf

a guest
Jan 29th, 2020
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None | 0 0
  1. CREATE TABLE Writters (
  2. writerid int NOT NULL UNIQUE,
  3. firstname varchar(20) NOT NULL,
  4. lastname varchar(20) NOT NULL,
  5. age int NOT NULL
  6. PRIMARY KEY(writerid)
  7.  
  8.  
  9. )
  10.  
  11. CREATE TABLE reviews (
  12.     reviewid int NOT NULL UNIQUE,
  13.     writerid int NOT NULL UNIQUE,
  14.     rate int  NOT NULL,
  15.     opinion varchar (255) DEFAULT 'Good',
  16.     CHECK (rate>=0),
  17.     PRIMARY KEY (reviewid),
  18.     FOREIGN KEY (writerid) REFERENCES Writters(writerid)
  19.  
  20. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement