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)