hackathon
Tables (5)
Untitled (check)
- Key (id) — INT — Primary key — NOT NULL
- Field (check_date) — DATETIME
- Field (content) — VARCHAR(255)
- id (user_id) — INT — Foreign key → user.id — NOT NULL
Untitled (honor_rank)
- Key (id) — INT — Primary key — NOT NULL
- id (first_user_id) — INT — Foreign key → user.id — NOT NULL
- id (second_user_id) — INT — Foreign key → user.id — NOT NULL
- id (third_user_id) — INT — Foreign key → user.id — NOT NULL
- Field (week) — INT
- Field (month) — INT
Untitled (user_rival)
- id (to_user) — INT — Foreign key → user.id — NOT NULL
- Field (from_user) — INT
Untitled (prev_first)
- id (prev_id) — INT — Foreign key → user.id — NOT NULL
user
- id — INT — Primary key — NOT NULL
- Field (nickname) — VARCHAR(255)
- Field (GitHub_email) — VARCHAR(255)
- Field (profile_image_url) — VARCHAR(255)
- Field (point) — INT
- Field (commit_streak) — INT
- Field (github_url) — VARCHAR(255)