erd_1st

Tables (7)

foodcategory

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • prefer_food — varchar(20)

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender — varchar(20)
  • birthdate — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • status — varchar(20)
  • last_login — datetime
  • email — varchar(20)
  • password — varchar(20)
  • point — varchar(20)
  • phone_number — varchar(20)
  • nickname — varchar(20)

member_mission

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • id (id2) — bigint — Foreign key → mission.store_id — NOT NULL
  • food_category_id — bigint — Foreign key → mission.food_category_id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(20)
  • is_completed — boolean
  • deadline — datetime(6)
  • activated — boolean

mission

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • food_category_id — bigint — Foreign key → store.food_category_id — NOT NULL
  • description — varchar(20)
  • title — varchar(20)
  • point_reward — bigint

review

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • grade — varchar(20)
  • description — varchar(30)
  • created_at — datetime(6)

review_photo

  • id — bigint — Primary key — NOT NULL
  • review_id (reveiw_id) — bigint — Foreign key → review.id — NOT NULL
  • link — varchar(60)

store

  • id — bigint — Primary key — NOT NULL
  • food_category_id — bigint — Foreign key → foodcategory.id — NOT NULL
  • subscription — varchar(20)
  • address — varchar(20)
  • name — varchar(20)