ㅜ
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