nexin
Tables (25)
ChatMessage
- chat_message_id — UUID — Primary key — NOT NULL
- chat_session_id — UUID — Foreign key → ChatSession.chat_session_id — NOT NULL
- role — VARCHAR(20) — NOT NULL — user / assistant / system
- content — TEXT — NOT NULL
- used_doc_scope — JSON — 실제 사용된 문서 범위 스냅샷
- used_chunk_refs — JSON — 검색 hit된 Chunk ID. RAG 품질 분석
- citation_refs — JSON — CitationAnchor ID. 히스토리 재현
- model_name — VARCHAR(100)
- latency_ms — INT — TTQ 모니터링
- created_at — TIMESTAMP — NOT NULL
ChatSession
- chat_session_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(500)
- selected_doc_scope — JSON — 선택한 문서 목록 스냅샷
- default_model — VARCHAR(100)
- is_favorited — BOOLEAN — NOT NULL — DEFAULT false
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
CitationAnchor
- citation_anchor_id — UUID — Primary key — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL
- chunk_id — UUID — Foreign key → DocumentChunk.chunk_id — NOT NULL
- page_num — SMALLINT — NOT NULL — 즉시 페이지 이동용 denormalization
- bbox — JSON — 하이라이트 좌표 스냅샷
- quote_text — TEXT — 발췌 텍스트 스냅샷
- anchor_type — VARCHAR(20) — NOT NULL — text_span / block / table / image
- created_at — TIMESTAMP — NOT NULL
Department
- department_id — UUID — Primary key — NOT NULL — 부서 단위 식별자
- name — VARCHAR(200) — NOT NULL — 부서명
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Document
- doc_id — UUID — Primary key — NOT NULL — 문서 단위 식별자. 파일 그 자체
- owner_user_id — UUID — Foreign key → User.user_id — NOT NULL — 업로드한 유저
- folder_id — UUID — Foreign key → Folder.folder_id — 소속 폴더. null이면 미분류
- title — VARCHAR(500) — NOT NULL
- file_path — TEXT — NOT NULL — Object Storage 원본 파일 경로
- file_name — VARCHAR(500) — NOT NULL
- file_size — BIGINT — bytes. 용량 제한 체크
- file_hash — VARCHAR(64) — SHA-256. 중복 업로드 감지
- source_type — VARCHAR(20) — NOT NULL — pdf / docx / pptx / image_png / image_jpg / hwpx
- effective_date — DATE — 시행일. 법령 개정 추적용
- status — VARCHAR(20) — NOT NULL — pending / processing / ready / failed
- is_favorited — BOOLEAN — NOT NULL — DEFAULT false
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP — 소프트 삭제
DocumentAccessPolicy
- policy_id — UUID — Primary key — NOT NULL
- subject_type — VARCHAR(20) — NOT NULL — user / department
- subject_id — UUID — NOT NULL — user_id or department_id
- target_type — VARCHAR(20) — NOT NULL — folder / document
- target_id — UUID — NOT NULL
- action_type — VARCHAR(20) — NOT NULL — read / upload
- is_allowed — BOOLEAN — NOT NULL — true=허용 / false=차단
- created_by — UUID — Foreign key → User.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL — 변경 시 새 레코드 INSERT
DocumentChunk
- chunk_id — UUID — Primary key — NOT NULL — pgvector payload 참조 키
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL
- page_id — UUID — Foreign key → Page.page_id — bbox 좌표계 기준
- chunk_type — VARCHAR(20) — NOT NULL — paragraph/heading/list/listitem/table/image/caption
- heading_level — SMALLINT — heading 타입일 때 1/2/3
- chunk_level — VARCHAR(20) — NOT NULL — parent / child
- parent_chunk_id — UUID — Foreign key → DocumentChunk.chunk_id — child → parent 참조
- header_path — TEXT — 예) 제1장 총칙 > 제40조 요양급여
- content_text — TEXT — 원본 텍스트
- enriched_text — TEXT — header_path prefix 보강. 임베딩 전용
- bbox — JSON — x0,y0,x1,y1
- chunk_order — INT — NOT NULL — 문서 내 전체 순서
- block_refs — JSON — caption+table 합친 경우 원본 ID 목록
- token_count — SMALLINT
- embedding — TEXT — pgvector vector(768)
- content_tsv — TEXT — PostgreSQL FTS + pg_bigm
- created_at — TIMESTAMP — NOT NULL
DocumentSummary
- summary_id — UUID — Primary key — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL
- summary_text — TEXT — NOT NULL
- generated_by_model — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
Folder
- folder_id — UUID — Primary key — NOT NULL — 폴더 단위 식별자
- parent_id — UUID — Foreign key → Folder.folder_id — null이면 루트. self-join으로 N단계 자유 계층
- owner_user_id — UUID — Foreign key → User.user_id — NOT NULL — 폴더 생성자
- name — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP — 소프트 삭제. 하위 문서 보호
GeneratedArtifact
- artifact_id — UUID — Primary key — NOT NULL
- studio_job_id — UUID — Foreign key → StudioJob.studio_job_id — NOT NULL
- artifact_type — VARCHAR(20) — NOT NULL — docx / pptx / preview
- file_path — TEXT — NOT NULL
- file_name — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- checksum — VARCHAR(64)
- created_at — TIMESTAMP — NOT NULL
IngestionJob
- ingestion_job_id — UUID — Primary key — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL — 처리 대상 Document
- status — VARCHAR(20) — NOT NULL — pending / processing / done / failed
- current_step — VARCHAR(20) — chunk / embed / summary / question
- error_code — VARCHAR(100)
- error_message — TEXT
- started_at — TIMESTAMP
- finished_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
NotificationMessage
- notification_id — UUID — Primary key — NOT NULL
- notification_type — VARCHAR(20) — NOT NULL — document / permission / system
- target_type — VARCHAR(20) — NOT NULL — user / department / all
- target_id — UUID — all이면 null
- title — VARCHAR(200) — NOT NULL
- body — TEXT — NOT NULL
- created_by — UUID — 시스템 자동 발송이면 null
- created_at — TIMESTAMP — NOT NULL
NotificationReceipt
- receipt_id — UUID — Primary key — NOT NULL
- notification_id — UUID — Foreign key → NotificationMessage.notification_id — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- is_read — BOOLEAN — NOT NULL — DEFAULT false
- read_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
OperationLog
- operation_log_id — UUID — Primary key — NOT NULL
- user_id — UUID — 시스템 이벤트이면 null
- log_type — VARCHAR(30) — NOT NULL — document / pipeline / chat / studio / system
- action — VARCHAR(100) — NOT NULL
- target_type — VARCHAR(50)
- target_id — VARCHAR(36)
- result — VARCHAR(20) — NOT NULL — success / failure
- payload — JSON
- created_at — TIMESTAMP — NOT NULL — 보존 기간 정책 적용
Page
- page_id — UUID — Primary key — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL — 소속 Document
- page_num — SMALLINT — NOT NULL — 1-indexed. bbox 좌표계 기준
- width — NUMERIC(8, 2) — bbox x좌표 정규화 기준
- height — NUMERIC(8, 2) — bbox y좌표 정규화 기준
- page_image_path — TEXT
- thumbnail_path — TEXT
- created_at — TIMESTAMP — NOT NULL
SecurityAuditLog
- security_audit_log_id — UUID — Primary key — NOT NULL
- actor_id — UUID — 시스템 자동 처리이면 null
- actor_role — VARCHAR(50) — 행위 시점 역할 스냅샷
- log_type — VARCHAR(30) — NOT NULL — auth / user_mgmt / document_mgmt / permission_mgmt
- action — VARCHAR(100) — NOT NULL
- target_type — VARCHAR(50)
- target_id — VARCHAR(36)
- result — VARCHAR(20) — NOT NULL — success / failure
- payload — JSON
- ip_address — VARCHAR(45)
- user_agent — TEXT
- created_at — TIMESTAMP — NOT NULL — 영구 보존
StudioJob
- studio_job_id — UUID — Primary key — NOT NULL
- studio_session_id — UUID — Foreign key → StudioSession.studio_session_id — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- template_id — UUID — Foreign key → Template.template_id
- output_type — VARCHAR(20) — NOT NULL — docx / pptx
- source_type — VARCHAR(20) — NOT NULL — doc_based
- prompt — TEXT — NOT NULL
- job_status — VARCHAR(20) — NOT NULL — queued / processing / success / failed
- current_stage — VARCHAR(50) — source_retrieval / outline / rendering
- error_code — VARCHAR(100)
- error_message — TEXT
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
StudioSession
- studio_session_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(500)
- source_doc_scope — JSON — 참고 문서 범위 스냅샷
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
StudioSourceTrace
- studio_source_trace_id — UUID — Primary key — NOT NULL
- studio_job_id — UUID — Foreign key → StudioJob.studio_job_id — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — 사용된 Document
- chunk_id — UUID — Foreign key → DocumentChunk.chunk_id — 사용된 Chunk
- section_key — VARCHAR(100) — 예) slide_3, section_intro
- created_at — TIMESTAMP — NOT NULL
SuggestedQuestion
- question_id — UUID — Primary key — NOT NULL
- doc_id — UUID — Foreign key → Document.doc_id — NOT NULL
- question_text — TEXT — NOT NULL
- display_order — SMALLINT — NOT NULL
- generated_by_model — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
SystemPlan
- system_plan_id — UUID — Primary key — NOT NULL
- tier_code — VARCHAR(20) — NOT NULL — lite / enterprise / custom
- max_users — INT — null=무제한. 라이트=10
- max_documents — INT — 라이트=50
- max_storage_mb — BIGINT — null=무제한
- features — JSON — NOT NULL — 기능 플래그. document_share_enabled / custom_permission_enabled / studio_enabled
- started_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP — null=무기한
- created_at — TIMESTAMP — NOT NULL — 변경 시 새 레코드 INSERT
Template
- template_id — UUID — Primary key — NOT NULL
- owner_user_id — UUID — is_system=true이면 null
- title — VARCHAR(200) — NOT NULL
- output_type — VARCHAR(20) — NOT NULL — docx / pptx
- file_path — TEXT — NOT NULL
- thumbnail_path — TEXT
- is_system — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
User
- user_id — UUID — Primary key — NOT NULL — 모든 엔티티의 소유자 추적 기준
- department_id — UUID — Foreign key → Department.department_id — 소속 부서. null이면 기본 차단
- login_id — VARCHAR(100) — NOT NULL — 로그인 식별자
- password_hash — VARCHAR(255) — NOT NULL — 현재 유효한 비밀번호 해시
- role_code — VARCHAR(20) — NOT NULL — user / admin
- status — VARCHAR(20) — NOT NULL — active / inactive / locked
- must_change_password — BOOLEAN — NOT NULL — 임시 비밀번호 발급 후 true
- password_changed_at — TIMESTAMP — 만료 정책 기준
- last_login_at — TIMESTAMP — 휴면 계정 감지 기준
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP — 소프트 삭제
UserPasswordResetToken
- reset_token_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL — 대상 사용자
- temp_password_hash — VARCHAR(255) — NOT NULL — User.password_hash와 분리 보관
- issued_by — UUID — Foreign key → User.user_id — NOT NULL — 발급한 관리자
- issued_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- used_at — TIMESTAMP — null이면 미사용
- is_expired — BOOLEAN — NOT NULL — 관리자 강제 만료 가능
UserSetting
- user_setting_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL — User와 1:1
- default_chat_model — VARCHAR(100) — 사용자별 기본 LLM 모델
- response_style — VARCHAR(50) — NOT NULL — formal / casual / concise
- answer_length — VARCHAR(20) — NOT NULL — short / detailed
- theme_mode — VARCHAR(20) — NOT NULL — light / dark
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL