gdsc-5team
Tables (9)
answers (대답)
- answer_id (PK) — Long — Primary key — NOT NULL
- answer_text (Field3) — TEXT — NOT NULL
- summary_text (Field4) — TEXT — NOT NULL
- question_id (PK2) — Long — Foreign key → questions.question_id — NOT NULL
- elder_id (PK3) — Long — Foreign key → elders.elder_id — NOT NULL
- event_id (Key) — Long — Foreign key → calendar_events.event_id — NOT NULL
calendar_events (Untitled4)
- event_id (Key) — Long — Primary key — NOT NULL
- title (Field) — String — NOT NULL
- description (Field2) — TEXT
- type (Field3) — Enum — NOT NULL
- date (Field4) — LocalDateTime — NOT NULL
- elder_id (PK) — Long — Foreign key → elders.elder_id — NOT NULL
- guardian_id (Key2) — Long — Foreign key → guardians.guardian_id
elder_interest (사용자-관심항목)
- elder_interest_id (PK) — Long — Primary key — NOT NULL
- elder_id (PK2) — Long — Foreign key → elders.elder_id — NOT NULL
- interest_id (PK3) — Long — Foreign key → interests.interest_id — NOT NULL
elders (Untitled)
- elder_id (PK) — Long — Primary key — NOT NULL
- name — String — NOT NULL
- birth (Field2) — LocalDateTime
guardian_elder (Untitled3)
- guardian_elder_id (Key) — Long — Primary key — NOT NULL
- guardian_id (Key2) — Long — Foreign key → guardians.guardian_id — NOT NULL
- elder_id (PK) — Long — Foreign key → elders.elder_id — NOT NULL
guardians (Untitled2)
- guardian_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String — NOT NULL
- birth (Field2) — LocalDateTime — NOT NULL
- email (Field3) — String — NOT NULL
- password (Field4) — String — NOT NULL
interests (관심항목)
- interest_id (PK) — Long — Primary key — NOT NULL
- name — String — NOT NULL
questions (질문)
- question_id (PK) — Long — Primary key — NOT NULL
- question_text — TEXT — NOT NULL
- interest_id (PK2) — Long — Foreign key → interests.interest_id — NOT NULL
recommendations (추천)
- recommendation_id (PK) — Long — Primary key — NOT NULL
- recommendation_text (Field4) — TEXT — NOT NULL
- answer_id (PK2) — Long — Foreign key → answers.answer_id — NOT NULL