ㅎ

Tables (8)

food_category

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

member

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)

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
  • status — VARCHAR(30) — NOT NULL
  • accepted_at — DATETIME
  • completed_at — DATETIME

mission

  • id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — VARCHAR(500)

region

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

social_account

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL

store

  • id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → region.id — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)

store_food_category

  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • food_category_id — BIGINT — Foreign key → food_category.id — NOT NULL