전자결재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