GenAI DB Schema
Tables (10)
DB connection information (tb_dbconn)
- db connection id (dbconn_id) — serial — Primary key — NOT NULL
- host — inet — NOT NULL
- port number (port) — int — NOT NULL
- user_name — varchar
- password (pwd) — varchar(200)
- DB name (db) — varchar(200)
- selected table (tb) — varchar(63)
- selecter column (col) — varchar(59)
- user number (user_no) — int — Foreign key → user.user number — NOT NULL
- email — varchar(200) — Foreign key → user.email — NOT NULL
authority (tb_auth)
- authority id (auth_id) — serial — Primary key — NOT NULL
- authority code (auth_cd) — varchar(10)
- administrator or not (is_admin) — char(1)
- create date (cdate) — timestamp
- update date (udate) — timestamp
- user number (user_no) — int — Foreign key → user.user number
- email — varchar(200) — Foreign key → user.email
chatbot detail setting (tb_chatbot_set)
- chatbot id (id) — serial — Foreign key → chatbot profile setting.chatbot id — NOT NULL
- answer tendency (tendency) — numeric — Check Constrain로 0 ~ 2까지 0.1 단위로 실수형 데이터 증감 범위 지정 CHECK (column >= 0 AND column <= 2 AND column % 0.1 = 0)
- search_size — smallint — Check Constrain로 0 ~ 10 까지 정수형 범위 지정 CHECK (column >= 0 AND column <= 10)
- setting role (role) — varchar
- directive — varchar
- selecting language model code (lang_mod) — varchar — 범주형 컬럼에 대한 category 설정 CHECK (category IN ('gpt-4o-mini', 'gpt-3.5-turbo', 'miltilingual-e5-large', 'CLIP-ViT-B-32-laio…
- API value (api) — varchar
- whether VDB or GDB (is_vector) — char(1)
- file id (file_id) — int
- create date (cdate) — timestamp
- update date (udate) — timestamp
- creator (cuser) — varchar
- updator (uuser) — varchar
chatbot profile setting (tb_chatbot_prof)
- chatbot id (id) — serial — Primary key — NOT NULL
- chatbot name (chat_name) — varchar
- chatbot description (description) — varchar(1000)
- whether to delte chatbot (is_del) — char(1)
- create date (cdate) — timestamp
- update date (udate) — timestamp
- creator (cuser) — varchar
- updator (uuser) — varchar
- user number (user_no) — serial — Foreign key → user.user number — NOT NULL
- email — varchar(200) — Foreign key → user.email — NOT NULL
common code (tb_code)
- code type id (cdtype_id) — varchar(10) — Primary key — NOT NULL
- code (Key) — varchar(10) — Primary key — NOT NULL
- code name (cd_nm) — varchar(100)
- english code type (cdtype_eng) — varchar(100)
- whether to delete (use_YN) — char(1)
- create date (cdate) — timestamp
- update date (udate) — timestamp
- code type id (cdtype_id2) — varchar(10) — Foreign key → common code.code type id
document setting (tb_docset)
- file id (file_id) — int — Foreign key → upload file.file id — NOT NULL
- the num of chunk duplication (chunk_dup) — int — 10 ~ 1500까지 값, 1씩 증가, defalut 1200
- VDB or GDB (is_vector) — char(1) — 여기는 NULL일 경우 '파일'이 설정되도록 하기
- chunk size (chunk_size) — int — 100부터 2500까지의 값, 1씩 증가, default 1000
- filtering value (filtering) — varchar(100)
- metadata value (metadata) — jsonb
- index name (idx) — varchar
- selecting embedding model with code (embd_mod_cd) — varchar
- API value (api) — varchar
multi language (tb_multilang)
- id — serial — Primary key — NOT NULL
- language id (lang_cd) — char(3) — CHECK (LANG_CD IN ('KOR' , 'ENG'))
- key (lang_key) — varchar(200)
- translation value (lang_trans) — varchar(200)
- create data (cdate) — timestamp
- update date (udate) — timestamp
- user number (user_no) — serial — Foreign key → user.user number — NOT NULL
- email — varchar(200) — Foreign key → user.email — NOT NULL
password (tb_pwd)
- pwd id (pwd_id) — serial — Primary key — NOT NULL
- user number (user_no) — serial — Foreign key → user.user number — NOT NULL
- email — varchar(200) — Foreign key → user.email — NOT NULL
- password (pwd) — varchar(200)
- salt — varchar
- hashed password (hashed_password) — varchar
- create date (cdate) — timestamp
- update date (udate) — timestamp
upload file (tb_uploadfile)
- file id (file_id) — serial — Primary key — NOT NULL
- original file name (org_filenm) — varchar(200)
- saver file name (sv_filenm) — varchar(200)
- file path (sv_filepath) — varchar(300)
- file extension code (file_ext_cd) — varchar(20)
- file size (file_size) — int
- contents type (con_type) — varchar(20)
- whether to use Vector DB (is_vector) — char(1)
- whether to delete (del_YN) — char(1)
- registrant (cuser) — int
- updator (uuser) — int
- regist date (cdate) — timestamp
- udpate date (udate) — timestamp
- user number (user_no) — serial — Foreign key → user.user number — NOT NULL
- email — varchar(200) — Foreign key → user.email — NOT NULL
user (tb_user)
- user number (user_no) — serial — Primary key — NOT NULL
- email — varchar(200) — Primary key — NOT NULL
- administrator or not (is_admin) — char(1)
- department (dept) — varchar(100)
- user name (user_nm) — varchar(100)
- create date (cdate) — timestamp
- update date (udate) — timestamp