Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE TABLE CustomerReviews
- --(
- --ReviewID INT,
- --ReviewContent VARCHAR(255) NOT NULL,
- --ReviewGrade INT CHECK (ReviewGrade BETWEEN 0 AND 10),
- --AirlineID INT,
- --CustomerID INT,
- --CONSTRAINT PK_CustomerReviews PRIMARY KEY (ReviewID),
- --CONSTRAINT FK_CustomerReviews_Airlines FOREIGN KEY (AirlineID) REFERENCES Airlines (AirlineID),
- --CONSTRAINT FK_CustomerReviews_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
- --)
- --CREATE TABLE CustomerBankAccounts
- --(
- --AccountID INT,
- --AccountNumber VARCHAR(10) NOT NULL UNIQUE,
- --Balance DECIMAL(10,2) NOT NULL,
- --CustomerID INT,
- --CONSTRAINT PK_CustomerBankAccounts PRIMARY KEY (AccountID),
- --CONSTRAINT FK_CustomerBankAccounts_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
- --)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement