Boo!M

Tables (4)

Manner (Untitled3)

  • id (Key2) — Primary key — NOT NULL
  • userId (Key) — String(uuid) — Foreign key → User.id — NOT NULL
  • score (Field) — Int (0~5)
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

Moim (Untitled2)

  • id (Key) — String(uuid) — Primary key — NOT NULL
  • creatorId (Key2) — String(uuid) — Foreign key → User.id — NOT NULL
  • description (Field3) — String
  • latitude (Field4) — Float
  • longitude (Field5) — Float
  • createdAt (Field) — Date
  • updatedAt (Field2) — Date

Participated (Untitled4)

  • id (Key3) — Primary key — NOT NULL
  • participantId (Key) — String(uuid) — Foreign key → User.id — NOT NULL
  • moimId (Key2) — String(uuid) — Foreign key → Moim.id — NOT NULL

User (Untitled)

  • id (Key) — String(uuid) — Primary key — NOT NULL
  • studentId (Field3) — Int
  • name (Field4) — String
  • avatar (Field5) — String
  • phone (Field6) — String
  • email (Field7) — String
  • longitude (Field2) — Float
  • latitude (Field) — Float
  • createdAt (Field8) — Date
  • updatedAt (Field9) — Date