금융 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