test

Tables (11)

Untitled (group)

  • Key (id) — int — Primary key — NOT NULL
  • name
  • Field (cnt)

Untitled (groupUser)

  • Key (userid) — int — Foreign key → user.Key — NOT NULL
  • Key (grupid) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date
  • Field

bet_rules

  • id — BIGINT — Primary key — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenges.id — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT

certifications

  • id — BIGINT — Primary key — NOT NULL
  • round_id — BIGINT — Foreign key → rounds.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(255)
  • certified_at — DATETIME
  • status — VARCHAR(20)

challenge_members

  • id — BIGINT — Primary key — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenges.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20)
  • joined_at — DATETIME

challenges

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • challenge_type — VARCHAR(30)
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(20)
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME

rounds

  • id — BIGINT — Primary key — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenges.id — NOT NULL
  • round_no — INT
  • start_date — DATE
  • end_date — DATE

savings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenges.id
  • amount — INT — NOT NULL
  • saving_type — VARCHAR(30)
  • created_at — DATETIME

settlements

  • id — BIGINT — Primary key — NOT NULL
  • round_id — BIGINT — Foreign key → rounds.id — NOT NULL
  • payer_id — BIGINT — Foreign key → users.id — NOT NULL
  • receiver_id — BIGINT — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20)

user

  • Key (id) — int — Primary key — NOT NULL
  • Field (name)
  • Field (age)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME