anal_server_2
Tables (27)
LibraryFolder (라이브러리 폴더)
- folder_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- folder_uuid — uuid
- parent_folder_id — varchar
- folder_name — varchar
- created_at — datetime
- updated_at — datetime
Library_item (라이브러리아이템)
- library_item_id — bigint — Primary key — NOT NULL
- folder_id — bigint — Foreign key → LibraryFolder.folder_id — NOT NULL
- user_id — bigint — Foreign key → LibraryFolder.user_id — NOT NULL
- library_item_uuid — uuid
- file_id — bigint — Foreign key → file.file_id — NOT NULL
- document_type — varchar
- document_name — varchar
- embedding_status — varchar
- last_embedding_at — datetime
- rag_enabled — boolean
- description — varchar
- deleted_yn — boolean
- upload_at — datetime
- upload_by — varchar
NOTICE_FILE (공지사항 파일)
- notice_file_id — Primary key — NOT NULL
- notice_id — bigint — Foreign key → notices.notice_id — NOT NULL
- file_id (file_id2) — bigint — Foreign key → file.file_id — NOT NULL
- user_id — bigint — Foreign key → file.user_id — NOT NULL
chat_attachments (채팅첨부파일)
- chat_attachment_id — bigint — Primary key — NOT NULL
- chat_message_id — bigint — Foreign key → chat_messages.chat_message_id — NOT NULL
- chat_session_id — bigint — Foreign key → chat_messages.chat_session_id — NOT NULL
- user_id — bigint — Foreign key → chat_messages.user_id — NOT NULL
- file_id — bigint — Foreign key → file.file_id — NOT NULL
- created_at — datetime
chat_messages (채팅메시지)
- chat_message_id — bigint — Primary key — NOT NULL
- chat_session_id — bigint — Foreign key → chat_session.chat_session_id — NOT NULL
- user_id — bigint — Foreign key → chat_session.user_id — NOT NULL
- chat_message_uuid — uuid
- sender_type — varchar
- message_content — text
- token_count — int
- created_at — datetime
chat_session (채팅세션)
- chat_session_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- chat_session_uuid — uuid
- session_title — varchar
- chat_type — varchar
- conversation_summary — text
- created_at — datetime
- updated_at — datetime
chat_usage_daily (사용자별 일일 AI채팅 사용량 집계)
- usage_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- usage_date — date
- chat_request_count — int
- create_at (created_at) — datetime
- updated_at — datetime
ds_products (매뉴얼제품master)
- product_id — bigint — Primary key — NOT NULL
- product_code — varchar
- product_name — varchar
- descripttion (description) — text
- use_yn — boolean
- sort_order — int
- created_at — datetime
- created_by — varchar
- updated_at — datetime
- updated_by — varchar
file (파일)
- file_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- original_file_name — varchar
- bucket_name — varchar
- object_key
- file_ext — varchar
- file_size — bigint
- mime_type (Field) — varchar
- upload_by — varchar
- upload_at — datetime
library_embedding_job (임베딩요청이력관리)
- embedding_job_id (Keyembedding_job_id) — bigint — Primary key — NOT NULL
- library_item_id — bigint — Foreign key → Library_item.library_item_id — NOT NULL
- folder_id — bigint — Foreign key → Library_item.folder_id — NOT NULL
- user_id — bigint — Foreign key → Library_item.user_id — NOT NULL
- status — varchar
- requested_by — bigint
- requested_at (Field) — datetime
- started_at — datetime
- completeted_at — datetime
- error_code — varchar
- error_message — text
- created_at — datetime
- updated_at — datetime
library_item_tags (라이브러리아이템태그)
- library_item_tag_id — bigint — Primary key — NOT NULL
- tag_id — bigint — Foreign key → tag.tag_id — NOT NULL
- library_item_id — bigint — Foreign key → Library_item.library_item_id — NOT NULL
manual_chat_document (매뉴얼채팅문서매핑)
- manual_chat_document_id — bigint — Primary key — NOT NULL
- manual_chat_id — bigint — Foreign key → manul_chat_history.manual_chat_id — NOT NULL
- chat_session_id — bigint — Foreign key → manul_chat_history.chat_session_id — NOT NULL
- user_id — bigint — Foreign key → manul_chat_history.user_id — NOT NULL
- manual_doc_id — bigint — Foreign key → manual_documents.manual_doc_id — NOT NULL
- version_doc_type_id — bigint — Foreign key → manual_documents.version_doc_type_id — NOT NULL
- version_id — bigint — Foreign key → manual_documents.version_id — NOT NULL
- product_id — bigint — Foreign key → manual_documents.product_id — NOT NULL
- document_type_di — bigint — Foreign key → manual_documents.document_type_di
- created_at — datetime
manual_document_type (매뉴얼 문서유형 master)
- document_type_di — bigint — Primary key
- type_code — varchar
- type_name — varchar
- description — text
- use_yn — boolean
- sort_order — int
- created_at — datetime
- created_by — varchar
- updated_at — datetime
- dupated_by (updated_by) — varchar
manual_documents (매뉴얼문서)
- manual_doc_id — bigint — Primary key — NOT NULL
- version_doc_type_id — bigint — Foreign key → manual_version_document_type.version_doc_type_id — NOT NULL
- version_id — bigint — Foreign key → manual_version_document_type.version_id — NOT NULL
- product_id — bigint — Foreign key → manual_version_document_type.product_id — NOT NULL
- document_type_di — bigint — Foreign key → manual_version_document_type.document_type_di
- file_id — bigint — Foreign key → file.file_id — NOT NULL
- manual_doc_uuid — uuid
- document_type — varchar
- document_name — varchar
- embedding_status — varchar
- last_embedding_at — datetime
- deleted_yn — boolean
- deleted_at — datetime
- deleted_by — bigint
- vector_collection_name — varchar
- use_yn — boolean
- registerd_at — datetime
manual_embedding_job (매뉴얼분석임베딩이력)
- embedding_job_id — bigint — Primary key — NOT NULL
- manual_doc_id — bigint — Foreign key → manual_documents.manual_doc_id — NOT NULL
- version_doc_type_id — bigint — Foreign key → manual_documents.version_doc_type_id — NOT NULL
- version_id — bigint — Foreign key → manual_documents.version_id — NOT NULL
- product_id — bigint — Foreign key → manual_documents.product_id — NOT NULL
- document_type_di — bigint — Foreign key → manual_documents.document_type_di
- status — varchar
- requested_by — varchar
- reqeuested_at (requested_at) — datetime
- started_at — datetime
- completed_at — datetime
- error_code — varchar
- error_message — text
- created_at — datetime
- updated_at — datetime
manual_version (매뉴얼버전master)
- version_id — bigint — Primary key — NOT NULL
- product_id — bigint — Foreign key → ds_products.product_id — NOT NULL
- version_code — varchar
- version_name — varchar
- description — text
- use_yn — boolean
- sort_dorder (sort_order) — int
- creatd_at (created_at) — datetime
- created_by — varchar
- updated_at — datetime
- updated_by — varchar
manual_version_document_type (버전과문서유형매핑테이블)
- version_doc_type_id — bigint — Primary key — NOT NULL
- version_id — bigint — Foreign key → manual_version.version_id — NOT NULL
- product_id — bigint — Foreign key → manual_version.product_id — NOT NULL
- document_type_di — bigint — Foreign key → manual_document_type.document_type_di
- required_yn — boolean
- use_yn — boolean
- sort_order — int
- created_atc (created_at) — datetime
- created_by — varchar
- updated_at — datetime
- updated_by — varchar
manul_chat_history (매뉴얼 채팅이력)
- manual_chat_id — bigint — Primary key — NOT NULL
- chat_session_id — bigint — Foreign key → chat_session.chat_session_id — NOT NULL
- user_id — bigint — Foreign key → chat_session.user_id — NOT NULL
- manual_chat_uuid — uuid
- intent_type — varchar
- question — text
- answer — text
- satisfaction_score — int
- create_at — datetime
notices (공지사항)
- notice_id — bigint — Primary key — NOT NULL
- notice_uuid — uuid
- notice_type — varchar
- title — varchar
- content — text
- post_status — varchar
- top_notice_yn — boolean
- visible_yn — boolean
- view_count — int
- posted_at — date
- created_at — datetime
- created_by — varchar
- updated_at — datetime
- updated_by — varchar
notification (알림)
- notification_id — bigint — Primary key — NOT NULL
- request_id — bigint — Foreign key → request.request_id — NOT NULL
- user_id — bigint — Foreign key → request.user_id — NOT NULL
- notification_uuid — uuid
- title — varchar
- content — text
- read_yn — boolean
- occurred_at — datetime
- read_at — datetime
patch_note (패치노트)
- patch_note_id — bigint — Primary key — NOT NULL
- patch_note_uuid — uuid
- version — varchar
- title — varchar
- content — text
- patch_type — varchar
- impact_scope — varchar
- post_status — varchar
- visible_yn — boolean
- view_count — int
- release_date — date
- created_at — datetime
- created_by — varchar
- updated_at — datetime
- updated_by — varchar
patch_note_file (패치노트 파일)
- patch_note_file_id — bigint — Primary key — NOT NULL
- patch_note_id — bigint — Foreign key → patch_note.patch_note_id — NOT NULL
- file_id (file_id2) — bigint — Foreign key → file.file_id — NOT NULL
- user_id — bigint — Foreign key → file.user_id — NOT NULL
request (요청)
- request_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- request_uuid — uuid
- request_type — varchar
- title — varchar
- request_content — text
- request_status — varchar
- process_result — text
- requested_at — datetime
- processed_at — datetime
- created_at — datetime
- updated_at — datetime
request_history (요청이력)
- request_history_id — bigint — Primary key — NOT NULL
- request_id — bigint — Foreign key → request.request_id — NOT NULL
- user_id — bigint — Foreign key → request.user_id — NOT NULL
- previous_status — varchar
- new_status — varchar
- comment — text
- processed_by — varchar
- processed_at — datetime
tag (태그)
- tag_id — bigint — Primary key — NOT NULL
- tag_name — varchar
- created_by — varchar
- created_at — datetime
- updated_by — varchar
- updated_at — datetime
user (유저)
- user_id — bigint — Primary key — NOT NULL
- user_uuid — uuid
user_daily_usage_overrides (추가 채팅사용횟수부여)
- override_id — bigint — Primary key — NOT NULL
- request_id — bigint — Foreign key → request.request_id — NOT NULL
- user_id — bigint — Foreign key → request.user_id — NOT NULL
- target_date — date
- extra_chat_request_limit — int
- status
- approved_at — datetime
- create_at — datetime
- updated_at (update_at) — datetime