TestDB

Tables (20)

abstract_scn

  • abstract_scn_id — INT — Primary key — NOT NULL
  • functional_scn_id — INT — Foreign key → functional_scn.functional_scn_id — NOT NULL
  • template_id — INT — Foreign key → scn_template.template_id — NOT NULL
  • Description (description) — VARCHAR(45)

behavior

  • behavior_id — INT — Primary key — NOT NULL
  • Field2

behavior_parameter (behavior_attribute)

  • behavior_param_id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • value — DOUBLE

concrete_scn

  • concrete_scn_id — INT — Primary key — NOT NULL
  • logical_scn_id — INT — Foreign key → logical_scn.logical_scn_id — NOT NULL
  • Description (description) — VARCHAR(45)

functional_scn

  • functional_scn_id — INT — Primary key — NOT NULL
  • Description (description) — VARCHAR(45)

logical_scn

  • logical_scn_id — INT — Primary key — NOT NULL
  • abstract_scn_id — INT — Foreign key → abstract_scn.abstract_scn_id — NOT NULL
  • Description (description) — VARCHAR(45)

object

  • object_id — INT — Primary key — NOT NULL
  • type — VARCHAR(45)
  • Field

req_functional_scn_link

  • link_id — INT — Primary key — NOT NULL
  • req_id — INT — Foreign key → requirement.req_id — NOT NULL
  • functional_scn_id — INT — Foreign key → functional_scn.functional_scn_id — NOT NULL

req_param_val

  • param_id — INT — Primary key — NOT NULL
  • concrete_scn_id — INT — Foreign key → concrete_scn.concrete_scn_id — NOT NULL
  • value — DOUBLE

req_template

  • template_id — INT — Primary key — NOT NULL
  • Description (Field) — VARCHAR(45)

requirement

  • req_id — INT — Primary key — NOT NULL
  • polarion_req_id — INT
  • req_name — VARCHAR(45)

scn_param_val

  • param_val_id — INT — Primary key — NOT NULL
  • concrete_scn_id — INT — Foreign key → concrete_scn.concrete_scn_id — NOT NULL
  • value — DOUBLE

scn_req_link

  • link_id — INT — Primary key — NOT NULL
  • abstract_scn_id — INT — Foreign key → abstract_scn.abstract_scn_id — NOT NULL
  • req_template_id — INT — Foreign key → req_template.template_id — NOT NULL
  • template_id (template_id2) — INT — Foreign key → abstract_scn.template_id — NOT NULL

scn_tag_link

  • link_id — INT — Primary key — NOT NULL
  • abstract_scn_id — INT — Foreign key → abstract_scn.abstract_scn_id — NOT NULL
  • tag_id (Key) — INT — Foreign key → tag.tag_id — NOT NULL
  • template_id — INT — Foreign key → abstract_scn.template_id — NOT NULL

scn_template

  • template_id — INT — Primary key — NOT NULL
  • Description (Field) — VARCHAR(45)

scn_template_parameter

  • template_param_id — INT — Primary key — NOT NULL
  • template_id — INT — Foreign key → scn_template.template_id — NOT NULL
  • param_name — VARCHAR(45)

speed_profile

  • sp_id — INT — Primary key — NOT NULL
  • Field

speed_profile_parameter (speed_profile_attribute)

  • sp_param_id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • value — DOUBLE

tag

  • tag_id (Key) — INT — Primary key — NOT NULL
  • tag_name — VARCHAR(45)

test_result (Untitled5)

  • test_id (Key) — Primary key — NOT NULL
  • 기존 이랑 연결 (Field)