tr
Tables (6)
Competition
- id — INT — Primary key — NOT NULL
- host_id — INT — Foreign key → User.id — NOT NULL
- competition_title — VARCHAR(50)
- competition_content — TEXT
- event — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- qualification — TEXT
- prize — TEXT
- poster_path — TEXT
- pdf_path — TEXT
- recruit_period — VARCHAR(255)
- competition_period — VARCHAR(255)
- format — VARCHAR(255)
- scale — VARCHAR(255)
Player
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- team_id — INT — Foreign key → Team.id — NOT NULL
- nickname — VARCHAR(255)
- created_at — TIMESTAMP
- updaed_at — TIMESTAMP
- name — VARCHAR(255)
Team
- id — INT — Primary key — NOT NULL
- team_name — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- competition_id — INT
Team_Competition_History
- id — INT — Primary key — NOT NULL
- id2 — INT — Foreign key → Competition.host_id — NOT NULL
- competition_id — INT — Foreign key → Competition.id — NOT NULL
- team_id — INT — Foreign key → Team.id — NOT NULL
- grade — INT
- point — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Tournament_Node
- id — INT — Primary key — NOT NULL
- competition_id — INT — Foreign key → Competition.id — NOT NULL
- round — INT
- match_number — INT
- team1_id — INT
- team2_id — INT
- winner_id — INT
- is_finished — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255)
- emailVerified — BOOLEAN
- password — VARCHAR(255)
- name — VARCHAR(255)
- nickname — VARCHAR(255)
- birth — DATE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- discord_auth — VARCHAR(255)
- riot_auth — VARCHAR(255)
- school_auth — VARCHAR(255)
- played_competition — INT
- played_match — INT
- win — INT
- lose — INT