matchday

Tables (12)

award (Untitled2)

  • award_id (Key) — Long — Primary key — NOT NULL
  • club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • title (Field) — String — NOT NULL
  • priority (Field2) — int — NOT NULL
  • img_path (Field3) — String

club (Untitled4)

  • club_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String — NOT NULL
  • explanation (Field2) — String — NOT NULL
  • introduction (Field3) — String
  • category (Field4) — Enum — NOT NULL
  • main_event (Field5) — String
  • age_range (Field6) — String
  • club_password (Field7) — String
  • profile_img_path (Field8) — String
  • main_uniform_color (Field9) — String
  • sub_uniform_color (Field10) — String
  • member_count (Field11) — Int — NOT NULL
  • schedule_count (Field12) — Int — NOT NULL
  • match_count (Field13) — Int — NOT NULL

comment (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key3) — Long — Foreign key → user.user_id — NOT NULL
  • schedule_id (Key2) — Long — Foreign key → schedule.schedule_id — NOT NULL
  • contents (Field) — String — NOT NULL

match (Untitled10)

  • match_id (Key) — Long — Primary key — NOT NULL
  • home_club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • away_club_id (Key3) — Long — Foreign key → club.club_id — NOT NULL
  • schedule_id (Key4) — Long — Foreign key → schedule.schedule_id — NOT NULL
  • home_score (Field) — int — NOT NULL
  • away_score (Field2) — int — NOT NULL
  • name (Field3) — String — NOT NULL
  • event (Field4) — String — NOT NULL
  • match_size (Field5) — String — NOT NULL
  • fee (Field6) — int
  • bank (Field7) — String
  • account (Field8) — String
  • min_participants (Field9) — int — NOT NULL
  • match_status (Field10) — Enum — NOT NULL
  • note (Field11) — String
  • gender (Field12) — Enum — NOT NULL
  • is_ball (Field13) — Boolean — NOT NULL
  • match_half (Field14) — enum — NOT NULL

match_application(?) (Untitled12)

  • id (Key) — Long — Primary key — NOT NULL
  • club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • schedule_id (Key3) — Long — Foreign key → schedule.schedule_id — NOT NULL
  • match_id (Key4) — Long — Foreign key → match.match_id — NOT NULL
  • note (Field) — String
  • is_ball (Field2) — Boolean

match_user (Untitled11)

  • id (Key) — Long — Primary key — NOT NULL
  • club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • user_id (Key3) — Long — Foreign key → user.user_id — NOT NULL
  • match_id (Key4) — Long — Foreign key → match.match_id — NOT NULL
  • score (Field) — Int — NOT NULL

notice (Untitled8)

  • notice_id (Key) — Long — Primary key — NOT NULL
  • club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • title (Field) — String — NOT NULL
  • content (Field2) — String — NOT NULL

notifications(?) (Untitled5)

  • notification_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.user_id — NOT NULL
  • title (Field) — String
  • category (Field2) — String
  • is_read (Field3) — Boolean

schedule (Untitled3)

  • schedule_id (Key) — Long — Primary key — NOT NULL
  • club_id (Key2) — Long — Foreign key → club.club_id — NOT NULL
  • title (Field) — String — NOT NULL
  • location (Field2) — String — NOT NULL
  • start_time (Field3) — LocalDateTime
  • end_time (Field4) — LocalDateTime
  • min_people (Field5) — int — NOT NULL
  • category (Field6) — String — NOT NULL
  • note (Field7) — String — NOT NULL
  • attend (Field8) — int — NOT NULL
  • non_attend (Field9) — int — NOT NULL
  • is_close (Field10) — Boolean — NOT NULL

schedule_vote (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.user_id — NOT NULL
  • schedule_id (Key3) — Long — Foreign key → schedule.schedule_id — NOT NULL
  • attendance (Field) — Boolean — NOT NULL

user (Untitled)

  • user_id (Key) — Long — Primary key — NOT NULL
  • email (Field10) — String — NOT NULL
  • name (Field3) — String — NOT NULL
  • birthday (Field) — String
  • gender (Field2) — Enum — NOT NULL
  • phone_number (Field4) — String — NOT NULL
  • img_path (Field14) — String
  • role (Field12) — Enum — NOT NULL
  • height (Field5) — Float — NOT NULL
  • weight (Field6) — Float — NOT NULL
  • main_foot (Field7) — Boolean — NOT NULL
  • main_position (Field8) — Enum — NOT NULL
  • sub_position (Field15) — String
  • created_at (Field9) — LocalDateTime — NOT NULL
  • notification_agree (Field11) — Boolean — NOT NULL
  • fcm_token (Field17) — String
  • activityarea (Field16) — Enum — NOT NULL

user_club (Untitled6)

  • id (Key3) — Long — Primary key — NOT NULL
  • club_id (Key) — Long — Foreign key → club.club_id — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.user_id — NOT NULL
  • position (Field) — String
  • join_date (Field2) — LocalDate
  • schedule_count (Field3) — Int
  • match_count (Field4) — Int
  • role (Field5) — Enum
  • back_number (Field6) — int