node_vimeo_db_schema_all.info

node_vimeo_db_schema_all.info

+-----------------+
| Tables_in_jsman |
+-----------------+
| articles        |
| movie           |
| newspaper       |
| user            |
+-----------------+
4 rows in set (0.00 sec)

mysql> desc articles;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| articleId   | int(16)      | NO   | PRI | NULL    | auto_increment |
| article     | varchar(100) | YES  |     | NULL    |                |
| companyName | varchar(16)  | YES  | MUL | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> desc movie;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| title | varchar(25) | YES  |     | NULL    |                |
| type  | varchar(10) | YES  |     | NULL    |                |
| grade | float(4,2)  | YES  |     | NULL    |                |
| actor | varchar(15) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> desc user;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| UID   | int(11)     | NO   | PRI | NULL    | auto_increment |
| EMAIL | varchar(64) | YES  |     | NULL    |                |
| NAME  | varchar(64) | YES  |     | NULL    |                |
| PW    | varchar(64) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)