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)
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