test

Tables (5)

missions

  • mission_id — SERIAL
  • mission_name — VARCHAR(100) — NOT NULL
  • region_id — INT — NOT NULL
  • shop_id — INT — NOT NULL
  • status — VARCHAR(20)
  • completed)) — DEFAULT
  • user_id — INT — NOT NULL
  • points_awarded — INT
  • completion_date — TIMESTAMP

regions

  • region_id — SERIAL
  • region_name — VARCHAR(100) — NOT NULL

shops

  • shop_id — SERIAL
  • shop_name — VARCHAR(100) — NOT NULL
  • region_id — INT — NOT NULL

user_missions

  • user_id — INT — Primary key — NOT NULL
  • mission_id — INT — Primary key — NOT NULL

users

  • user_id — SERIAL
  • id — VARCHAR(50) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • date_joined — TIMESTAMP