[sql] sale1
Viewer
- CREATE TABLE `CUSTOMER` (
- `CustomerID` INT(10),
- `LastName` VARCHAR(15),
- `FirstName` VARCHAR(15),
- `Address` VARCHAR(30),
- `City` VARCHAR(10),
- `State` VARCHAR(10),
- `ZIP` INT(10),
- `Phone` INT(10),
- `Email` VARCHAR(20),
- PRIMARY KEY (`CustomerID`)
- );
- CREATE TABLE `SALE` (
- `SaleID` INT(15),
- `SaleDate` DATE,
- `SubTotal` INT(15),
- `TAX` INT(10),
- `Total` INT(15),
- `CustomerID` INT(15),
- PRIMARY KEY (`SaleID`)
- FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID)
- );
- CREATE TABLE `SALE_ITEM` (
- `SaleID` INT(15),
- `SaleItemID` INT(15),
- `ItemPrice` INT(10),
- `ItemID` INT(15),
- PRIMARY KEY (`SaleItemID`)
- FOREIGN KEY (SaleID) REFERENCES SALE(SaleID)
- FOREIGN KEY (ItemID) REFERENCES ITEM(ItemID)
- );
Editor
You can edit this paste and save as new: