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