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