Wanted

Tables (4)

Location (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • do-si (Field) — varchar(255)
  • sgg (Field2) — varchar(255)
  • lat (Field3) — varchar(255)
  • lon (Field4) — varchar(255)

Member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • email (Field) — varchar(255) — NOT NULL
  • password (Field2) — varchar(255) — NOT NULL
  • refresh_token (Field3) — varchar(255)
  • username (Field4) — varchar(255)

Review (Untitled3)

  • member_id (2) — bigint — Foreign key → Member.id — NOT NULL
  • store_id (Key) — bigint — Foreign key → Store.id — NOT NULL
  • score (Field) — int
  • content (Field2) — varchar(255)

Store (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • lat (Field) — varchar(255)
  • lon (Field2) — varchar(255)
  • name (Field3) — varchar(255)
  • address (Field4) — varchar(255)
  • category (Field5) — varchar(255)
  • rating (Field6) — double