전자결재

테이블 (18)

approval_attachment (첨부파일)

  • id — BIGINT — 기본 키 — NOT NULL
  • document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • storage_path — TEXT — NOT NULL
  • file_size — BIGINT
  • created_at — DATETIME — NOT NULL

approval_category_target (템플릿 카테고리 권한)

  • id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → approval_template_category.id — NOT NULL
  • target_type — ENUM( 'USER', 'DEPARTMENT', 'POSITION' ) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • permission_type — ENUM( 'MANAGE', 'USE' ) — NOT NULL
  • created_at — DATETIME — NOT NULL

approval_document (문서)

  • id — BIGINT — 기본 키 — NOT NULL
  • document_no — VARCHAR(50) — NOT NULL
  • 템플릿 버전 id (template_version_id) — BIGINT — NOT NULL
  • drafter_id — BIGINT — NOT NULL
  • 제목 (title) — VARCHAR(500) — NOT NULL
  • status — ENUM( 'DRAFT', 'IN_PROGRESS', 'APPROVED', 'REJECTED', 'WITHDRAWN' ) — NOT NULL
  • 현재 차례 결재자id (current_approval_line_id) — BIGINT
  • submitted_at — DATETIME
  • completed_at — DATETIME
  • 생성일 (created_at) — DATETIME — NOT NULL
  • INDEX — idx_drafter

approval_document_snapshot (문서 스냅샷)

  • id — BIGINT — 기본 키 — NOT NULL
  • document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
  • template_snapshot — JSON NOT NULL — 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 — ENUM( 'DRAFT', 'SUBMIT', 'APPROVE', 'REJECT', 'WITHDRAW', 'RESUBMIT', 'DELEGATE' ) — NOT NULL
  • comment — TEXT — EX
  • created_at — DATETIME — NOT NULL
  • approval_line_id — BIGINT
  • INDEX — idx_document_history

approval_line (결재선)

  • id — BIGINT — 기본 키 — NOT NULL
  • document_id — BIGINT — 외래 키 → approval_document.id — NOT NULL
  • 사용자id (user_id) — BIGINT — NOT NULL
  • 사용자이름스냅샷 (user_name_snapshot) — VARCHAR(100) — NOT NULL
  • 부서id (department_id) — BIGINT
  • 부서이름스냅샷 (department_name_snapshot) — VARCHAR(100)
  • 직급id (position_id) — BIGINT
  • 직급이름스냅샷 (position_name_snapshot) — VARCHAR(100)
  • 결재유형 (line_type) — ENUM( 'APPROVER', 'AGREEMENT', 'REFERENCE' ) — NOT NULL
  • 결재순서 (step) — INT — NOT NULL
  • 결재상태 (status) — ENUM( 'WAITING', 'PENDING', 'APPROVED', 'REJECTED', 'SKIPPED' ) — NOT NULL
  • comment — TEXT — EX
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL

approval_template (템플릿 버전)

  • 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) — ENUM( 'DRAFT', 'PUBLISHED', 'DEPRECATED' ) — NOT NULL
  • 생성자 (created_by) — BIGINT — NOT NULL
  • 생성일 (created_at) — DATETIME — NOT NULL
  • INDEX — idx_latest

approval_template_category (문서 탬플릿 카테고리)

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_id — BIGINT — 외래 키 → approval_template_category.id
  • category_name — VARCHAR(100) — NOT NULL
  • category_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

approval_template_field (템플릿 필드)

  • id — BIGINT — 기본 키 — 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) — ENUM( 'TEXT', 'TEXTAREA', 'NUMBER', 'DATE', 'DATETIME', 'SELECT', 'RADIO', 'CHECKBOX', 'FILE', 'USER') NOT NULL — 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 DEFAULT TRUE

approval_template_group (템플릿 그룹)

  • id — BIGINT — 기본 키 — NOT NULL
  • 카테고리 id (category_id) — BIGINT — 외래 키 → approval_template_category.id — NOT NULL
  • name — VARCHAR(100) — 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_id — BIGINT — NOT NULL
  • line_type — ENUM('APPROVER','AGREEMENT','REFERENCE') — NOT NULL
  • step — INT — NOT NULL
  • target_type — ENUM('USER','DEPARTMENT','POSITION') — 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_id — BIGINT — 외래 키 → approval_template.id — NOT NULL
  • target_type — ENUM( 'ALL', 'USER', 'DEPARTMENT', 'POSITION' ) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

approval_template_temp

  • 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