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