UMC_workbook_ERD

Tables (5)

mission

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → store.id — NOT NULL
  • id (id22) — BIGINT — Foreign key → store.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • point_value — INT — NOT NULL
  • store_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

mission_completion

  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → mission.id — NOT NULL
  • id (id22) — BIGINT — Foreign key → mission.id — NOT NULL
  • id (id222) — BIGINT — Foreign key → mission.id — NOT NULL
  • id — BIGINT
  • user_id — BIGINT
  • mission_id — BIGINT
  • completed_at — DATETIME(6)
  • review — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • completed_status — VARCHAR(15)

region

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

store

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → region.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • description — TEXT
  • region_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • status — VARCHAR(15)
  • inactive_date — DATETIME(6)