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