ch1

Tables (7)

Mission_Assignments

  • assignment_id — NOT — Primary key — NOT NULL
  • user_id — NOT — NOT NULL
  • mission_id — NOT — NOT NULL
  • status — NULL
  • assigned_at — NULL
  • completed_at — NULL
  • user_id2 — NOT — NOT NULL
  • mission_id2 — NOT — NOT NULL

Missions

  • mission_id — NOT — Primary key — NOT NULL
  • store_id — NOT — NOT NULL
  • mission_title — NOT — NOT NULL
  • mission_desc — NULL
  • reward_point — NULL
  • store_id2 — NOT — NOT NULL

Point_Log

  • log_id — NOT — Primary key — NOT NULL
  • user_id — NOT — NOT NULL
  • points — NOT — NOT NULL
  • reason — NOT — NOT NULL
  • created_at — NOT — NOT NULL
  • user_id2 — NOT — NOT NULL

Regions

  • region_id — NOT — Primary key — NOT NULL
  • region_name — NULL — NOT NULL

Reviews

  • review_id — NOT — Primary key — NOT NULL
  • assignment_id — NOT — NOT NULL
  • rating — NULL
  • comment — NULL — EX
  • created_at — NULL
  • assignment_id2 — NOT — NOT NULL

Stores

  • store_id — NOT — Primary key — NOT NULL
  • region_id — NOT — NOT NULL
  • store_name — NOT — NOT NULL
  • address — NULL
  • region_id2 — NOT — NOT NULL

Users

  • user_id — NOT — Primary key — NOT NULL
  • username — NOT — NOT NULL
  • password — NOT — NOT NULL
  • email — NULL
  • preference — NULL
  • points — NULL
  • created_at — NULL
  • phone_number — NULL
  • phone_verified — NOT — NOT NULL