intellicen

Tables (32)

tb_accounts

  • id — bigint(20) — Primary key — NOT NULL
  • username — varchar(100) — NOT NULL
  • pw_hash — varchar(255) — NOT NULL
  • name — varchar(100)
  • is_manager — tinyint(1)
  • created_at — datetime
  • group_id — bigint(20) — Foreign key → tb_groups.id
  • retention_span — varchar(6)
  • user_ip — varchar(100)
  • default_mode — varchar(50) — 사용자 기본 모드 설정 (모드 코드)
  • session_timeout — int(11) — 세션 타임아웃 시간 (분 단위, 기본값 300분)

tb_app_knowledge_files

  • id — int(11) — Primary key — NOT NULL
  • app_id — int(11) — Foreign key → tb_personal_apps.id — NOT NULL
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • filename — varchar(255) — NOT NULL
  • file_content — longtext
  • file_type — varchar(100)
  • created_at — timestamp
  • storage_path — varchar(500)

tb_board

  • id — int(11) — Primary key — NOT NULL
  • category — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • view — int(11)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • reply_to — int(11)
  • user_id — varchar(100) — NOT NULL
  • is_notice — tinyint(1) — 공지사항 여부 (0: 일반글, 1: 공지사항)
  • notice_start_date — datetime — 공지 시작일
  • notice_end_date — datetime — 공지 종료일

tb_board_attachment

  • id — int(11) — Primary key — NOT NULL
  • board_id — int(11) — Foreign key → tb_board.id — NOT NULL — 게시글 ID
  • file_type — enum('image', 'file') — NOT NULL — 파일 타입
  • original_name — varchar(255) — NOT NULL — 원본 파일명
  • stored_filename — varchar(255) — NOT NULL — 저장된 파일명 (UUID)
  • file_size — int(11) — NOT NULL — 파일 크기 (bytes)
  • file_path — varchar(500) — NOT NULL — 파일 경로
  • uploaded_at — timestamp — NOT NULL — 업로드 시간
  • uploaded_by — varchar(100) — NOT NULL — 업로드한 사용자 ID

tb_board_comment

  • comment_id — int(11) — Primary key — NOT NULL
  • id — int(11) — NOT NULL
  • category — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • user_id — varchar(100) — NOT NULL

tb_chat_modes

  • id — int(11) — Primary key — NOT NULL
  • code — varchar(20) — NOT NULL
  • label — varchar(100) — NOT NULL
  • description — varchar(500)
  • instruction — text
  • img_instruction — text
  • display_order — int(11) — NOT NULL
  • is_visible — tinyint(1) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • use_mapping — tinyint(1) — NOT NULL
  • use_ddl — tinyint(1) — NOT NULL
  • additional_vdb — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp
  • temperature — float
  • top_k — int(11)
  • top_p — float
  • max_tokens — int(11)

tb_context_log

  • id — bigint(20) — Primary key — NOT NULL
  • conversation_id — bigint(20) — Foreign key → tb_conversations.id — NOT NULL
  • user_message_id — bigint(20)
  • assistant_message_id — bigint(20)
  • context_json — longtext
  • model_name — varchar(100)
  • created_at — datetime

tb_conversations

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20)
  • mode — varchar(20) — NOT NULL
  • title — mediumtext
  • system_prompt — text
  • is_locked — tinyint(1)
  • locked_reason — varchar(10)
  • is_visible — tinyint(1)
  • created_at — datetime
  • updated_at — datetime
  • title_ngrams — text
  • llm — varchar(100)
  • vdb — varchar(100)
  • is_archived — tinyint(1)
  • is_personal — tinyint(1)
  • personal_id — int(11)
  • FULLTEXT — KEY

