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