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