Hotplace

Tables (4)

follow (Follow)

  • id (Key) — Primary key — NOT NULL
  • user (Key3) — UUID — Foreign key → user.user_id — NOT NULL
  • from_user (Key4) — UUID — Foreign key → user.user_id — NOT NULL
  • created_at (Field) — DATETIME(6)

hotplace (Hotplace)

  • hotplace_id (Key) — UUID — Primary key — NOT NULL
  • name (Field4) — VARCHAR(50)
  • description (Field3) — VARCHAR(200)
  • longitude (Field) — DECIMAL(20, 12)
  • latitude (Field2) — DECIMAL(20, 12)
  • user (Key2) — UUID — Foreign key → user.user_id — NOT NULL

recommand (Recommand)

  • id (Key3) — UUID — Primary key — NOT NULL
  • user_id (Key) — UUID — Foreign key → user.user_id — NOT NULL
  • hotplace_id (Key2) — UUID — Foreign key → hotplace.hotplace_id — NOT NULL
  • created_at (Field) — DATETIME(6)

user (User)

  • user_id (Key) — UUID — Primary key — NOT NULL
  • id (Field) — VARCHAR(50)
  • name (Field2) — VARCHAR(20)
  • phoneNum (Field4) — VARCHAR(20)
  • password (Field3) — VARCHAR(30)
  • city (Field5)
  • gu (Field6)