Increase
Tables (8)
Untitled (INVENTORY)
- Key (Item #) — INT — Primary key — NOT NULL
- Field (Description) — TEXT
- Field2 (Unit Price) — NUMERIC(20,2)
- Field3 (Quantity on Hand) — INT
Untitled (INVOICE-INVENTORY)
- Key (Invoice #) — INT — Primary key — NOT NULL
- Key2 (Item #) — INT — Primary key — NOT NULL
- Field (Quantity) — INT
Untitled (INVOICE TABLE)
- Key (Invoice #) — INT — Primary key — NOT NULL
- Field (Date) — DATE
- Field2 (CustomerID) — INT
- Field3 (Amount) — NUMBERIC(20,0)
Untitled (CUSTOMER)
- Key (CustomerID) — INT — Primary key — NOT NULL
- Field (LastName) — TEXT
- Field2 (FirstName) — TEXT
- Field3 (Address1) — TEXT
- Field4 (City) — TEXT
- Field5 (State) — TEXT
- Field6 (ZipCode) — INT
- Field7 (EmailID) — TEXT
- Field8 (PhoneNumber) — INT
Untitled (PRODUCT)
- Key (Item #) — INT — Primary key — NOT NULL
- Field (Description) — TEXT
- Field2 (Unit Cost) — UNMERIC (20,0)
Untitled (PURCHASE-PRODUCT)
- Key (Purchase Order #) — INT — Primary key — NOT NULL
- Key2 (Item #) — INT — Primary key — NOT NULL
- Field (Quantity Ordered) — INT
Untitled (PURCHASE ORDER)
- Key (Purchase Order #) — INT — Primary key — NOT NULL
- Field (Vendor #) — INT
- Field2 (Purchase Order) — DATE
- Field3 (Amount) — NUMBERIC(40,2)
Untitled (VENDOR)
- Key (Vendor #) — INT — Primary key — NOT NULL
- Field (Vendor Name) — TEXT
- Field2 (Address1) — TEXT
- Field3 (City) — TEXT
- Field4 (State) — TEXT
- Field5 (ZipCode) — INT
- Field6 (EmailID) — TEXT
- Field7 (PhoneNumber) — INT