ktj
Tables (15)
admin_edit_logs (관리자 수정 이력)
- admin_edit_logs_id (Key3) — bigint — Primary key — NOT NULL
- target_admin_id (Key) — bigint — Foreign key → admins.admin_id — NOT NULL
- editor_admin_id (Key2) — bigint — Foreign key → admins.admin_id — NOT NULL
- action (Field) — varchar
- edited_at (Field2) — timestamp
- Field3
admin_login_logs (관리자 로그인 이력)
- admin_login_logs_id (Key) — bigint — Primary key — NOT NULL
- admin_id (Key2) — bigint — Foreign key → admins.admin_id — NOT NULL
- login_at (Field) — timestamp
- ip_address (Field2) — carchar
- success (Field3) — boolean
- Field4
admin_roles (관리자 역할 매핑)
- admin_role_id (Key3) — bigint — Primary key — NOT NULL
- admin_id (Key4) — bigint — Foreign key → admins.admin_id — NOT NULL
- role_id (Key) — bigint — Foreign key → roles.role_id — NOT NULL
admins (관리자 계정)
- admin_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- department (Field3) — varchar
- password_hash (Field4) — varchar
- status (Field6) — boolean
- is_apporved (Field7) — boolean
- created_at (Field8) — timestamp
- updated_at (Field9) — timestamp
- Field10
chat_message (채팅 이력)
- chat_message_id (Key) — bigint — Primary key — NOT NULL
- session_id (Field) — varchar
- sender (Field2) — varchar
- message_type (Field3) — varchar
- content (Field4) — varchar
- created_at (t) — timestamp
- chat_message_id (Key2) — bigint — Foreign key → chat_message.chat_message_id — NOT NULL
chat_pipeline (채팅 파이프라인)
- id (Key3) — bigint — Primary key — NOT NULL
- chat_message_id (Key) — bigint — Foreign key → chat_message.chat_message_id — NOT NULL
- id (Key2) — bigint — Foreign key → rag_pipeline_settings.id — NOT NULL
cluster_stats (클러스터 통계 테이블)
- question_cluster_id (Key) — bigint — Foreign key → question_clusters.question_cluster_id — NOT NULL
- cluster_stats (Field) — integer
- count_total (Field2) — integer
- last_updatred (Field3) — timestamp
- Field4
menus (메뉴)
- menu_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- Field2
message_cluster_mappings (질문 클러스터 매핑)
- chat_message_id (Key) — bigint — Foreign key → chat_message.chat_message_id — NOT NULL
- question_cluster_id (Key2) — bigint — Foreign key → question_clusters.question_cluster_id — NOT NULL
password_reset_request (비밀번호 초기화 요청 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- admin_id (Key2) — bigint — Foreign key → admins.admin_id — NOT NULL
- approved_admin_id (Key3) — bigint — Foreign key → admins.admin_id — NOT NULL
- is_reset (Field) — boolean
- Field2
question_clusters (대표 질문 클러스터 테이블)
- question_cluster_id (Key) — bigint — Primary key — NOT NULL
- represent_question (Field) — varchar
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
rag_pipeline_settings (rag 옵션)
- id (Key) — bigint — Primary key — NOT NULL
- Field
- admin_id (Key2) — bigint — Foreign key → admins.admin_id — NOT NULL
- llm_model (Field2) — varchar
- system_prompt (Field3) — varchar
- vector_db (Field4) — varchar
- search_method (Field5) — varchar
- use_mutli_query (Field6) — boolean
- fetch_k (Field7) — integer
- top_n (Field8) — integer
- Field9 — boolean
- use_hybrid (Field10) — boolean
- hybrid_weight (Field11) — float
- use_metadata_filter (Field12) — boolean
- faq_weight (Field13) — float
- guide_weight (Field14) — float
- conversation_weight (Field15) — float
- is_active (Field16) — boolean
- created_at (Field17) — timestamp
- updated_at (Field18) — timestamp
- Field19
role_menu_permissions (역할 메뉴 접근 권한)
- id (key) — bigint — Primary key — NOT NULL
- menu_id (Key) — bigint — Foreign key → menus.menu_id — NOT NULL
- role_id (Key2) — bigint — Foreign key → roles.role_id — NOT NULL
- can_access (Field) — boolean
roles (역할 테이블)
- role_id (Key) — bigint — Primary key — NOT NULL
- name (c) — varchar
- Field
top_questions (TOP10 캐시 테이블)
- question_cluster_id (Key2) — bigint — Foreign key → question_clusters.question_cluster_id — NOT NULL
- rank (Field) — integer
- score (Field2) — float
- created_at (Field3) — timestamp