챗봇 이루미
테이블 (8)
TO-DO-LIST (TO_DO_LIST)
- todo_no (PK) — INT — 기본 키 — NOT NULL
- mem_no (FK1) — INT — 외래 키 → 회원정보.mem_no — NOT NULL
- todo_detail (Field) — VARCHAR(255)
- priority (Field2) — INT
- duration (Field3) — INT
답변내역(GPT) (GPT_ANSWER_LIST)
- answer_no (PK) — INT — 기본 키 — NOT NULL
- question_no (FK1) — INT — 외래 키 → 질문내역(GPT).question_no — NOT NULL
- answer_detail (Field) — VARCHAR(255)
답변내역(챗봇) (BOT_ANSWER_LIST)
- answer_no (PK) — INT — 기본 키 — NOT NULL
- mem_no (FK1) — INT — 외래 키 → 회원정보.mem_no — NOT NULL
- question_no (FK2) — INT — 외래 키 → 질문내역(챗봇).question_no — NOT NULL
- answer_detail (Field) — VARCHAR(255) — NOT NULL
- answer_date (Field2) — DATE
대시보드 (DASHBOARD)
- dashboard_no (PK) — INT — 기본 키 — NOT NULL
- total_user (Field) — INT
- today_join (Field2) — INT
- gpt_total_cost (Field3) — INT
- ind_cost (Field4) — INT
- dau (Field5) — INT
주간계획 (WEEKLY_PLAN)
- weekly_plan_no (PK) — INT — 기본 키 — NOT NULL
- mem_no (FK1) — INT — 외래 키 → 회원정보.mem_no — NOT NULL
- week_no (Field) — INT
- day_no (Field4) — VARCHAR(10)
- weekly_plan_detail (Field2) — INT
- status (Field3) — INT
질문내역(GPT) (GPT_QUESTION_LIST)
- question_no (PK) — INT — 기본 키 — NOT NULL
- question_detail (Field) — VARCHAR(255)
질문내역(챗봇) (BOT_QUESTION_LIST)
- question_no (PK) — INT — 기본 키 — NOT NULL
- question_detail (Field) — VARCHAR(255) — NOT NULL
- question_date (Field2) — DATE
회원정보 (MEMBER_INFO)
- mem_no (PK) — INT — 기본 키 — NOT NULL
- user_id (Field) — VARCHAR(20) — NOT NULL
- pw (Field2) — VARCHAR(20) — NOT NULL
- name (Field3) — VARCHAR(10) — NOT NULL
- email (Field4) — VARCHAR(50) — NOT NULL
- phone_no (Field5) — VARCHAR(20) — NOT NULL
- reg_date (Field6) — DATE — NOT NULL
- job (Field7) — VARCHAR(20)
- prepare_date (Field8) — INT