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