Carbon River Furniture Sales Order Form

Tables (5)

CUSTOMER

  • Name — VARCHAR — Primary key — NOT NULL
  • Address — VARCHAR
  • City — VARCHAR
  • State — VARCHAR
  • zip (Zip) — INT
  • Phone — VARCHAR

ORDER_LINE_ITEM

  • LineNumber — INT — Primary key — NOT NULL
  • Key (SalesOrderNumber) — INT — Primary key — NOT NULL
  • OrderNumber (OrderNumber2) — INT — Foreign key → SALES_ORDER.OrderNumber — NOT NULL
  • Field (Quantity) — INT
  • Field (UntilPrice) — INT
  • Field (Extended Price) — INT
  • Key (ItemNumber) — INT — Foreign key → Untitled.Key — NOT NULL

SALESPERSON

  • SalesPersonName — VARCHAR — Primary key — NOT NULL
  • SalesPersonCode — VARCHAR

SALES_ORDER

  • OrderNumber — INT — Primary key — NOT NULL
  • Date — INT
  • Subtotal (SubTotal) — INT
  • Tax — INT
  • Total — INT
  • SalesPersonName — VARCHAR — Foreign key → SALESPERSON.SalesPersonName — NOT NULL
  • Name (Name2) — VARCHAR — Foreign key → CUSTOMER.Name — NOT NULL

Untitled (ITEM)

  • Key (ItemNumber) — INT — Primary key — NOT NULL
  • Field (Description) — VARCHAR