Customers;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| CustomerID   | int          | NO   | PRI | NULL    | auto_increment |
| CustomerName | varchar(255) | YES  |     | NULL    |                |
| ContactName  | varchar(255) | YES  |     | NULL    |                |
| Address      | varchar(255) | YES  |     | NULL    |                |
| City         | varchar(255) | YES  |     | NULL    |                |
| PostalCode   | varchar(255) | YES  |     | NULL    |                |
| Country      | varchar(255) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

Employees;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| EmployeeID | int          | NO   | PRI | NULL    | auto_increment |
| LastName   | varchar(255) | YES  |     | NULL    |                |
| FirstName  | varchar(255) | YES  |     | NULL    |                |
| BirthDate  | date         | YES  |     | NULL    |                |
| Photo      | varchar(255) | YES  |     | NULL    |                |
| Notes      | text         | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

Shippers;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ShipperID   | int          | NO   | PRI | NULL    | auto_increment |
| ShipperName | varchar(255) | YES  |     | NULL    |                |
| Phone       | varchar(255) | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+

Orders;
+------------+------+------+-----+---------+----------------+
| Field      | Type | Null | Key | Default | Extra          |
+------------+------+------+-----+---------+----------------+
| OrderID    | int  | NO   | PRI | NULL    | auto_increment |
| CustomerID | int  | YES  | MUL | NULL    |                |
| EmployeeID | int  | YES  | MUL | NULL    |                |
| OrderDate  | date | YES  |     | NULL    |                |
| ShipperID  | int  | YES  | MUL | NULL    |                |
+------------+------+------+-----+---------+----------------+

OrderDetails;
+---------------+------+------+-----+---------+----------------+
| Field         | Type | Null | Key | Default | Extra          |
+---------------+------+------+-----+---------+----------------+
| OrderDetailID | int  | NO   | PRI | NULL    | auto_increment |
| OrderID       | int  | YES  | MUL | NULL    |                |
| ProductID     | int  | YES  | MUL | NULL    |                |
| Quantity      | int  | YES  |     | NULL    |                |
+---------------+------+------+-----+---------+----------------+

Products;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ProductID   | int          | NO   | PRI | NULL    | auto_increment |
| ProductName | varchar(255) | YES  |     | NULL    |                |
| SupplierID  | int          | YES  | MUL | NULL    |                |
| CategoryID  | int          | YES  | MUL | NULL    |                |
| Unit        | varchar(255) | YES  |     | NULL    |                |
| Price       | double       | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+

Suppliers;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| SupplierID   | int          | NO   | PRI | NULL    | auto_increment |
| SupplierName | varchar(255) | YES  |     | NULL    |                |
| ContactName  | varchar(255) | YES  |     | NULL    |                |
| Address      | varchar(255) | YES  |     | NULL    |                |
| City         | varchar(255) | YES  |     | NULL    |                |
| PostalCode   | varchar(255) | YES  |     | NULL    |                |
| Country      | varchar(255) | YES  |     | NULL    |                |
| Phone        | varchar(255) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

Categories;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| CategoryID   | int          | NO   | PRI | NULL    | auto_increment |
| CategoryName | varchar(255) | YES  |     | NULL    |                |
| Description  | varchar(255) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+