TestManagementTool ERD
Tables (11)
Build (build)
- BuildId (build_id) — BigInt — Primary key — NOT NULL
- BuildTitle (build_title) — VARCHAR
- BuildVersion (build_version) — BigInt
- BuildStartDueDate (build_start_due_date) — Char
- BuildEndDueDate (build_end_due_date) — Char
CommonCodeDetail (common_code_detail)
- CodeDetailId (code_detail_id) — BigInt — Primary key — NOT NULL
- CodeDetailName (code_detail_name) — VARCHAR
- CodeDetailDescribe (code_detail_describe) — VARCHAR
- Sequence (sequence)
- UseStatus (use_status)
- CodeGroupId (code_group_id) — BigInt — Foreign key → CommonCodeGroup.CodeGroupId — NOT NULL
CommonCodeGroup (common_code_group)
- CodeGroupId (code_group_id) — BigInt — Primary key — NOT NULL
- CodeGroupName (code_group_name) — VARCHAR
- CodeGroupDescribe (code_group_describe) — VARCHAR
- Sequence (sequence)
- UseStatus (use_status)
Defect (defect)
- DefectId (defect_id) — BigInt — Primary key — NOT NULL
- ExecutionId (execution_id) — BigInt — Foreign key → Execution.ExecutionId — NOT NULL
- ExecutionDueDate (execution_due_date) — Char
- ExecutionResult (execution_result) — VARCHAR
- ExecutionAssignee (execution_assignee) — VARCHAR
- DefectStaratDueDate (defect_start_due_date) — Char
- DefectEndDueDate (defect_end_due_date) — Char
- DefectDetail (defect_detail) — VARCHAR
- DefectState (defect_state) — VARCHAR
- CreatedAt (create_at) — Char
- CreatedBy (created_by) — VARCHAR
- ModifiedAt (modified_at) — Char
- ModifiedBy (modified_by) — VARCHAR
Defect History (defect_history)
- DefectHistoryId (defect_history_id) — BigInt — Primary key — NOT NULL
- DefectId (defect_id) — BigInt — Foreign key → Defect.DefectId — NOT NULL
- Field (DefectState) — VARCHAR
- Field (DefectDetail) — VARCHAR
- CreatedAt (created_at) — Char
- CreatedBy (created_by) — Char
Execution (execution)
- ExecutionId (execution_id) — BigInt — Primary key — NOT NULL
- ProjectId (project_Id) — BigInt — Foreign key → Project.ProjectId — NOT NULL
- TestPlanTitle (test_plan_title) — VARCHAR
- BuildTItle (build_title) — VARCHAR
- BuildVersion (build_version) — BigInt — build title에 _numbering으로 나눌까
- TestSuiteTitle (test_suite_title) — VARCHAR
- TestCaseTItle (test_case_title) — VARCHAR
- ExecutionDueDate (execution_due_date) — Char
- ExecutionResult (execution_result) — VARCHAR
- ExecutionAssignee (execution_assignee) — VARCHAR
- ExecutionDate (execution_dated) — Char
- CreatedAt (create_at) — Char
- CreatedBy (created_by) — VARCHAR
- ModifiedBy (modified_by) — VARCHAR — ExecutionedBy
Plan (plan)
- PlanId (plan_id) — BigInt — Primary key — NOT NULL
- PlanaTitle (plan_title) — VARCHAR
- BuildVersion (build_version) — BigInt
Project (project)
- ProjectId (project_Id) — BigInt — Primary key — NOT NULL
- ProjectTitle (project_title) — VARCHAR
Roll
- RollId (roll_di) — BigInt — Primary key — NOT NULL
- RollName (roll_name) — VARCHAR
- RollDetail (roll_detail) — VARCHAR
- Roll (roll) — VARCHAR
- UserRollId (user_roll_id) — BigInt — Foreign key → UserRoll.UserRollId — NOT NULL
User (user)
- Id (id) — BigInt — Primary key — NOT NULL
- UserId (user_id) — VARCHAR
- UserPassword (user_password) — VARCHAR
- UserName (user_name) — VARCHAR
- UserEmail (user_email) — VARCHAR
- UserRollId (user_roll_id) — BigInt — Foreign key → UserRoll.UserRollId — NOT NULL
UserRoll (user_roll)
- UserRollId (user_roll_id) — BigInt — Primary key — NOT NULL