tb_data_asset_files

  • id — bigint(20) — Primary key — NOT NULL
  • data_asset_id — bigint(20) — Foreign key → tb_data_assets.id — NOT NULL — Data Asset ID (FK)
  • filename — varchar(500) — NOT NULL — 저장된 파일명
  • original_filename — varchar(500) — NOT NULL — 원본 파일명
  • file_path — varchar(1000) — NOT NULL — 파일 경로
  • file_size — bigint(20) — NOT NULL — 파일 크기 (bytes)
  • file_type — varchar(50) — NOT NULL — 파일 타입 (pdf, docx, xlsx 등)
  • file_hash — varchar(64) — 파일 해시 (SHA256)
  • status — enum('PENDING', 'PROCESSING', 'DONE', 'FAILED') — NOT NULL
  • content_json — longtext — 파일별 구조화된 데이터 (텍스트/이미지/표)' CHECK (json_valid(`content_json`)
  • file_order — int(11) — NOT NULL — 파일 순서
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

tb_data_asset_processing_jobs

  • id — bigint(20) — Primary key — NOT NULL
  • data_asset_id — bigint(20) — Foreign key → tb_data_assets.id — NOT NULL — Data Asset ID (FK)
  • user_id — bigint(20) — NOT NULL
  • params_json — longtext — 처리 파라미터 (extract_images, vision_base_url, vision_model_name 등)' CHECK (json_valid(`params_json`)
  • status — enum('PENDING', 'RUNNING', 'DONE', 'FAILED') — NOT NULL
  • progress_json — longtext — 진행률 정보 ({"step": "...", "progress": 50, "current": 5, "total": 10})' CHECK (json_valid(`progress_json`)
  • message — varchar(1000) — 상태 메시지
  • locked_by — varchar(255) — Worker 식별자 (hostname:pid)
  • locked_at — datetime — 작업 잠금 시각
  • attempts — int(11) — NOT NULL — 재시도 횟수
  • created_at — datetime — NOT NULL
  • started_at — datetime — 처리 시작 시각
  • completed_at — datetime — 처리 완료 시각
  • updated_at — datetime — NOT NULL
  • file_id — bigint(20) — Foreign key → tb_data_asset_files.id — 파일 ID (FK, 다중 파일 지원)

tb_data_assets

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • title — varchar(500) — 문서 제목
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • description — text — 데이터 어셋 설명
  • created_by — bigint(20) — 작성자 ID (FK, tb_accounts.id)
  • updated_by — bigint(20) — 수정자 ID (FK, tb_accounts.id)
  • FULLTEXT — KEY
  • FULLTEXT — KEY

tb_embedding_jobs

  • id — bigint(20) — Primary key — NOT NULL
  • app_id — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • file_id — bigint(20) — NOT NULL
  • filename — varchar(255)
  • params_json — longtext
  • status — enum('PENDING','RUNNING','DONE','FAILED') — NOT NULL
  • message — varchar(1000)
  • attempts — int(11) — NOT NULL
  • locked_by — varchar(255)
  • locked_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

tb_faq

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • view — int(11)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • reply_to — int(11)

tb_groups

  • id — bigint(20) — Primary key — NOT NULL
  • group_name — varchar(100) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

tb_knowledge_chunking_config

  • id — bigint(20) — Primary key — NOT NULL
  • knowledge_id — bigint(20) — Foreign key → tb_knowledge_information.id — NOT NULL — 지식정보 ID (1:1 관계)
  • splitting_strategy — enum('AUTO', 'DICTIONARY', 'DOCUMENT', 'CODE', 'FIXED', 'FORCED_DELIMITER') — 분할 전략: AUTO(자동 최적화), DICTIONARY(사전/테이블), DOCUMENT(문서/매뉴얼), CODE(소스코드), FIXED(고정 크기), FORCED_DELIMITER(강제 구분자)
  • chunking_algorithm — varchar(100) — 분할 알고리즘
  • chunk_size — int(11) — 분할 사이즈 (Min: 10, Max: 5000, Default: 800)
  • chunk_overlap — int(11) — 분할 오버랩 사이즈 (Min: 0, Max: 500, Default: 100)
  • min_chunk_group_size — int(11) — 분할 최소 그룹 사이즈 (Min: 10, Max: 500, Default: 10)
  • total_chunk_limit — int(11) — 청크 총합 제한 (모든 분할 방식에 적용, 초과 시 업로드 거부)
  • max_chunk_count — int(11) — 청크 Max 수
  • single_cell_table_textify — tinyint(1) — 단일 셀 테이블 텍스트화
  • table_data_chunking — tinyint(1) — 테이블 데이터 청킹
  • table_chunk_size — int(11) — 테이블 청크 사이즈
  • use_full_content — tinyint(1) — 전체 컨텐츠 사용
  • group_by_subtitle — tinyint(1) — 부제목 기준 추가 본문 그룹화
  • additional_body_unit — enum('LENGTH', 'CHUNK') — 추가 본문 단위
  • additional_body_length — int(11) — 추가 본문 길이 (앞)
  • additional_body_length_back — int(11) — 추가 본문 길이 (뒤)
  • custom_separators — text — 커스텀 구분자 (JSON 배열, 설정 시 AUTO 기본 구분자 미사용)
  • force_separators — text — 강제 구분자 (JSON 배열, 모든 기존 설정 무시)
  • force_separator_mode — tinyint(1) — 강제 구분자 모드 (활성화 시 강제 구분자만 적용)
  • created_at — datetime
  • updated_at — datetime

