rts
Tables (11)
fucntions (functions)
- Key (id) — int — Primary key — NOT NULL
- Key (services_id) — int — Foreign key → services.Key — NOT NULL
- Field (function_id) — varchar
- Field (function_name) — varchar
history_procedure
- Key (id) — int — Primary key — NOT NULL
- Key (id2) — int — Foreign key → hitsory_testcase.Key — NOT NULL
- Key2 (testcase_id) — varchar — Foreign key → hitsory_testcase.Key2 — NOT NULL
- Field (procedure_id) — int
- Field (procedure) — varchar
- Field (expected_result) — varchar
hitsory_testcase (history_testcase)
- Key (id) — int — Primary key — NOT NULL
- Key2 (testcase_id) — varchar — Primary key — NOT NULL
- Field (summary) — varchar
- Field (precondition) — varchar
- Field (priority) — varchar
- Field (is_auto) — boolean
- Field (is_regression) — boolean
- Field (change_type) — varchar
- Field (author) — varchar
- Field (version) — int
- Field (chage_date) — datetime
problem
- Key (id) — int — Primary key — NOT NULL
- Key (history_id) — int — Foreign key → testhistory.Key — NOT NULL
- Field (project_id) — int
- Field (dooray_project) — varchar
- Field (dooray_id) — int
- Field (testcase_id) — varchar
- Field (author) — varchar
- Field (status) — varchar
- Field (grade) — varchar
- Field (problem) — varchar
- Field (condition) — varchar
- Field (attach_file) — file
- Field (comment) — varchar
- Field (service) — varchar
- Field (function) — varchar
- Field (created) — datetime
- Field (updated) — datetime
procedure
- Key (id) — int — Primary key — NOT NULL
- Key2 (testcase_id) — varchar — Foreign key → testcase.Key2 — NOT NULL
- Key (id2) — int — Foreign key → testcase.Key — NOT NULL
- Field (procedure_id) — int
- Field (procedure) — varchar
- Field (expected_result) — varchar
project_testcase
- Key (id) — int — Primary key — NOT NULL
- Key2 (testcase_id) — int — Foreign key → testcase.Key2 — NOT NULL
- Key (testproject_id) — int — Foreign key → testproject.Key — NOT NULL
services
- Key (id) — int — Primary key — NOT NULL
- Field (service_id) — varchar
- Field (service_names) — varchar
testcase
- Key (id) — int — Primary key — NOT NULL
- Key2 (testcase_id) — varchar — Primary key — NOT NULL
- Key (functions_id) — int — Foreign key → fucntions.Key — NOT NULL
- Field (summary) — varchar
- Field (precondition) — varchar
- Field (priority) — varchar
- Field (is_auto) — boolean
- Field (is_regression) — boolean
- Field (author) — varchar
- Field (created) — datetime
- Field (version) — int
- Field (updated) — datetime
testhistory
- Key (id) — int — Primary key — NOT NULL
- Key (project_id) — int — Foreign key → testproject.Key — NOT NULL
- Key (user_id) — int — Foreign key → users.Key — NOT NULL
- Field (testcase_id) — varchar
- Field (problem_id) — int
- Field (start_time) — datetime
- Field (end_time) — datetime
- Field (result) — varchar
- Field (test_time) — float
- Field (procedure_count) — int
testproject
- Key (id) — int — Primary key — NOT NULL
- Field (purpose) — varchar
- Field (manager) — varchar
- Field (author) — varchar
- Field (test_type) — varchar
- Field (start_date) — datetime
- Field2 (end_date) — datetime
- Field (description) — varchar
- Field (sw_version) — varchar
- Field (created) — datetime
- Field (updated) — datetime
- Field (dooray_project) — varchar
users
- Key (id) — int — Primary key — NOT NULL
- Field (user_name) — varchar
- Field (title) — varchar
- Field (email) — varchar
- Field (department) — varchar