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