해커톤
테이블 (21)
auth_refresh_tokens
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- refresh_token — VARCHAR(500) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- revoked_at — DATETIME
hackathon_eval_rules
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- metric_name — VARCHAR(100)
- description — TEXT
- max_runtime_sec — INT
- max_submissions_per_day — INT
- score_source — VARCHAR(30)
hackathon_links
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- link_type — VARCHAR(30) — NOT NULL
- label — VARCHAR(100) — NOT NULL
- url — VARCHAR(500) — NOT NULL
hackathon_milestones
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- milestone_at — DATETIME — NOT NULL
- sort_order — INT — NOT NULL
hackathon_notices
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- content — TEXT — NOT NULL
- sort_order — INT — NOT NULL
hackathon_prizes
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- place_label — VARCHAR(50) — NOT NULL
- amount_krw — INT
- description — VARCHAR(255)
- sort_order — INT — NOT NULL
hackathon_registrations
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- registered_at — DATETIME — NOT NULL
- canceled_at — DATETIME
hackathon_score_breakdowns
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- score_key — VARCHAR(50) — NOT NULL
- label — VARCHAR(50) — NOT NULL
- weight_percent — DECIMAL(5,2)
- sort_order — INT — NOT NULL
hackathon_submission_rules
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- artifact_type — VARCHAR(30) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- label — VARCHAR(100) — NOT NULL
- description — TEXT
- sort_order — INT — NOT NULL
hackathon_tags
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- tag_name — VARCHAR(100) — NOT NULL
hackathons
- id — BIGINT
- slug — VARCHAR(120) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- summary — TEXT
- description — TEXT
- organizer_name — VARCHAR(255)
- thumbnail_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- visibility — VARCHAR(20) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- start_at — DATETIME
- end_at — DATETIME
- submission_deadline_at — DATETIME
- camp_enabled — BOOLEAN — NOT NULL
- allow_solo — BOOLEAN — NOT NULL
- max_team_size — INT — NOT NULL
- score_type — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
leaderboard_entries
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- latest_submission_id — BIGINT — 외래 키 → submissions.id
- rank_no — INT
- score — DECIMAL(10,2)
- score_label — VARCHAR(100)
- participant_score — DECIMAL(10,2)
- judge_score — DECIMAL(10,2)
- is_visible — BOOLEAN — NOT NULL
- evaluated_at — DATETIME
- updated_at — DATETIME — NOT NULL
submission_items
- id — BIGINT
- submission_id — BIGINT — 외래 키 → submissions.id — NOT NULL
- rule_id — BIGINT — 외래 키 → hackathon_submission_rules.id — NOT NULL
- value_text — TEXT
- value_url — VARCHAR(1000)
- file_name — VARCHAR(255)
- is_final — BOOLEAN — NOT NULL
submissions
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id — NOT NULL
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- submitter_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- revision_no — INT — NOT NULL
- submitted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
team_join_applications
- id — BIGINT
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- applicant_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- message — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- processed_at — DATETIME
- processed_by_user_id — BIGINT — 외래 키 → users.id
team_members
- id — BIGINT
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- role_type — VARCHAR(20) — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
team_positions
- id — BIGINT
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- position_name — VARCHAR(100) — NOT NULL
- required_count — INT — NOT NULL
team_private_infos
- id — BIGINT
- team_id — BIGINT — 외래 키 → teams.id — NOT NULL
- contact_type — VARCHAR(30)
- contact_value — VARCHAR(500)
- internal_memo — TEXT
- edit_token — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
teams
- id — BIGINT
- hackathon_id — BIGINT — 외래 키 → hackathons.id
- owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- intro — TEXT
- status — VARCHAR(20) — NOT NULL
- is_open — BOOLEAN — NOT NULL
- current_member_count — INT — NOT NULL
- max_member_count — INT — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_point_histories
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- hackathon_id — BIGINT — 외래 키 → hackathons.id
- point_delta — INT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME