ㅜ

Tables (25)

chat_messages

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_participants

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • joined_at — DATETIME — NOT NULL

criteria

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • max_score — FLOAT — NOT NULL

hackathon_judges

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • assigned_at — DATETIME — NOT NULL

hackathon_links

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • link_type — VARCHAR(255)
  • label — VARCHAR(255)
  • url — VARCHAR(255) — NOT NULL

hackathon_notices

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • content — TEXT — NOT NULL

hackathon_registrations

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • team_id — BIGINT — NOT NULL
  • registered_at — DATETIME — NOT NULL

hackathon_submission_rules

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • artifact_type — VARCHAR(255) — NOT NULL
  • required — TINYINT(1) — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • description — TEXT
  • sort_order — INT — NOT NULL

hackathon_tags

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • tag_id — BIGINT — NOT NULL

hackathons

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • summary — VARCHAR(255)
  • description — TEXT
  • thumbnail_url — VARCHAR(255)
  • organizer — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • score_type — VARCHAR(20) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • registration_start_date — DATETIME — NOT NULL
  • registration_end_date — DATETIME — NOT NULL
  • submission_deadline_at — DATETIME
  • closed_at — DATETIME
  • max_team_size — INT — NOT NULL
  • max_participants — INT
  • camp_enabled — TINYINT(1) — NOT NULL
  • allow_solo — TINYINT(1) — NOT NULL
  • deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

judge_evaluations

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • team_id — BIGINT — NOT NULL
  • judge_user_id — BIGINT — NOT NULL
  • total_score — FLOAT — NOT NULL
  • scores_json — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

milestones

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • date — DATETIME — NOT NULL

prizes

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • ranking — INT — NOT NULL
  • amount — INT — NOT NULL
  • description — VARCHAR(255)

submission_items

  • id — BIGINT
  • submission_id — BIGINT — Foreign key → submissions.id — NOT NULL
  • rule_id — BIGINT
  • value_text — TEXT
  • value_url — VARCHAR(1000)
  • file_name — VARCHAR(500)
  • original_file_name — VARCHAR(255)
  • file_extension — VARCHAR(20)
  • file_size — BIGINT
  • is_final — TINYINT(1) — NOT NULL

submissions

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • team_id — BIGINT — NOT NULL
  • submitter_user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • revision_no — INT — NOT NULL
  • is_latest — TINYINT(1) — NOT NULL
  • submitted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tags

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL

team_applications

  • id — BIGINT
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • message — TEXT
  • position — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • processed_by_user_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • processed_at — DATETIME
  • deleted_at — DATETIME

team_members

  • id — BIGINT
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role_type — VARCHAR(20) — NOT NULL
  • position — VARCHAR(100)
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME

team_positions

  • id — BIGINT
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • position_name — VARCHAR(100) — NOT NULL
  • required_count — INT — NOT NULL

team_private_infos

  • id — BIGINT
  • team_id — BIGINT — Foreign key → 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 — Foreign key → hackathons.id
  • owner_user_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • is_open — TINYINT(1) — NOT NULL
  • is_public — TINYINT(1) — NOT NULL
  • current_member_count — INT — NOT NULL
  • max_member_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

user_tags

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • tag_id — BIGINT — NOT NULL

user_xp_history

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • hackathon_id — BIGINT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • amount — INT — NOT NULL
  • earned_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • role — VARCHAR(20) — NOT NULL
  • account_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

votes

  • id — BIGINT
  • hackathon_id — BIGINT — Foreign key → hackathons.id — NOT NULL
  • voter_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • voted_at — DATETIME — NOT NULL