Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CM_Product (
- ProductID int IDENTITY(1,1) PRIMARY KEY,
- CategoryID varchar(70) FOREIGN KEY REFERENCES CM_Category(CategoryName),
- ProductName varchar(70),
- IMGURL varchar(255),
- ProductDescription text,
- Manufacturer varchar(40)
- );
- CREATE TABLE CM_PointOfSale (
- PointOfSaleID int IDENTITY(1,1) PRIMARY KEY,
- ProductID_FK int FOREIGN KEY REFERENCES CM_Category(CategoryID),
- VendorID int FOREIGN KEY REFERENCES CM_Vendor(VendorID),
- URLDestination varchar(255),
- Price Decimal(10,2)
- );
- CREATE TABLE CM_Vendor (
- VendorID int IDENTITY(1,1) PRIMARY KEY,
- VendorName varchar(100),
- FullVendorURL varchar(255)
- );
- CREATE TABLE CM_Category (
- CategoryID int IDENTITY(1,1) PRIMARY KEY,
- CategoryName varchar(70) UNIQUE NOT NULL,
- CategoryID_FK int FOREIGN KEY REFERENCES CM_Category(CategoryID)
- );
Add Comment
Please, Sign In to add comment