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