capstone

Tables (9)

Note (Untitled4)

  • id (Key2) — Primary key — NOT NULL
  • userId (Key) — Foreign key → User.Id — NOT NULL
  • adult (Field)
  • animal (Field2)
  • child (Field3)
  • day_end (Field4)
  • day_start (Field5)
  • public_share (Field6)
  • thumbnail (Field7)
  • title (Field8)
  • max_place_per_day (Field9)

NotePlace (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • noteId (Key2) — Foreign key → Note.id — NOT NULL
  • placeId (Key4) — Foreign key → Place.Id — NOT NULL

Place (Untitled6)

  • Id (Key) — Primary key — NOT NULL
  • address (Field)
  • introduction (Field2)
  • likeCount (Field3)
  • phone (Field4)
  • point (Field5)
  • popularity (Field6)
  • tag (Field7)
  • thumbnail (Field8)
  • title (Field9)
  • type (Field10)

PlaceComment (CopyOfUntitled3)

  • id (Key3) — Primary key — NOT NULL
  • userId (Key) — Foreign key → User.Id — NOT NULL
  • placeId (Key2) — Foreign key → Place.Id — NOT NULL
  • text (Field)

PlaceCommentLike (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.Id — NOT NULL
  • placeCommentId (Key3) — Foreign key → PlaceComment.id — NOT NULL

PlaceLike (Untitled3)

  • id (Key3) — Primary key — NOT NULL
  • userId (Key) — Foreign key → User.Id — NOT NULL
  • placeId (Key2) — Foreign key → Place.Id — NOT NULL

PlaceReview (Untitled5)

  • Id (Key3) — Primary key — NOT NULL
  • UserId (Key) — Foreign key → User.Id — NOT NULL
  • PlaceId (Key2) — Foreign key → Place.Id — NOT NULL
  • rating (Field)
  • content (Field2)

Survey (Untitled8)

  • Id (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.Id — NOT NULL
  • placeId (Key3) — Foreign key → Place.Id — NOT NULL
  • rate (Field)

User (Untitled)

  • Id (Key) — Primary key — NOT NULL
  • email (Field)
  • img (Field2)
  • name (Field3)
  • nickname (Field4)
  • password (Field5)
  • phone (Field6)
  • region (Field7)
  • introduction (Field8)