DB_FINAL

Tables (7)

Customer (Untitled)

  • CustomerID (Key) — varchar(10) — Primary key — NOT NULL
  • FirstName (Field) — varchar(50)
  • LastName (Field4) — varchar(50)
  • email (Field2) — varchar(100)
  • city (Field3) — varhcar(50)

Item (Untitled4)

  • ItemNum (Key) — varchar(10) — Primary key — NOT NULL
  • SupplierID (Key2) — varchar(10) — Foreign key → Supplier.SupplierID — NOT NULL
  • ItemName (Field) — varchar(50)
  • PackageSize (Field2) — varchar(50)
  • Price (Field3) — int
  • OnHand (Field4) — int

Order (Untitled2)

  • OrderNum (Key) — varchar(10) — Primary key — NOT NULL
  • CustomerID (Key2) — varchar(10) — Foreign key → Customer.CustomerID — NOT NULL
  • OrderDate (Field) — datetime

OrderLine (Untitled3)

  • OrderNum (PK/FK) — varchar(10) — Foreign key → Order.OrderNum — NOT NULL
  • ItemNum (PK,FK) — varchar(10) — Foreign key → Item.ItemNum — NOT NULL
  • Qty (Field) — int

Purchase (Untitled6)

  • PurchaseID (Key) — varchar(10) — Primary key — NOT NULL
  • PurchaseDate (Field) — datetime

Supplier (Untitled5)

  • SupplierID (Key) — varchar(10) — Primary key — NOT NULL
  • SupplierName (Field) — varchar(50)
  • CIty (Field2) — varchar(30)
  • State (Field25) — varchar(30)
  • Zip (Field3) — varchar(10)
  • Phone (Field4) — varchar(20)

purchaseLine (Untitled7)

  • ItemNum (PK,FK) — varchar(10) — Foreign key → Item.ItemNum — NOT NULL
  • PurchaseID (PK/FK) — varchar(10) — Foreign key → Purchase.PurchaseID — NOT NULL
  • Qty (Field) — int