000
Tables (11)
entity
- entity_id — bigint
- entity_type — enum — NOT NULL
- user_id — bigint
- team_id — bigint
free_board
- article_id — bigint
- cate_id — bigint — NOT NULL
- author_id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- views — bigint — NOT NULL
free_board_category
- cate_id — bigint
- cate_name — varchar(50) — NOT NULL
free_board_comment
- comment_id — bigint
- article_id — bigint — NOT NULL
- author_id — bigint — NOT NULL
- parent_id — bigint
- content — text — NOT NULL
- created_at — datetime
- is_deleted — boolean
game_match
- match_id — bigint
- stadium_id — bigint — NOT NULL
- renter_entity_id — bigint
- match_type — enum — NOT NULL
- match_datetime — datetime — NOT NULL
- gender — enum — NOT NULL
- min_grade — int — NOT NULL
- max_grade — int — NOT NULL
- status — tinyint — NOT NULL
match_individual_players
- match_id — bigint — Primary key — NOT NULL
- user_id — bigint — Primary key — NOT NULL
match_team_participants
- match_id — bigint — Primary key — NOT NULL
- team_id — bigint — Primary key — NOT NULL
stadium
- stadium_id — bigint
- region — varchar(100) — NOT NULL
- location — varchar(300) — NOT NULL
- start_hour — time — NOT NULL
- end_hour — time — NOT NULL
- introduction — text
team
- team_id — bigint
- team_name — varchar(100) — NOT NULL
- leader_id — bigint — NOT NULL
- gender — enum
- min_grade — int
- max_grade — int
- region — varchar(100)
- introduction — text
team_member
- team_id — bigint — Primary key — NOT NULL
- user_id — bigint — Primary key — NOT NULL
- joined_at — datetime
user
- user_id — bigint
- email — varchar(100) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(30) — NOT NULL
- created_at — datetime
- gender — enum — NOT NULL
- preferred_position — varchar(30)
- introduction — text
- point — bigint — NOT NULL
- grade — int — NOT NULL