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)