20121022_2

gistfile1.txt

mysql> desc SALES;
+----------------+---------+------+-----+---------+-------+
| Field          | Type    | Null | Key | Default | Extra |
+----------------+---------+------+-----+---------+-------+
| SALES_DATE     | date    | YES  | MUL | NULL    |       |
| SALES_VOLUME   | int(11) | YES  |     | 0       |       |
| SALESPERSON_ID | int(11) | NO   | PRI | NULL    |       |
+----------------+---------+------+-----+---------+-------+

mysql> desc SALESPERSON;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| SALESPERSON_ID   | mediumint(9) | NO   | PRI | NULL    |       |
| SALESPERSON_NAME | varchar(255) | NO   |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+

mysql> desc SALES_REPORT;
+---------------------------+---------+------+-----+------------+-------+
| Field                     | Type    | Null | Key | Default    | Extra |
+---------------------------+---------+------+-----+------------+-------+
| SALES_DATE                | date    | NO   | PRI | 0000-00-00 |       |
| INSERT_SALESPERSON_NUMBER | int(11) | YES  |     | 0          |       |
| TOTAL_SALES_VOLUME        | int(11) | YES  |     | 0          |       |
+---------------------------+---------+------+-----+------------+-------+