SF DB v2.2
Tables (6)
Project (project)
- Key (project_idx) — INTEGER — Primary key — NOT NULL
- Key (project_hash) — TEXT — Primary key — NOT NULL
- Field (project_name) — TEXT
Protocol (protocol)
- Key (protocol_code) — INTEGER — Primary key — NOT NULL
- Field (protocol_name) — TEXT
Test Note (testnote)
- Key (note_idx) — INTEGER — Primary key — NOT NULL
- Field (tester_name) — TEXT
- Field (tester_tel) — TEXT
- Field (note_title) — TEXT
- Field (note_content) — TEXT
- Field (updated_date) — DATE
- Field (created_date) — DATE
Test Plan (testplan)
- Key (testplan_idx) — INTEGER — Primary key
- Field (setting) — BLOB
- Field (testcase) — BLOB
Test Progress (testprogress)
- Key (testprogress_idx) — INTEGER — Primary key — NOT NULL
- Key (project_idx) — INTEGER — Foreign key → Project.Key — NOT NULL
- Key (testplan_idx) — INTEGER — Foreign key → Test Plan.Key
- Key (result_idx) — INTEGER — Foreign key → Test Result.Key — NOT NULL
- Key (note_idx) — INTEGER — Foreign key → Test Result.Key — NOT NULL
- Key (protocol_code) — INTEGER — Foreign key → Protocol.Key — NOT NULL
- Field (test_mode)
- Field (start_date) — DATE
- Field (end_date) — DATE
- Field (current_case_order) — INTEGER
Test Result (testresult)
- Key (result_idx) — INTEGER — Primary key — NOT NULL
- Key (note_idx) — INTEGER — Foreign key → Test Note.Key — NOT NULL
- Field (log) — BLOB
- Field (statistics) — BLOB
- Field (result_name) — TEXT
- Field (test_state) — INTEGER
- Field (test_run_time) — DATE
- Field (total_case_count) — INTEGER
- Field (passed_case_count) — INTEGER
- Field (failed_case_count) — INTEGER
- Field (others_case_count) — INTEGER