show tables; #2024/1/14
+------------------------+
| Tables_in_testanchorDB |
+------------------------+
| comments |
| milestones |
| permissions |
| projects |
| roles |
| statuses |
| test_cases |
| test_plans |
| test_run_cases |
| test_runs |
| test_suites |
| user_roles |
| users |
+------------------------+
----------
comments
C
R
D
+------------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| test_run_case_id | bigint unsigned | YES | MUL | NULL | |
| status_id | bigint unsigned | YES | MUL | NULL | |
| content | longtext | YES | | NULL | |
| created_by_id | bigint unsigned | YES | MUL | NULL | |
| updated_by_id | bigint unsigned | YES | MUL | NULL | |
+------------------+-----------------+------+-----+---------+----------------+
-----------
milestones
C
R
D
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| project_id | bigint unsigned | YES | MUL | NULL | |
| title | longtext | YES | | NULL | |
| description | longtext | YES | | NULL | |
| status | longtext | YES | | NULL | |
| due_date | datetime(3) | YES | | NULL | |
+-------------+-----------------+------+-----+---------+----------------+
-----------
permissions
C
R
D
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| name | longtext | YES | | NULL | |
| description | longtext | YES | | NULL | |
+-------------+-----------------+------+-----+---------+----------------+
-----------
projects
C ホーム→新しいプロジェクトの追加ボタン
R
D
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| code | varchar(191) | NO | UNI | NULL | |
| title | longtext | YES | | NULL | |
| description | longtext | YES | | NULL | |
+-------------+-----------------+------+-----+---------+----------------+
-----------
roles
C
R
D
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| name | longtext | YES | | NULL | |
| description | longtext | YES | | NULL | |
+-------------+-----------------+------+-----+---------+----------------+
-----------
statuses
C 初回build時
R
D
+------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| name | longtext | YES | | NULL | |
| color | longtext | YES | | NULL | |
| default | tinyint(1) | YES | | NULL | |
+------------+-----------------+------+-----+---------+----------------+
select * from statuses;
+----+-------------------------+-------------------------+------------+----------------+--------+---------+
| id | created_at | updated_at | deleted_at | name | color | default |
+----+-------------------------+-------------------------+------------+----------------+--------+---------+
| 1 | 2024-01-14 06:28:40.243 | 2024-01-14 06:28:40.243 | NULL | Untested | gray | 1 |
| 2 | 2024-01-14 06:28:40.247 | 2024-01-14 06:28:40.247 | NULL | Passed | green | 0 |
| 3 | 2024-01-14 06:28:40.250 | 2024-01-14 06:28:40.250 | NULL | Failed | red | 0 |
| 4 | 2024-01-14 06:28:40.252 | 2024-01-14 06:28:40.252 | NULL | In Progress | blue | 0 |
| 5 | 2024-01-14 06:28:40.253 | 2024-01-14 06:28:40.253 | NULL | Blocked | orange | 0 |
| 6 | 2024-01-14 06:28:40.255 | 2024-01-14 06:28:40.255 | NULL | Skipped | yellow | 0 |
| 7 | 2024-01-14 06:28:40.256 | 2024-01-14 06:28:40.256 | NULL | Not Applicable | cyan | 0 |
+----+-------------------------+-------------------------+------------+----------------+--------+---------+
-----------
test_cases
C テストスイート下のテストケースの追加より
R
D
+---------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| test_suite_id | bigint unsigned | YES | MUL | NULL | |
| project_id | bigint unsigned | YES | MUL | NULL | |
| milestone_id | bigint unsigned | YES | MUL | NULL | |
| title | longtext | YES | | NULL | |
| content | longtext | YES | | NULL | |
| order_index | bigint | YES | | NULL | |
| created_by_id | bigint unsigned | YES | MUL | NULL | |
| updated_by_id | bigint unsigned | YES | MUL | NULL | |
+---------------+-----------------+------+-----+---------+----------------+
-----------
test_plans
C
R
D
+---------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| project_id | bigint unsigned | YES | MUL | NULL | |
| status | longtext | YES | | NULL | |
| title | longtext | YES | | NULL | |
| started_at | datetime(3) | YES | | NULL | |
| completed_at | datetime(3) | YES | | NULL | |
| created_by_id | bigint unsigned | YES | MUL | NULL | |
| updated_by_id | bigint unsigned | YES | MUL | NULL | |
+---------------+-----------------+------+-----+---------+----------------+
-----------
test_run_cases
C
R
D
+----------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| test_case_id | bigint unsigned | YES | MUL | NULL | |
| test_run_id | bigint unsigned | YES | MUL | NULL | |
| assigned_to_id | bigint unsigned | YES | MUL | NULL | |
| status_id | bigint unsigned | YES | MUL | NULL | |
+----------------+-----------------+------+-----+---------+----------------+
-----------
test_suites
C TestCase画面({プロジェクト}/cases)のファイルボタン
R
D
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| project_id | bigint unsigned | YES | MUL | NULL | |
| name | longtext | YES | | NULL | |
| parent_id | bigint unsigned | YES | MUL | NULL | |
| order_index | bigint | YES | | NULL | |
+-------------+-----------------+------+-----+---------+----------------+
-----------
user_roles
C
R
D
+---------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| user_id | bigint unsigned | NO | PRI | NULL | |
| role_id | bigint unsigned | NO | PRI | NULL | |
+---------+-----------------+------+-----+---------+-------+
-----------
users
C 初回build時
R メンバー管理
D
+------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-----------------+------+-----+---------+----------------+
| id | bigint unsigned | NO | PRI | NULL | auto_increment |
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| deleted_at | datetime(3) | YES | MUL | NULL | |
| name | longtext | YES | | NULL | |
| email | longtext | YES | | NULL | |
| password | longtext | YES | | NULL | |設定→password変更
| status | longtext | YES | | NULL | |
| language | longtext | YES | | NULL | |設定→言語設定
+------------+-----------------+------+-----+---------+----------------+