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