UMC11th

Tables (8)

Member (사용자)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • gender (Field2) — ENUM
  • name (Field) — VARCHAR
  • birth (Field3) — VARCHAR
  • email (Field8) — VARCHAR
  • address (Field4) — VARCHAR
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • deleted_at (Field7) — DATETIME

Member_Auth (소셜 로그인)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • user_id (Key2) — Auto Increment — Foreign key → Member.id — NOT NULL
  • provider (Field) — VARCHAR
  • provider_id (Field2) — VARCHAR

Region (지역)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • name (Field) — VARCHAR

Store (가게)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (가계 이름) — VARCHAR
  • regionId (Key2) — BIGINT — Foreign key → Region.id — NOT NULL
  • categoryId (Key3) — BIGINT — Foreign key → food_category.id — NOT NULL

food_category (음식 종류)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • name (음식 이름) — VARCHAR

member_mission (사용자 미션)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • userId (Key2) — BIGINT — Foreign key → Member.id — NOT NULL
  • missionId (Key3) — BIGINT — Foreign key → mission.id — NOT NULL
  • status (미션 상태) — VARCHAR

mission (미션)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • title (미션 제목) — VARCHAR
  • content (미션 내용) — VARCHAR

store_mission (가게 미션)

  • id (Key) — Auto Increment — Primary key — NOT NULL
  • id (Key3) — BIGINT — Foreign key → mission.id — NOT NULL
  • id (Key2) — BIGINT — Foreign key → Store.id — NOT NULL