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