전자결재 시스템

테이블 (10)

approval

  • id — bigint — 기본 키 — NOT NULL
  • approver_id — bigint — NOT NULL
  • created_at — datetime(6)
  • document_id — bigint — NOT NULL
  • processed_at — datetime(6)
  • updated_at — datetime(6)
  • comment — varchar(500)

attachment

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • document_id — bigint — NOT NULL
  • file_size — bigint — NOT NULL
  • updated_at — datetime(6)
  • content_type — varchar(100) — NOT NULL
  • object_key — varchar(500) — NOT NULL
  • original_filename — varchar(255) — NOT NULL

audit_log

  • id — bigint — 기본 키 — NOT NULL
  • actor_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • document_id — bigint — NOT NULL
  • reason — varchar(500)
  • action — enum('APPROVE', 'REJECT', 'REQUEST') — NOT NULL
  • result — enum('FAIL', 'SUCCESS') — NOT NULL

chat_conversation

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • last_message_at — datetime(6)
  • member_id — bigint — NOT NULL
  • updated_at — datetime(6)
  • title — varchar(10) — NOT NULL
  • status — enum('ACTIVE', 'ARCHIVED', 'DELETED') — NOT NULL

chat_message

  • id — bigint — 기본 키 — NOT NULL
  • sequence — int — NOT NULL
  • completed_at — datetime(6)
  • conversation_id — bigint — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • request_id — varchar(36) — NOT NULL
  • content — text — NOT NULL
  • role — enum('ASSISTANT', 'SYSTEM', 'USER') — NOT NULL
  • status — enum('CANCELLED', 'COMPLETED', 'FAILED', 'PROCESSING', 'RECEIVED') — NOT NULL

document

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • previous_document_id — bigint
  • updated_at — datetime(6)
  • writer_id — bigint — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • status — enum('APPROVED', 'DRAFT', 'PENDING', 'REJECTED') — NOT NULL

member

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • headquarters — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • position — varchar(50) — NOT NULL
  • team — varchar(50) — NOT NULL
  • username — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum('ROLE_ADMIN', 'ROLE_APPROVER', 'ROLE_EMPLOYEE') — NOT NULL
  • status — enum('ACTIVE', 'INACTIVE', 'PENDING', 'REJECTED') — NOT NULL

notice

  • id — bigint — 기본 키 — NOT NULL
  • author_id — bigint — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • notice_category — enum('DOCUMENT', 'EDUCATION', 'ETC', 'EVENT', 'HR', 'SECURITY', 'SYSTEM') — NOT NULL
  • notice_type — enum('IMPORTANT', 'NORMAL') — NOT NULL

regulation_chunk

  • id — bigint — 기본 키 — NOT NULL
  • regulation_document_id — bigint — NOT NULL
  • article_number — varchar(50) — NOT NULL
  • paragraph_number — varchar(50)
  • vector_id — varchar(100)
  • article_title — varchar(200)
  • content — text — NOT NULL

regulation_document

  • id — bigint — 기본 키 — NOT NULL
  • category — tinyint — NOT NULL
  • effective_date — date — NOT NULL
  • created_at — datetime(6)
  • file_size — bigint
  • updated_at — datetime(6)
  • file_type — varchar(30)
  • version — varchar(30) — NOT NULL
  • content_type — varchar(100)
  • title — varchar(200) — NOT NULL
  • object_key — varchar(500)
  • content — text — NOT NULL
  • original_filename — varchar(255)
  • ingestion_status — enum('COMPLETED', 'FAILED', 'PROCESSING') — NOT NULL
  • status — enum('ACTIVE', 'INACTIVE') — NOT NULL