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