tb_knowledge_data_asset_selection

  • id — bigint(20) — Primary key — NOT NULL
  • knowledge_id — bigint(20) — Foreign key → tb_knowledge_information.id — NOT NULL — 지식정보 ID
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL — 사용자 ID
  • data_asset_id — bigint(20) — Foreign key → tb_data_assets.id — NOT NULL — 선택된 데이터 Asset ID
  • selection_order — int(11) — 선택 순서
  • created_by — bigint(20) — Foreign key → tb_accounts.id — 생성자 ID
  • updated_by — bigint(20) — Foreign key → tb_accounts.id — 수정자 ID
  • created_at — datetime
  • updated_at — datetime

tb_knowledge_information

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • name — varchar(500) — NOT NULL — 지식정보 이름
  • description — text — 지식정보 설명
  • permission_status — enum('UNRELEASED', 'PRIVATE', 'PUBLIC') — 권한 상태: 미배포, Private, Public
  • embedding_model — varchar(100) — Embedding 모델명 (예: RAG-EMBED)
  • status — enum('PENDING', 'PROCESSING', 'DONE', 'FAILED') — 처리 상태
  • created_by — bigint(20) — Foreign key → tb_accounts.id — 생성자 ID
  • updated_by — bigint(20) — Foreign key → tb_accounts.id — 수정자 ID
  • created_at — datetime
  • updated_at — datetime

tb_knowledge_retrieval_config

  • id — bigint(20) — Primary key — NOT NULL
  • knowledge_id — bigint(20) — Foreign key → tb_knowledge_information.id — NOT NULL — 지식정보 ID (1:1 관계)
  • search_type — enum('LEXICAL', 'VECTOR', 'HYBRID') — 검색 타입
  • vector_threshold — decimal(5, 4) — Vector 임계값 (0~1)
  • exact_knn — tinyint(1) — Exact KNN 사용 여부
  • es_top_k — int(11) — Top K
  • rerank_enabled — tinyint(1) — Rerank 사용 여부
  • rerank_model — varchar(100) — Rerank 모델명 (예: RAG-RERANK)
  • rerank_threshold — decimal(5, 4) — Rerank 임계값
  • rerank_top_k_candidates — int(11) — Rerank 후보 수
  • standard_rerank_score — tinyint(1) — Standard Rerank Score 사용 여부
  • temperature — decimal(3, 2) — Temperature (0~1)
  • extracted_chunk_count — int(11) — 추출 청크 수
  • max_tokens — int(11) — 최대 토큰 수
  • top_k — int(11) — Top-K
  • top_p — decimal(3, 2) — Top-P (0~1)
  • hidden_context — text — 히든 컨텍스트 (첫 번째)
  • created_at — datetime
  • updated_at — datetime

tb_knowledge_shares

  • id — bigint(20) — Primary key — NOT NULL
  • knowledge_id — bigint(20) — NOT NULL
  • owner_user_id — bigint(20) — NOT NULL
  • shared_with_user_id — bigint(20) — NOT NULL
  • shared_via_group_id — bigint(20) — NOT NULL
  • shared_at — datetime
  • created_by — bigint(20) — 생성자 ID
  • updated_by — bigint(20) — 수정자 ID
  • created_at — datetime
  • updated_at — datetime

