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