checkList

Tables (9)

ScenarioResult (scenarioResult)

  • testName (scenarioResultId) — Primary key — NOT NULL
  • scenarioId (scenarioInfoId) — Foreign key → scenarioInfo.scenarioId — NOT NULL
  • Key (scenarioGroupId) — Foreign key → scenarioInfo.Key — NOT NULL
  • testDate

Untitled (scenarioGroup)

  • Key (scenarioGroupId) — Primary key — NOT NULL
  • Field (registerDate)
  • Field (scenarioGroupName)
  • Field (userId)

Untitled (요청서)

    scenarioInfo

    • scenarioId (scenarioInfoId) — Primary key — NOT NULL
    • testScenarioCategoryId (scenarioCategoryId) — Foreign key → testScenarioCategory.testScenarioCategoryId — NOT NULL
    • Key (scenarioGroupId) — Foreign key → Untitled.Key — NOT NULL
    • scenarioName
    • Field (taskType)
    • Field (remark)
    • Field (testStartDate)
    • Field2 (testEndDate)
    • Field (documentNoId)

    testInfo

    • testId (testInfoId) — Primary key — NOT NULL
    • scenarioId (scenarioInfoId) — Foreign key → scenarioInfo.scenarioId — NOT NULL
    • Key (scenarioGroupId) — Foreign key → scenarioInfo.Key — NOT NULL
    • sequence (taskPhase)
    • testName
    • expectedResult (sequence)
    • Field (expectedResult)

    testItemInfo

    • testItemId (testItemInfoId) — Primary key — NOT NULL
    • testId (scenarioInfoId) — Foreign key → testInfo.testId — NOT NULL
    • Key (scenarioGroupId) — Foreign key → testInfo.Key — NOT NULL
    • sequence (testContent)

    testItemResult

    • testItemResultId — Primary key — NOT NULL
    • testResultId — Foreign key → testResult.testResultId — NOT NULL
    • testItemId (testItemInfoId) — Foreign key → testItemInfo.testItemId — NOT NULL
    • Key (scenarioGroupId) — Foreign key → testItemInfo.Key — NOT NULL
    • testResultDescription
    • testResult
    • isApproved (testDate)
    • testDate (uiManagerId)
    • uiManagerId (blManagerId)
    • blManagerId (isResolved)
    • isResolved (approveManager)
    • approveManager (isApproved)
    • comment

    testResult

    • testResultId — Primary key — NOT NULL
    • scenarioResultId — Foreign key → ScenarioResult.testName — NOT NULL
    • testId (testInfoId) — Foreign key → testInfo.testId — NOT NULL
    • Key (scenarioGroupId) — Foreign key → testInfo.Key — NOT NULL
    • stage

    testScenarioCategory (scenarioCategory)

    • testScenarioCategoryId (scenarioCategoryId) — Primary key — NOT NULL
    • name