AW5-1
Tables (5)
CONTACT
- ContactID — AutoNumber — Primary key — NOT NULL
- Date — Date/Time — NOT NULL
- Type — Text — NOT NULL
- Remarks — Text
- CustomerID — AutoNumber — Foreign key → CUSTOMER.CustomerID — NOT NULL
CUSTOMER
- CustomerID — AutoNumber — Primary key — NOT NULL
- LastName — Text — NOT NULL
- FirstName — Text — NOT NULL
- Address — Text
- City — Text
- State — Text
- ZIPz (ZIP) — Text
- Phone — Text — NOT NULL
- Fax — Text
- E-mail — Text
- NickName — Text — Foreign key → SALESPERSON.NickName — NOT NULL
SALESPERSON
- NickName — Text — Primary key — NOT NULL
- LastName — Text — NOT NULL
- FirstName — Text — NOT NULL
- HireDate — Date/Time — NOT NULL
- WageRate — Double — NOT NULL
- CommissionRate — Double — NOT NULL
- Phone — Text — NOT NULL
- Email — Text — NOT NULL
SALESPERSON_VEHICLE_INT
- NickName (NickName2) — Text — Foreign key → SALESPERSON.NickName — NOT NULL
- InventoryID (InventoryID2) — AutoNumber — Foreign key → VEHICLE.InventoryID — NOT NULL
VEHICLE
- InventoryID — AutoNumber — Primary key — NOT NULL
- Model — Text — NOT NULL
- VIN — Text — NOT NULL