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)