erd
Tables (9)
CheckList (Untitled5)
- checklist_id (Key) — NOT NULL — Primary key — NOT NULL
- schedule_id (Key2) — NOT NULL — Foreign key → Schedule.schedule_id — NOT NULL
- user_id (Key22) — NOT NULL — Foreign key → Schedule.user_id — NOT NULL
- checkList (Field) — NULL
- checkVerify (Field2) — 0
CrawlingData (Untitled7)
- crawling_id (Key) — NOT NULL — Primary key — NOT NULL
- image_url (Field) — NOT NULL
- link_uri (Field2) — NOT NULL
- index (Field3) — NOT NULL
FriendList (Untitled9)
- friendlist_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL
- friendUID (Field) — NOT NULL
PayList (Untitled6)
- paylist_id (Key) — NOT NULL — Primary key — NOT NULL
- schedule_id (Key2) — NOT NULL — Foreign key → Schedule.schedule_id — NOT NULL
- user_id (Key22) — NOT NULL — Foreign key → Schedule.user_id — NOT NULL
- productInfo (Field) — NULL
- productCost (Field2) — NULL
Review (Untitled4)
- review_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL
- starPoint (Field) — NOT NULL
- reviewInfo (Field2) — NOT NULL
- reviewDate (Field3) — NOT NULL
ReviewPhoto (Untitled8)
- review_photo_id (Key) — NOT NULL — Primary key — NOT NULL
- photo_url (Field) — NOT NULL
- review_id (Key2) — NOT NULL — Foreign key → Review.review_id — NOT NULL
- user_id (Key22) — NOT NULL — Foreign key → Review.user_id — NOT NULL
Schedule (Untitled2)
- schedule_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL
- placeList (Field) — NOT NULL
- moveTime (Field2) — NOT NULL
ScheduleDetails (Untitled3)
- schedule_details_id (Key) — NOT NULL — Primary key — NOT NULL
- startPlace (Field) — NOT NULL
- playTime (Field2) — NOT NULL
- eatPlace (Field3) — NULL
- eatTime (Field4) — NULL
- hopePlace (Field5) — NULL
- schedule_id (Key2) — NOT NULL — Foreign key → Schedule.schedule_id — NOT NULL
- user_id (Key22) — NOT NULL — Foreign key → Schedule.user_id — NOT NULL
User (Untitled)
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- loginID (Field) — NOT NULL
- loginPW (Field2) — NOT NULL
- Name (Field3) — NOT NULL
- intro (Field4) — NOT NULL
- preferTag (Field5) — Null