HelpDesk

Tables (23)

APPROVER_GROUP

  • group_seq — BIGINT — Primary key — NOT NULL
  • group_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • description — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

APPROVER_GROUP_MEMBER

  • group_seq — BIGINT — Primary key — NOT NULL
  • user_seq — BIGINT — Primary key — NOT NULL

AUTH_PERMISSION

  • perm_seq — BIGINT — Primary key — NOT NULL
  • perm_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • created_at — DATETIME — NOT NULL

AUTH_ROLE

  • role_seq — BIGINT — Primary key — NOT NULL
  • role_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • created_at — DATETIME — NOT NULL

AUTH_ROLE_PERMISSION

  • role_seq — BIGINT — Primary key — NOT NULL
  • perm_seq — BIGINT — Primary key — NOT NULL

AUTH_USER_ROLE

  • user_seq — BIGINT — Primary key — NOT NULL
  • role_seq — BIGINT — Primary key — NOT NULL

FLOW_DEF

  • flow_seq — BIGINT — Primary key — NOT NULL
  • flow_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • version — INT — NOT NULL
  • scope_type — ENUM('GLOBAL','DEPT','TEAM','CATEGORY') — NOT NULL
  • scope_ref — BIGINT
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

FLOW_STEP

  • step_seq — BIGINT — Primary key — NOT NULL
  • flow_seq — BIGINT — NOT NULL
  • step_no — INT — NOT NULL
  • step_type — ENUM('APPROVAL','CONSENT','CC') — NOT NULL
  • approver_rule_type — ENUM('USER','ROLE','TEAM_LEAD','DEPT_HEAD','MANAGER','GROUP') — NOT NULL
  • approver_rule_ref — VARCHAR(64)
  • policy — ENUM('ANY','ALL') — NOT NULL
  • min_approvals — INT
  • parallel_group_id — VARCHAR(64)
  • due_in_hours — INT
  • escalation_rule_json — JSON

FORM_DEF

  • form_seq — BIGINT — Primary key — NOT NULL
  • form_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • version — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

FORM_FIELD

  • field_seq — BIGINT — Primary key — NOT NULL
  • form_seq — BIGINT — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • label — VARCHAR(128) — NOT NULL
  • type — VARCHAR(32) — NOT NULL
  • required — TINYINT(1) — NOT NULL
  • options_json — JSON
  • order_no — INT — NOT NULL

ORG_DEPARTMENT

  • dept_seq — BIGINT — Primary key — NOT NULL
  • dept_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ORG_TEAM

  • team_seq — BIGINT — Primary key — NOT NULL
  • team_id — VARCHAR(64) — NOT NULL
  • dept_seq — BIGINT — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ORG_USER

  • user_seq — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • email — VARCHAR(160) — NOT NULL
  • title — VARCHAR(128)
  • dept_seq — BIGINT
  • team_seq — BIGINT
  • manager_user_seq — BIGINT
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

SRV_CATEGORY

  • category_seq — BIGINT — Primary key — NOT NULL
  • category_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

TICKET

  • ticket_seq — BIGINT — Primary key — NOT NULL
  • ticket_id — VARCHAR(64) — NOT NULL
  • requester_seq — BIGINT — NOT NULL
  • dept_seq — BIGINT
  • team_seq — BIGINT
  • category_seq — BIGINT — NOT NULL
  • form_seq — BIGINT
  • subject — VARCHAR(200) — NOT NULL
  • priority — ENUM('LOW','MEDIUM','HIGH','CRITICAL') — NOT NULL
  • status — ENUM('DRAFT','SUBMITTED','IN_REVIEW','APPROVED','REJECTED','IN_PROGRESS','RESOLVED','CLOSED','CANCELED') — NOT NULL
  • current_step_no — INT
  • sla_due_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • closed_at — DATETIME

TICKET_ATTACHMENT

  • attach_seq — BIGINT — Primary key — NOT NULL
  • ticket_seq — BIGINT — NOT NULL
  • uploader_seq — BIGINT — NOT NULL
  • file_key — VARCHAR(200) — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • content_type — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

TICKET_COMMENT

  • comment_seq — BIGINT — Primary key — NOT NULL
  • ticket_seq — BIGINT — NOT NULL
  • author_seq — BIGINT — NOT NULL
  • visibility — ENUM('INTERNAL','PUBLIC') — NOT NULL
  • body — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

TICKET_FIELD_VALUE

  • value_seq — BIGINT — Primary key — NOT NULL
  • ticket_seq — BIGINT — NOT NULL
  • field_seq — BIGINT — NOT NULL
  • value_text — TEXT
  • value_num — DECIMAL(20,6)
  • value_json — JSON

TICKET_FLOW

  • ticket_flow_seq — BIGINT — Primary key — NOT NULL
  • ticket_seq — BIGINT — NOT NULL
  • flow_seq — BIGINT — NOT NULL
  • flow_version — INT — NOT NULL
  • status — ENUM('PENDING','IN_PROGRESS','COMPLETED','REJECTED','CANCELED') — NOT NULL
  • snapshot_json — JSON
  • started_at — DATETIME
  • finished_at — DATETIME

TICKET_HISTORY

  • history_seq — BIGINT — Primary key — NOT NULL
  • ticket_seq — BIGINT — NOT NULL
  • actor_seq — BIGINT
  • action_type — VARCHAR(64) — NOT NULL
  • from_value — VARCHAR(255)
  • to_value — VARCHAR(255)
  • meta_json — JSON
  • created_at — DATETIME — NOT NULL

TICKET_STEP

  • ticket_step_seq — BIGINT — Primary key — NOT NULL
  • ticket_flow_seq — BIGINT — NOT NULL
  • step_seq — BIGINT
  • step_no — INT — NOT NULL
  • step_type — ENUM('APPROVAL','CONSENT','CC') — NOT NULL
  • status — ENUM('PENDING','IN_PROGRESS','APPROVED','REJECTED','SKIPPED','CONSENTED') — NOT NULL
  • started_at — DATETIME
  • finished_at — DATETIME

TICKET_STEP_APPROVAL

  • approval_seq — BIGINT — Primary key — NOT NULL
  • ticket_step_seq — BIGINT — NOT NULL
  • approver_seq — BIGINT — NOT NULL
  • decision — ENUM('PENDING','APPROVED','REJECTED','CONSENTED') — NOT NULL
  • decided_at — DATETIME
  • comment — VARCHAR(500)

TICKET_WATCHER

  • ticket_seq — BIGINT — Primary key — NOT NULL
  • user_seq — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL