UMC_Week1

Tables (8)

Member (member)

  • Member Id (id) — BIGINT — Primary key
  • Name (name) — varchar — NOT NULL
  • Email (email) — varchar — NOT NULL
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp

Mission (mission)

  • Mission id (id) — BIGINT — Primary key — NOT NULL
  • store id (id2) — BIGINT — Foreign key → store.store id — NOT NULL
  • title — varchar — NOT NULL
  • Description (description) — varchar
  • Phone number (phone_number) — varchar
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp
  • reward point (reward_point) — int — NOT NULL

food category (food_category)

  • food category id (id) — BIGINT — Primary key
  • category name (name) — varchar — NOT NULL
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp

member_food_category

  • food category id (id) — BIGINT — Primary key
  • Member Id (member.id) — BIGINT — Foreign key → Member.Member Id
  • food category id (id2) — BIGINT — Foreign key → food category.food category id
  • category name (name) — varchar — NOT NULL
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp

member_mission

  • MemeberMission id (id) — BIGINT — Primary key — NOT NULL
  • store id (id2) — BIGINT — Foreign key → store.store id — NOT NULL
  • title — varchar — NOT NULL
  • status — varchar
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp
  • reward point (reward_point) — int — NOT NULL
  • Mission id (id3) — BIGINT — Foreign key → Mission.Mission id — NOT NULL

member_social_account

  • id — BIGINT — Primary key
  • Member Id (member.id) — BIGINT — Foreign key → Member.Member Id
  • provider — varchar
  • provider_user_id — varchar
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp

region

  • region id (id) — BIGINT — Primary key
  • Name (name) — varchar — NOT NULL
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp

store

  • store id (id) — BIGINT — Primary key — NOT NULL
  • region id (id2) — BIGINT — Foreign key → region.region id
  • food category id (id3) — BIGINT — Foreign key → food category.food category id
  • name — varchar — NOT NULL
  • address — varchar — NOT NULL
  • Description (description) — varchar
  • Phone number (phone_number) — varchar
  • Created Date (created_at) — timestamp — NOT NULL
  • Updated Date (updated_at) — timestamp
  • Deleted Date (deleted_at) — timestamp