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