Entities & MySQL Database Tables
mysql> show tables;
+-------------------------+
| Tables_in_smallwindow21 |
+-------------------------+
| category |
| databasechangelog |
| databasechangeloglock |
| employee |
| file |
| jhi_authority |
| jhi_user |
| jhi_user_authority |
| rel_skill__category |
| rel_skill__employee |
| skill |
+-------------------------+
11 rows in set (0.06 sec)
mysql> describe category;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| category_name | varchar(255) | NO | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> describe employee;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| first_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| email | varchar(255) | NO | | NULL | |
| s_3_image_key | varchar(255) | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> describe file;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| s_3_file_key | varchar(255) | YES | | NULL | |
| employee_id | bigint | YES | MUL | NULL | |
+--------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> describe skill;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| title | varchar(255) | YES | | NULL | |
| description | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> describe jhi_user;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| login | varchar(50) | NO | UNI | NULL | |
| password_hash | varchar(60) | NO | | NULL | |
| first_name | varchar(50) | YES | | NULL | |
| last_name | varchar(50) | YES | | NULL | |
| email | varchar(191) | YES | UNI | NULL | |
| image_url | varchar(256) | YES | | NULL | |
| activated | bit(1) | NO | | NULL | |
| lang_key | varchar(10) | YES | | NULL | |
| activation_key | varchar(20) | YES | | NULL | |
| reset_key | varchar(20) | YES | | NULL | |
| created_by | varchar(50) | NO | | NULL | |
| created_date | timestamp | YES | | NULL | |
| reset_date | timestamp | YES | | NULL | |
| last_modified_by | varchar(50) | YES | | NULL | |
| last_modified_date | timestamp | YES | | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
16 rows in set (0.01 sec)
mysql> describe jhi_user_authority;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| user_id | bigint | NO | PRI | NULL | |
| authority_name | varchar(50) | NO | PRI | NULL | |
+----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe jhi_authority;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(50) | NO | PRI | NULL | |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> describe rel_skill__category;
+-------------+--------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------+------+-----+---------+-------+
| category_id | bigint | NO | PRI | NULL | |
| skill_id | bigint | NO | PRI | NULL | |
+-------------+--------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe rel_skill__employee;
+-------------+--------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------+------+-----+---------+-------+
| employee_id | bigint | NO | PRI | NULL | |
| skill_id | bigint | NO | PRI | NULL | |
+-------------+--------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe databasechangelog;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| ID | varchar(255) | NO | | NULL | |
| AUTHOR | varchar(255) | NO | | NULL | |
| FILENAME | varchar(255) | NO | | NULL | |
| DATEEXECUTED | datetime | NO | | NULL | |
| ORDEREXECUTED | int | NO | | NULL | |
| EXECTYPE | varchar(10) | NO | | NULL | |
| MD5SUM | varchar(35) | YES | | NULL | |
| DESCRIPTION | varchar(255) | YES | | NULL | |
| COMMENTS | varchar(255) | YES | | NULL | |
| TAG | varchar(255) | YES | | NULL | |
| LIQUIBASE | varchar(20) | YES | | NULL | |
| CONTEXTS | varchar(255) | YES | | NULL | |
| LABELS | varchar(255) | YES | | NULL | |
| DEPLOYMENT_ID | varchar(10) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
mysql> describe databasechangeloglock;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| ID | int | NO | PRI | NULL | |
| LOCKED | bit(1) | NO | | NULL | |
| LOCKGRANTED | datetime | YES | | NULL | |
| LOCKEDBY | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
4 rows in set (0.01 sec)