ㄴ
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