2
Tables (7)
Untitled (USER)
- Key (user_id) — Long — Primary key — NOT NULL
- Field (username) — VARCHAR
- Field (password) — VARCHAR
- Field (email) — VARCHAR
- Field (total_reward) — Int
Untitled (CHALLENGE)
- Key (challenge_id) — Long — Primary key — NOT NULL
- Field (challenge_name) — VARCHAR
- Field (start_date) — timestamp
- Field (end_date) — timestamp
- Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL
Untitled (REWARD)
- Key (reward_id) — LONG — Primary key — NOT NULL
- Field (reward_type) — VARCHAR
- Field (reward_value) — INT
- Field (received_at) — timestamp
- Key (receipt_id) — LONG — Foreign key → Untitled2.Key — NOT NULL
- Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL
Untitled (C_DAILY)
- Key (c_daily_id) — Long — Primary key — NOT NULL
- Field (status_date) — Date
- Field (is_success) — boolean
- Key (challenge_id) — Long — Foreign key → Untitled.Key — NOT NULL
Untitled (R_DAILY)
- Key (r_daily_id) — Long — Primary key — NOT NULL
- Field (status_date) — Date
- Field (is_success) — boolean
- Key (receipt_challenge_id) — Long — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (RECEIPT)
- Key (receipt_id) — LONG — Primary key — NOT NULL
- Field (verified) — boolean
- Field (healthy) — boolean
- Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Key (receipt_challenge_id) — Long — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (RECEIPT_CHALLENGE)
- Key (receipt_challenge_id) — Long — Primary key — NOT NULL
- Field (r_challenge_name) — VARCHAR
- Field (start_date) — Timestamp
- Field (end_date) — Timestamp
- Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL