Guest User

Untitled

a guest
Dec 13th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. CREATE TABLE CM_Product (
  2. ProductID int IDENTITY(1,1) PRIMARY KEY,
  3. CategoryID varchar(70) FOREIGN KEY REFERENCES CM_Category(CategoryName),
  4. ProductName varchar(70),
  5. IMGURL varchar(255),
  6. ProductDescription text,
  7. Manufacturer varchar(40)
  8. );
  9.  
  10. CREATE TABLE CM_PointOfSale (
  11. PointOfSaleID int IDENTITY(1,1) PRIMARY KEY,
  12. ProductID_FK int FOREIGN KEY REFERENCES CM_Category(CategoryID),
  13. VendorID int FOREIGN KEY REFERENCES CM_Vendor(VendorID),
  14. URLDestination varchar(255),
  15. Price Decimal(10,2)
  16. );
  17.  
  18. CREATE TABLE CM_Vendor (
  19. VendorID int IDENTITY(1,1) PRIMARY KEY,
  20. VendorName varchar(100),
  21. FullVendorURL varchar(255)
  22. );
  23.  
  24. CREATE TABLE CM_Category (
  25. CategoryID int IDENTITY(1,1) PRIMARY KEY,
  26. CategoryName varchar(70) UNIQUE NOT NULL,
  27. CategoryID_FK int FOREIGN KEY REFERENCES CM_Category(CategoryID)
  28. );
Add Comment
Please, Sign In to add comment