해커톤

테이블 (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