UMC_Week0

Tables (8)

FavoriteFood (favorite_food)

  • id (favorite_food_id) — BIGINT — Primary key — NOT NULL
  • id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • id (food_id) — BIGINT — Foreign key → Food.id — NOT NULL

Food (food)

  • id (food_id) — BIGINT — Primary key — NOT NULL
  • name (food_name) — VARCHAR

Member (member)

  • id (member_id) — BIGINT — Primary key — NOT NULL
  • loginId (login_id) — VARCHAR
  • password — VARCHAR
  • name (member_name) — VARCHAR
  • gender — VARCHAR
  • birthDate (birth_date) — DATE
  • address (member_address) — VARCHAR
  • inactiveDate (inactive_date) — DATE
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME

MemberMission (member_mission)

  • id (member_mission_id) — BIGINT — Primary key — NOT NULL
  • isComplete (is_complete) — BOOLEAN
  • finishAt (finish_at) — DATETIME
  • id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • id (mission_id) — BIGINT — Foreign key → Misson.id — NOT NULL

Misson (mission)

  • id (mission_id) — BIGINT — Primary key — NOT NULL
  • dtype — VARCHAR
  • text (misson_text) — VARCHAR
  • point (mission_point) — BIGINT
  • finishDate (finish_date) — DATETIME
  • createdAt (created_at) — DATETIME
  • updateAt (update_at) — DATETIME
  • id (shop_id) — BIGINT — Foreign key → Shop.id — NOT NULL

ReviewPhoto (review_photo)

  • id (review_photo_id) — BIGNIT — Primary key — NOT NULL
  • photo — VARCHAR
  • id (shop_review_id) — BIGINT — Foreign key → ShopReview.id — NOT NULL

Shop (shop)

  • id (shop_id) — BIGINT — Primary key — NOT NULL
  • name (shop_name) — VARCHAR
  • shopType (shop_type) — VARCHAR
  • address (shop_address) — VARCHAR
  • number — BIGINT

ShopReview (shop_review)

  • id (shop_review_id) — BIGINT — Primary key — NOT NULL
  • rating — DOUBLE
  • text (shop_text) — VARCHAR
  • createdAt (created_at) — DATETIME
  • updateAt (update_at) — DATETIME
  • id (shop_id) — BIGINT — Foreign key → Shop.id — NOT NULL
  • id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL