챗봇 이루미

테이블 (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