UMC 11th 1week

Tables (7)

Food_category (Untitled3)

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR

Member (Untitled)

  • member_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • email — VARCHAR
  • point — INT
  • created_at — DATETIME

Region (Untitled2)

  • region_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR

member_mission (Untitled8)

  • member_mission_id — BIGINT — Primary key — NOT NULL
  • status — VARCHAR
  • completed_at — DATETIME
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL

mission (Untitled6)

  • mission_id — BIGINT — Primary key — NOT NULL
  • description — VARCHAR
  • reward_point — INT
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL

social_login (Untitled4)

  • social_id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR
  • provider_user_id — VARCHAR
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL

store (Untitled5)

  • store_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • address — VARCHAR
  • region_id (region_id2) — BIGINT — Foreign key → Region.region_id — NOT NULL
  • category_id (category_id2) — BIGINT — Foreign key → Food_category.category_id — NOT NULL