Calm down ERD

Tables (5)

History (이력)

  • 이력식별키 (history_id) — int — Primary key — NOT NULL
  • 회원식별키 (member_id) — int — Foreign key → Member.회원식별키 — NOT NULL
  • GPT에 대한 응답 (gpt_response) — varchar
  • 응답시간 (created_at) — timestamp

Member (회원)

  • 회원식별키 (member_id) — int — Primary key — NOT NULL
  • 이메일or아이디 (email) — varchar
  • 비밀번호 (password) — varchar
  • 회원명 (username) — varchar
  • 나이 (age) — int
  • 성별 (gender)
  • 생성일자 (created_at) — timestamp

Question (질문)

  • 질문식별키 (question_id) — int — Primary key — NOT NULL
  • 질문 (question_text) — varchar
  • 질문순서 (order_number) — int
  • 선택지1 (option1) — varchar
  • 선택지2 (option2) — varchar
  • Field

Recommendation (추천)

  • 추천식별키 (recommecdation_id) — int — Primary key — NOT NULL
  • 회원식별키 (member_id) — int — Foreign key → Member.회원식별키 — NOT NULL
  • GPT에 대한 응답 (gpt_response) — varchar
  • 현재계절 (season) — varchar
  • 생성시간 (created_at) — varchar

User_renponse (질문에 대한 대답)

  • 응답식별키 (response_id) — int — Primary key — NOT NULL
  • 회원식별키 (member_id) — int — Foreign key → Member.회원식별키 — NOT NULL
  • 질문식별키 (question_id) — int — Foreign key → Question.질문식별키 — NOT NULL
  • 대답 (answer) — boolean
  • 국가대답 (custom_answer) — varchar
  • 응답시간 (response_date) — timestamp
  • Field