전자결재 시스템
테이블 (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