seenEar

Tables (4)

AdviceCard (Untitled)

  • id (Key) — Primary key — NOT NULL
  • adviceType (Field) — enum
  • concernType (Field2) — enum
  • text (Field3) — String
  • speechUrl (Field4) — String
  • advisor (Field5) — Member
  • Field6

Member

  • id (Key2) — Primary key — NOT NULL
  • name (Field2)
  • email (Field3)
  • type (Field) — enum
  • phoneNum (Field4)

MemberAdviceMapping (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Member.id — NOT NULL
  • id (Key3) — Foreign key → AdviceCard.id — NOT NULL
  • youth (Field) — Member
  • advice (Field2) — Advice

ThanksCard (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Member.id — NOT NULL
  • youth (Field) — Member
  • elder (Field2) — Member
  • speechUrl (Field3) — String
  • text (Field4) — String