전자결재v2
테이블 (17)
approval_document
- id — BIGINT — 기본 키 — NOT NULL
- document_no — VARCHAR(50) — NOT NULL
- template_version_id — BIGINT — 외래 키 → approval_template.id — NOT NULL
- drafter_id — BIGINT — NOT NULL
- title — VARCHAR(500) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- current_approval_line_id — BIGINT
- attachment_file_ids — VARCHAR(1024)
- retention_until — DATE
- is_delete — BOOLEAN — NOT NULL
- submitted_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
approval_document_snapshot
- id — BIGINT — 기본 키 — NOT NULL
- document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
- template_snapshot — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
approval_document_temp
- id — BIGINT — 기본 키 — NOT NULL
- drafter_id — BIGINT — NOT NULL
- template_id — BIGINT
- title — VARCHAR(500)
- draft_json — JSON — NOT NULL
- attachment_file_ids — VARCHAR(1024)
- is_delete — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
approval_history
- id — BIGINT — 기본 키 — NOT NULL
- document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
- user_id — BIGINT — NOT NULL
- action — VARCHAR(20) — NOT NULL
- approval_line_id — BIGINT — 외래 키 → approval_line.id
- created_at — DATETIME — NOT NULL
approval_line
- id — BIGINT — 기본 키 — NOT NULL
- document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
- user_id — BIGINT — NOT NULL
- user_name_snapshot — VARCHAR(100) — NOT NULL
- department_id — BIGINT
- department_name_snapshot — VARCHAR(100)
- position_id — BIGINT
- position_name_snapshot — VARCHAR(100)
- line_type — VARCHAR(20) — NOT NULL
- step — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- signature_id — BIGINT
- signature_storage_path_snapshot — TEXT
- approved_at — DATETIME
- created_at — DATETIME — NOT NULL
approval_permission
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- permission_type — VARCHAR(20) — NOT NULL
- created_by — BIGINT
- created_at — DATETIME — NOT NULL
approval_template
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- template_group_id — BIGINT — 외래 키 → approval_template_group.id — NOT NULL
- revision_no — INT — NOT NULL
- template_name — VARCHAR(100) — NOT NULL
- description — TEXT
- status — VARCHAR(20) — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
approval_template_category
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
approval_template_field
- id — BIGINT — 기본 키 — NOT NULL
- template_id — BIGINT — 외래 키 → approval_template.id — NOT NULL
- section_id — BIGINT — 외래 키 → approval_template_section.id — NOT NULL
- field_key — VARCHAR(100) — NOT NULL
- field_label — VARCHAR(100) — NOT NULL
- field_type — VARCHAR(20) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- field_order — INT — NOT NULL
- placeholder — VARCHAR(200)
- help_text — VARCHAR(200)
- config_json — JSON
approval_template_field_option
- id — BIGINT — 기본 키 — NOT NULL
- field_id — BIGINT — 외래 키 → approval_template_field.id — NOT NULL
- option_label — VARCHAR(100) — NOT NULL
- option_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
approval_template_group
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- category_id — BIGINT — 외래 키 → approval_template_category.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
approval_template_line
- id — BIGINT — 기본 키 — NOT NULL
- template_group_id — BIGINT — 외래 키 → approval_template_group.id — NOT NULL
- line_type — VARCHAR(20) — NOT NULL
- step — INT — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- is_modifiable — BOOLEAN — NOT NULL
- line_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
approval_template_section
- id — BIGINT — 기본 키 — NOT NULL
- template_id — BIGINT — 외래 키 → approval_template.id — NOT NULL
- section_title — VARCHAR(100) — NOT NULL
- section_order — INT — NOT NULL
approval_template_target
- id — BIGINT — 기본 키 — NOT NULL
- template_group_id — BIGINT — 외래 키 → approval_template_group.id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT
- created_at — DATETIME — NOT NULL
approval_template_temp
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- template_group_id — BIGINT
- category_id — BIGINT — NOT NULL
- template_name — VARCHAR(100) — NOT NULL
- description — TEXT
- draft_json — JSON — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
approval_user_line
- id — BIGINT — 기본 키 — NOT NULL
- set_id — BIGINT — NOT NULL
- line_type — VARCHAR(20) — NOT NULL
- step — INT — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- line_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
approval_user_line_set
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL