playground

Tables (4)

User (Untitled)

  • ID (Key) — int — Primary key — NOT NULL
  • login_id (Field) — varchar
  • password (Field2) — varchar
  • name (Field3) — varchar
  • area (Field4) — varchar
  • email (Field5) — varchar

community (Untitled3)

  • user_id (후보key) — varchar — Primary key — NOT NULL
  • ID (Key) — int — Foreign key → User.ID — NOT NULL
  • info (Field) — varchar
  • comment (Field2) — varchar
  • createAt (Field3) — DATETIME

paly-map (Untitled4)

  • user_id (후보key) — varchar — Primary key — NOT NULL
  • ID (Key) — int — Foreign key → User.ID — NOT NULL
  • map_url (Field) — varchar

play-review (Untitled2)

  • user_id (후보key) — varchar — Foreign key → paly-map.user_id — NOT NULL
  • ID (Key) — int — Foreign key → paly-map.ID — NOT NULL
  • review (Field) — varchar
  • image_url (Field2) — varchar
  • createAt (Field3) — DATETIME
  • recommendation (Field4)
  • review_seq (Field5) — int