Table descriptions

gistfile1.txt

+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | int(11)      | NO   | PRI | NULL    | auto_increment |
| ProductName     | varchar(255) | YES  |     | NULL    |                |
| ProductPrice    | float        | YES  |     | NULL    |                |
| ProductQuantity | int(11)      | YES  |     | NULL    |                |
| ProductSupplier | int(11)      | YES  |     | NULL    |                |
| created_at      | datetime     | NO   |     | NULL    |                |
| updated_at      | datetime     | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

+-----------------+----------+------+-----+---------+----------------+
| Field           | Type     | Null | Key | Default | Extra          |
+-----------------+----------+------+-----+---------+----------------+
| id              | int(11)  | NO   | PRI | NULL    | auto_increment |
| OrderID         | int(11)  | YES  | MUL | NULL    |                |
| ProductID       | int(11)  | YES  | MUL | NULL    |                |
| QuantityOrdered | int(11)  | YES  |     | NULL    |                |
| created_at      | datetime | NO   |     | NULL    |                |
| updated_at      | datetime | NO   |     | NULL    |                |
+-----------------+----------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

+------------+----------+------+-----+---------+----------------+
| Field      | Type     | Null | Key | Default | Extra          |
+------------+----------+------+-----+---------+----------------+
| id         | int(11)  | NO   | PRI | NULL    | auto_increment |
| ClientID   | int(11)  | YES  | MUL | NULL    |                |
| OrderTotal | float    | YES  |     | NULL    |                |
| created_at | datetime | NO   |     | NULL    |                |
| updated_at | datetime | NO   |     | NULL    |                |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)