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