umc chapter 5

Tables (9)

follows

  • follower_user_id — INT — NOT NULL
  • followed_user_id — INT — NOT NULL
  • created_at — TIMESTAMP

missions

  • mission_id — INT — NOT NULL
  • store_id — INT — NOT NULL
  • mission_content — VARCHAR(255)
  • points_awarded — INT
  • created_at — TIMESTAMP

posts

  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

regions

  • region_id — INT — NOT NULL
  • region_name — VARCHAR(255) — NOT NULL

reviews

  • review_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • store_id — INT — NOT NULL
  • rating — INT
  • content — TEXT
  • created_at — TIMESTAMP

stores

  • store_id — INT — NOT NULL
  • region_id — INT — NOT NULL
  • store_name — VARCHAR(255) — NOT NULL
  • manager_number — VARCHAR(255)
  • address — VARCHAR(255)
  • created_at — TIMESTAMP

user_mission_completions

  • completion_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • mission_id — INT — NOT NULL
  • completed_at — TIMESTAMP

user_region_bonus

  • bonus_id — INT — NOT NULL
  • region_id — INT — NOT NULL
  • awarded_at — TIMESTAMP

users

  • user_id — INT — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255)
  • created_at — TIMESTAMP