database

mysql> show tables;

+---------------+

| Tables_in_rec |

+---------------+

| item          |

| rate          |

| service_type  |

| user          |

 

 

mysql> describe item;

+-------------+--------------+------+-----+---------+----------------+

| Field       | Type         | Null | Key | Default | Extra          |

+-------------+--------------+------+-----+---------+----------------+

| id          | bigint(20)   | NO   | PRI | NULL    | auto_increment |

| name        | varchar(255) | YES  |     | NULL    |                |

| type_id     | bigint(20)   | NO   | MUL | NULL    |                |

| logo        | varchar(255) | YES  |     | NULL    |                |

| price       | float(18,2)  | YES  |     | NULL    |                |

| description | text         | NO   |     | NULL    |                |

| created_at  | datetime     | NO   |     | NULL    |                |

| updated_at  | datetime     | NO   |     | NULL    |                |

+-------------+--------------+------+-----+---------+----------------+

 

mysql> describe rate;

+------------+-------------+------+-----+---------+-------+

| Field      | Type        | Null | Key | Default | Extra |

+------------+-------------+------+-----+---------+-------+

| user_id    | bigint(20)  | NO   | PRI | 0       |       |

| item_id    | bigint(20)  | NO   | PRI | 0       |       |

| prate      | float(18,2) | NO   |     | NULL    |       |

| erate      | bigint(20)  | NO   |     | NULL    |       |

| srate      | bigint(20)  | NO   |     | NULL    |       |

| created_at | datetime    | NO   |     | NULL    |       |

| updated_at | datetime    | NO   |     | NULL    |       |

+------------+-------------+------+-----+---------+-------+

 

 

 

mysql> describe user;

+------------+--------------+------+-----+---------+----------------+

| Field      | Type         | Null | Key | Default | Extra          |

+------------+--------------+------+-----+---------+----------------+

| id         | bigint(20)   | NO   | PRI | NULL    | auto_increment |

| name       | varchar(255) | NO   |     | NULL    |                |

| age        | bigint(20)   | NO   |     | NULL    |                |

| password   | varchar(255) | NO   |     | NULL    |                |

| created_at | datetime     | NO   |     | NULL    |                |

| updated_at | datetime     | NO   |     | NULL    |                |

 

 

mysql> describe service_type;

+------------+--------------+------+-----+---------+----------------+

| Field      | Type         | Null | Key | Default | Extra          |

+------------+--------------+------+-----+---------+----------------+

| id         | bigint(20)   | NO   | PRI | NULL    | auto_increment |

| name       | varchar(255) | NO   | UNI | NULL    |                |

| created_at | datetime     | NO   |     | NULL    |                |

| updated_at | datetime     | NO   |     | NULL    |                |

+------------+--------------+------+-----+---------+----------------+

4 rows in set (0.03 sec)