금융 SM 맞춤형 로컬 AI 비서 FINAL

테이블 (5)

ADOPTED_HISTORY

  • ADOPT_ID — VARCHAR(50) — 기본 키 — NOT NULL
  • CHAT_ID — VARCHAR(50)
  • VECTOR — TEXT
  • EMP_ID — VARCHAR(50) — NOT NULL
  • DEPT_CD — VARCHAR(50) — NOT NULL
  • ADOPTED_QUESTION — TEXT — NOT NULL
  • ADOPTED_ANSWER — TEXT — NOT NULL
  • SELECTED_TYPE — VARCHAR(20) — NOT NULL
  • WEIGHT_SCORE — DECIMAL(3,2)
  • CREATED_AT — VARCHAR(50)
  • CREATED_TM — TIMESTAMP
  • UPDATED_AT — VARCHAR(50)
  • UPDATED_TM — TIMESTAMP

CHAT_HISTORY

  • CHAT_ID — VARCHAR(50) — 기본 키 — NOT NULL
  • ROOM_ID — VARCHAR(50) — 외래 키 → CHAT_ROOM.ROOM_ID — NOT NULL
  • EMP_ID — VARCHAR(20) — 외래 키 → USER_DEPT.EMP_ID — NOT NULL
  • MESSAGE — TEXT — NOT NULL
  • USED_YN — TINYINT
  • COMPLIANCE_YN — TINYINT
  • CREATED_AT — VARCHAR(50)
  • CREATED_TM — TIMESTAMP
  • UPDATED_AT — VARCHAR(50)
  • UPDATED_TM — TIMESTAMP

CHAT_ROOM

  • ROOM_ID — VARCHAR(50) — 기본 키 — NOT NULL
  • ROOM_NAME — VARCHAR(150) — NOT NULL
  • ROOM_TYPE — VARCHAR(20) — NOT NULL
  • CREATED_AT — VARCHAR(50)
  • CREATED_TM — TIMESTAMP
  • UPDATED_AT — VARCHAR(50)
  • UPDATED_TM — TIMESTAMP

CHAT_ROOM_MEMBER

  • ROOM_ID — VARCHAR(50) — 외래 키 → CHAT_ROOM.ROOM_ID — NOT NULL
  • EMP_ID — VARCHAR(20) — 외래 키 → USER_DEPT.EMP_ID — NOT NULL
  • JOINED_AT — TIMESTAMP

USER_DEPT

  • EMP_ID — VARCHAR(20) — 기본 키 — NOT NULL
  • EMP_NAME — VARCHAR(50) — NOT NULL
  • DEPT_CD — VARCHAR(50)
  • DEPT_NAME — VARCHAR(100) — NOT NULL
  • CREATED_AT — VARCHAR(50)
  • CREATED_TM — TIMESTAMP
  • UPDATED_AT — VARCHAR(50)
  • UPDATED_TM — TIMESTAMP