DB ClientsBase

ClientsBase

mysql> show tables;
+-----------------------+
| Tables_in_clientsbase |
+-----------------------+
| addresses             |
| client_course         |
| clients               |
| courses               |
| groups                |
+-----------------------+
5 rows in set (0.00 sec)

mysql> describe Clients;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | int(11)      | NO   | PRI | NULL    | auto_increment |
| group_id      | int(11)      | YES  | MUL | NULL    |                |
| address_id    | int(11)      | YES  | MUL | NULL    |                |
| name          | varchar(128) | YES  |     | NULL    |                |
| surname       | varchar(128) | YES  |     | NULL    |                |
| email         | varchar(128) | YES  |     | NULL    |                |
| phone         | varchar(12)  | NO   |     | NULL    |                |
| discriminator | varchar(31)  | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)

mysql> describe addresses;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| country | varchar(50)  | NO   |     | NULL    |                |
| city    | varchar(128) | NO   |     | NULL    |                |
| house   | int(11)      | NO   |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> describe courses;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| comment | text         | YES  |     | NULL    |                |
| name    | varchar(255) | NO   |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
3 rows in set (0.07 sec)

mysql> describe groups;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| name    | varchar(128) | NO   |     | NULL    |                |
| comment | text         | YES  |     | NULL    |                |
| date    | date         | YES  |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> describe client_course;
+-----------+---------+------+-----+---------+-------+
| Field     | Type    | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| client_id | int(11) | NO   | MUL | NULL    |       |
| course_id | int(11) | NO   | MUL | NULL    |       |
+-----------+---------+------+-----+---------+-------+
2 rows in set (0.01 sec)