tb_llm_models

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • full_name — varchar(200) — NOT NULL
  • served_model_name — varchar(200) — NOT NULL
  • endpoint_url — varchar(255)
  • port — int(11)
  • model_path — varchar(255)
  • status — varchar(20) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • tensor_parallel_size — int(11)
  • gpu_memory_utilization — decimal(4,2)
  • max_model_len — int(11)
  • max_num_batched_tokens — int(11)
  • max_num_seqs — int(11)
  • enable_chunked_prefill — tinyint(1)
  • swap_space — int(11)
  • max_new_tokens — int(11)
  • gen_max_tokens — int(11)
  • temperature — decimal(4,2)
  • top_k — int(11)
  • top_p — decimal(4,2)
  • repetition_penalty — decimal(4,2)
  • created_at — datetime — NOT NULL
  • updated_at — datetime

tb_messages

  • id — bigint(20) — Primary key — NOT NULL
  • conversation_id — bigint(20) — Foreign key → tb_conversations.id — NOT NULL
  • role — enum('user','assistant','system') — NOT NULL
  • content — mediumtext — NOT NULL
  • token_count — int(11)
  • created_at — datetime
  • content_ngrams — mediumtext
  • extracted_text — mediumtext
  • feedback — enum('like','dislike')
  • FULLTEXT — KEY

tb_personal_app_conversations

  • id — int(11) — Primary key — NOT NULL
  • app_id — int(11) — Foreign key → tb_personal_apps.id — NOT NULL
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • title — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

tb_personal_app_messages

  • id — int(11) — Primary key — NOT NULL
  • conversation_id — int(11) — Foreign key → tb_personal_app_conversations.id — NOT NULL
  • app_id — int(11) — Foreign key → tb_personal_apps.id — NOT NULL
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • role — enum('user','assistant','system') — NOT NULL
  • content — longtext — NOT NULL
  • token_count — int(11)
  • created_at — timestamp

tb_personal_app_shares

  • id — int(11) — Primary key — NOT NULL
  • app_id — int(11) — Foreign key → tb_personal_apps.id — NOT NULL
  • owner_user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • shared_with_user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • shared_via_group_id — int(11)
  • shared_at — timestamp

tb_personal_apps

  • id — int(11) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → tb_accounts.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text
  • instructions — text — NOT NULL
  • system_prompt — text — NOT NULL
  • temperature — decimal(3, 2)
  • top_k — int(11)
  • top_p — decimal(3, 2)
  • max_tokens — int(11)
  • model_name — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp
  • icon — longtext
  • chunk_strategy — varchar(20)
  • chunk_size — int(11)
  • chunk_overlap — int(11)
  • custom_separators — text
  • force_separators — text
  • force_mode — tinyint(1) — NOT NULL
  • is_public — tinyint(1) — 전체 공개 여부 (0: 비공개, 1: 공개)
  • display_order — int(11)
  • public_display_order — int(11)
  • retriever_count — int(11) — NOT NULL — 검색할 문서 수 (1-10개, 기본값: 5개)
  • hidden_context — text

tb_prompt_library

  • id — int(11) — Primary key — NOT NULL
  • category_group — varchar(50) — NOT NULL
  • category — varchar(100) — NOT NULL
  • title — varchar(200) — NOT NULL
  • description — text
  • prompt — mediumtext — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • is_favorite — tinyint(1) — NOT NULL
  • FULLTEXT — KEY

tb_qna

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • password — varchar(100)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • reply_to — int(11)

tb_rag_context

  • TABLE_NM — varchar(100) — Primary key — NOT NULL
  • TABLE_COMMENT — varchar(100)

tb_rag_ddl

  • table_nm — varchar(100) — NOT NULL
  • table_ddl — varchar(10000)

tb_rag_mapping

  • table_nm — varchar(100) — NOT NULL
  • mapping — varchar(10000) — NOT NULL

tb_usecase

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • reply_to — int(11)

tb_vdb_files

  • id — bigint(20) — Primary key — NOT NULL
  • filename — varchar(255) — NOT NULL
  • file_content — longtext — NOT NULL
  • created_at — datetime — NOT NULL