good-restaurant

Tables (4)

DeliciousPlace (식당)

  • deliciousPlaceId (Key) — bigInt — Primary key — NOT NULL
  • userId (Key2) — bigInt — Foreign key → User.userId — NOT NULL
  • placeId (Field) — bigInt
  • placeName (Field2) — String
  • placeAddress (Field3) — String
  • placeUrl (Field4) — String

Follow (팔로우/팔로잉)

  • followId (Key) — bigInt — Primary key — NOT NULL
  • userId (Key2) — bigInt — Foreign key → User.userId — NOT NULL
  • statement (Field) — boolean

Promise (Untitled)

  • promiseId (Key) — bigInt — Primary key — NOT NULL
  • userId (Key2) — bigInt — Foreign key → User.userId — NOT NULL
  • deliciousPlaceId (Key3) — bigInt — Foreign key → DeliciousPlace.deliciousPlaceId — NOT NULL
  • userId (Key22) — bigInt — Foreign key → DeliciousPlace.userId — NOT NULL
  • statement (Field) — boolean

User (사용자)

  • userId (Key) — bigInt — Primary key — NOT NULL
  • email (Field) — String
  • password (Field2) — String
  • role (Field3) — Enum