ㅠㅇㄹ
Tables (6)
command
- id — INT — Primary key — NOT NULL
- planId — INT — Foreign key → plan.id — NOT NULL
- command — VARCHAR(255) — NOT NULL
- target — VARCHAR(255) — NOT NULL
- value — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `fk_command_plan_idx`
commandResult
- id — INT — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- duration — DATETIME — NOT NULL
- planResultId — INT — Foreign key → planResult.id — NOT NULL
- commandInfo — VARCHAR(255) — NOT NULL
- result — TINYINT — NOT NULL
- INDEX — `fk_commandResult_planResult_idx`
environment
- id — INT — Primary key — NOT NULL
- service — VARCHAR(45) — NOT NULL
- header — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
plan
- id — INT — Primary key — NOT NULL
- projectId — INT — Foreign key → project.id — NOT NULL
- planName — VARCHAR(45) — NOT NULL
- siteUrl — VARCHAR(255) — NOT NULL
- description — VARCHAR(45)
- isActive — TINYINT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- lastRunTime — DATETIME
- INDEX — `fk_plan_project_idx`
planResult
- id — INT — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- result — TINYINT — NOT NULL
- planName — VARCHAR(45) — NOT NULL
- duration — DATETIME — NOT NULL
- browserInfo — VARCHAR(45) — NOT NULL
- executeBy — VARCHAR(45) — NOT NULL
- executeNode — VARCHAR(45) — NOT NULL
project
- id — INT — Primary key — NOT NULL
- projectName — VARCHAR(45) — NOT NULL
- role — VARCHAR(45) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- lastRunTime — DATETIME
- description — TEXT