Daily use
Field Name | Data Type | Field Length | Description | Key | Sample |
CustomerName | String | 15 | Name of Customer/Supplier | Thompson, Bob | |
CustomerPhone | String | 15 | Phone of Customer/Supplier | (509) 555-1298 | |
CustomerAddress | String | 45 | Address of Customer/Supplier | 1698 Mellowbrook Road | |
CustomerState | String | 15 | State of Customer/Supplier | WA | |
CustomerZip | Int | 9 | Zip of Customer/Supplier | 980045890 | |
CustomerInventory | Int | 15 | Customer Inventory in Queue | 16 | |
CustomerID | Int | 10 | Customer Primary Key | PK | 948920 |
ProductName | String | 15 | Product Name | Hammer | |
ProductCategory | String | 15 | Category of Product | Tools | |
ProductID | Int | 30 | Primary Key for Product | FK | 5432 |
ProductInventory | Int | 6 | Product Inventory in Warehouse | 32 | |
CustomerAcct | Int | 15 | Customer Account Number | FK | 84392795 |
PurchaseDate | Datetime | 8 | Date of Customer Purchase | FK | 12121986 |
ShipDate | Datetime | 8 | Date of Customer Product Ship | FK | 12121986 |