Customers (Warehouse Customers)
Description
This table contains the list of customers who interact with the warehouse.
Columns
| Name | Title | Datatype | Nullable | Other | Description | Last edit |
|---|---|---|---|---|---|---|
| customer_id | int(11) | NO | auto_increment | 1 month ago | ||
| customer_name | Corporate name | varchar(100) | NO | Name of the customer, Corporate Name, for instance Coke Inc | 1 month ago | |
| contact_name | Person Name | varchar(50) | YES | 1 month ago | ||
| contact_phone | Phone | varchar(15) | YES | 1 month ago | ||
| contact_email | varchar(100) | YES | The email we should be using when contacting them | 1 month ago | ||
| address | Mailing address in US | text | YES | 1 month ago |