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