tripleTest

Tables (5)

place (Untitled2)

  • placeId (Key) — Primary key — NOT NULL
  • placeName (Field)
  • reviewCheck (Field2)

review (Untitled3)

  • reviewId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user.userId — NOT NULL
  • placeId (Key3) — Foreign key → place.placeId — NOT NULL
  • content (Field)
  • attachedPhotoIds (Field2)

user (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • userName (Field)

userPoint (Untitled4)

  • userPointId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user.userId — NOT NULL
  • userPoint (Field)

userPointStatus (Untitled5)

  • userPointStateId (Key) — Primary key — NOT NULL
  • userPointId (Key2) — Foreign key → userPoint.userPointId — NOT NULL
  • userId (Key22) — Foreign key → userPoint.userId — NOT NULL
  • content (Field)