mysql> desc image_locations;
+------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| image_id | varchar(36) | NO | MUL | NULL | |
| value | text | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | MUL | NULL | |
| meta_data | text | YES | | NULL | |
| status | varchar(30) | NO | | active | |
+------------+-------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
mysql> desc image_members;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| image_id | varchar(36) | NO | MUL | NULL | |
| member | varchar(255) | NO | | NULL | |
| can_share | tinyint(1) | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | MUL | NULL | |
| status | varchar(20) | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
mysql> desc image_properties;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| image_id | varchar(36) | NO | MUL | NULL | |
| name | varchar(255) | NO | | NULL | |
| value | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | MUL | NULL | |
+------------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)
mysql> desc image_tags;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| image_id | varchar(36) | NO | MUL | NULL | |
| value | varchar(255) | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)
mysql> desc images;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id | varchar(36) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| size | bigint(20) | YES | | NULL | |
| status | varchar(30) | NO | | NULL | |
| is_public | tinyint(1) | NO | MUL | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | MUL | NULL | |
| disk_format | varchar(20) | YES | | NULL | |
| container_format | varchar(20) | YES | | NULL | |
| checksum | varchar(32) | YES | MUL | NULL | |
| owner | varchar(255) | YES | MUL | NULL | |
| min_disk | int(11) | NO | | NULL | |
| min_ram | int(11) | NO | | NULL | |
| protected | tinyint(1) | YES | | NULL | |
| virtual_size | bigint(20) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
17 rows in set (0.00 sec)
mysql> desc metadef_namespace_resource_types;
+-------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| resource_type_id | int(11) | NO | PRI | NULL | |
| namespace_id | int(11) | NO | PRI | NULL | |
| properties_target | varchar(80) | YES | | NULL | |
| prefix | varchar(80) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
+-------------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
mysql> desc metadef_namespaces;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| namespace | varchar(80) | NO | UNI | NULL | |
| display_name | varchar(80) | YES | | NULL | |
| description | text | YES | | NULL | |
| visibility | varchar(32) | YES | | NULL | |
| protected | tinyint(1) | YES | | NULL | |
| owner | varchar(255) | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
mysql> desc metadef_objects;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| namespace_id | int(11) | NO | MUL | NULL | |
| name | varchar(80) | NO | | NULL | |
| description | text | YES | | NULL | |
| required | text | YES | | NULL | |
| json_schema | text | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
mysql> desc metadef_properties;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| namespace_id | int(11) | NO | MUL | NULL | |
| name | varchar(80) | NO | | NULL | |
| json_schema | text | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> desc metadef_resource_types;
+------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | NO | UNI | NULL | |
| protected | tinyint(1) | NO | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | | NULL | |
+------------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc migrate_version;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| repository_id | varchar(250) | NO | PRI | NULL | |
| repository_path | text | YES | | NULL | |
| version | int(11) | YES | | NULL | |
+-----------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc task_info;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| task_id | varchar(36) | NO | PRI | NULL | |
| input | text | YES | | NULL | |
| result | text | YES | | NULL | |
| message | text | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc tasks;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| id | varchar(36) | NO | PRI | NULL | |
| type | varchar(30) | NO | MUL | NULL | |
| status | varchar(30) | NO | MUL | NULL | |
| owner | varchar(255) | NO | MUL | NULL | |
| expires_at | datetime | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | YES | MUL | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | NO | MUL | NULL | |
+------------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
