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