[sql] sale1

Viewer

  1. CREATE TABLE `CUSTOMER` (
  2.     `CustomerID` INT(10),
  3.     `LastName` VARCHAR(15),
  4.     `FirstName` VARCHAR(15),
  5.     `Address` VARCHAR(30),
  6.     `City` VARCHAR(10),
  7.     `State` VARCHAR(10),
  8.     `ZIP` INT(10),
  9.     `Phone` INT(10),
  10.     `Email` VARCHAR(20),
  11.     PRIMARY KEY (`CustomerID`)
  12. );
  13.  
  14.  
  15.  
  16. CREATE TABLE `SALE` (
  17.         `SaleID` INT(15),
  18.         `SaleDate` DATE,
  19.         `SubTotal` INT(15),
  20.         `TAX` INT(10),
  21.         `Total` INT(15),
  22.         `CustomerID` INT(15),
  23.         PRIMARY KEY (`SaleID`)
  24.         FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID)
  25. );

Editor

You can edit this paste and save as new:


File Description
  • sale1
  • Paste Code
  • 15 Jul-2018
  • 532 Bytes
You can Share it: