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