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