ㄴ

Tables (4)

t_incident

  • id — BINARY(16) — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • request_dt — DATETIME
  • accept_dt — DATETIME
  • end_dt — DATETIME
  • status — ENUM('Completed', 'Incomplete')
  • priority — ENUM('URGENT', 'RELAXED')
  • ticket_by_id — BINARY(16)
  • requester_by_id — BINARY(16)
  • creator_by_id — BINARY(16)
  • charger_by_id — BINARY(16)
  • requester — VARCHAR(255)
  • creator — VARCHAR(255)
  • charger — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

t_user

  • id — BINARY(16) — Primary key — NOT NULL
  • name — VARCHAR(255)
  • category — ENUM('REQUESTER', 'CREATOR', 'CHARGER')
  • created_at — DATETIME
  • updated_at — DATETIME

task

  • id — BINARY(16) — Primary key — NOT NULL
  • active — BIT(1) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • progress_rate — INT
  • accepted_at — DATETIME(6)
  • charger_id — BIGINT — NOT NULL
  • closed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • creator_id — BIGINT — NOT NULL
  • modified_at — DATETIME(6)
  • plan_duration — DATETIME(6)
  • plan_end_date — DATETIME(6)
  • plan_start_date — DATETIME(6)
  • ticket_plan_end_date — DATETIME(6)
  • ticket_plan_start_date — DATETIME(6)
  • incident_id — BINARY(16)
  • ticket_id — BINARY(16)
  • charger_dept — VARCHAR(255)
  • charger_name — VARCHAR(255)
  • content — TEXT
  • creator_name — VARCHAR(255)
  • name — VARCHAR(255)
  • status_code — VARCHAR(255)
  • approval_status — ENUM('APPROVED', 'PENDING', 'REJECTED')
  • status — ENUM('COMPLETED', 'IN_PROGRESS', 'NOT_STARTED') — NOT NULL

ticket

  • ticket_id — BINARY(16) — Primary key — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • ticket_active — BIT(1) — NOT NULL
  • ticket_status_code — INT
  • accepted_at — DATETIME(6)
  • closed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6)
  • ticket_plan_duration — DATETIME(6)
  • ticket_plan_end_date — DATETIME(6)
  • ticket_plan_start_date — DATETIME(6)
  • incident_id — BINARY(16)
  • acceptor_id — VARCHAR(255)
  • acceptor_name — VARCHAR(255)
  • creator_id — VARCHAR(255)
  • creator_name — VARCHAR(255)
  • requester_id — VARCHAR(255) — NOT NULL
  • requester_name — VARCHAR(255)
  • ticket_content — TEXT
  • ticket_name — VARCHAR(255)
  • ticket_status — ENUM( 'ACTIVATE_EXECUTION', 'CANCEL_EXECUTION', 'COMPLETE_ASSIGN_CREATOR', 'COMPLETE_EXECUTION', 'DEACTIVATE_EXECUTION', 'PAUSED_EXECUTION', 'PENDING_EXECUTION', 'REQUEST_CREATE_TICKET' ) — NOT NULL