Advertisement
StoyanGrigorov

Untitled

Feb 14th, 2017
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1.  
  2. --CREATE TABLE CustomerReviews
  3. --(
  4. --ReviewID INT,
  5. --ReviewContent VARCHAR(255) NOT NULL,
  6. --ReviewGrade INT CHECK (ReviewGrade BETWEEN 0 AND 10),
  7. --AirlineID INT,
  8. --CustomerID INT,
  9. --CONSTRAINT PK_CustomerReviews PRIMARY KEY (ReviewID),
  10. --CONSTRAINT FK_CustomerReviews_Airlines FOREIGN KEY (AirlineID) REFERENCES Airlines (AirlineID),
  11. --CONSTRAINT FK_CustomerReviews_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
  12. --)
  13.  
  14. --CREATE TABLE CustomerBankAccounts
  15. --(
  16. --AccountID INT,
  17. --AccountNumber VARCHAR(10) NOT NULL UNIQUE,
  18. --Balance DECIMAL(10,2) NOT NULL,
  19. --CustomerID INT,
  20. --CONSTRAINT PK_CustomerBankAccounts PRIMARY KEY (AccountID),
  21. --CONSTRAINT FK_CustomerBankAccounts_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
  22. --)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement