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