LawForm
Tables (4)
BOT_ANSWER_LIST (회원-챗봇 답변내역)
- A_ID (답변ID) — INT — Primary key — NOT NULL
- MEM_ID (회원ID) — INT
- CONTENT (답변내역) — JSON
- A_DATE (답변일시) — DATETIME
- Q_ID (질문번호) — INT — Foreign key → BOT_QUESTION_LIST.Q_ID — NOT NULL
BOT_QUESTION_LIST (회원-챗봇 질문내역)
- Q_ID (질문ID) — INT — Primary key — NOT NULL
- MEM_ID (회원ID2) — INT — Foreign key → MEMBER_INFO.MEM_ID — NOT NULL — AUTO_INCREMENT
- MEM_ID (회원ID) — INT
- CONTENT (질문내역) — JSON
- Q_DATE (질문일시) — DATETIME
MEMBER_INFO (회원데이터)
- MEM_ID (회원ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- EMAIL (이메일) — VARCHAR(255)
- PASSWORD (비밀번호) — VARCHAR(255)
- CREATED_AT (가입일) — DATETIME
- UPDATED_AT (수정일) — DATETIME
- RESIDENT_NO (주민번호) — VARCHAR(9)
- PHONE_NO (연락처) — VARCHAR(13)
MEMBER_TOKEN (회원토큰)
- MEM_ID (회원ID) — INT — Primary key — NOT NULL
- ID (토큰ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- MEM_ID (회원ID2) — INT — Foreign key → MEMBER_INFO.MEM_ID — NOT NULL — AUTO_INCREMENT
- ACCESS_TOKEN (액세스 토큰) — VARCHAR(255)
- REFRESH_TOKEN (리프레시 토큰) — VARCHAR(255)
- CREATED_AT (생성 시간) — DATETIME
- UPDATED_AT (수정시간) — DATETIME
- TYPE (SNS / 일반) — VARCHAR(10) — KAKAO(카카오) / 일반(DEFAULT)