PlayMaker
Tables (30)
ALARM
- alarm_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- content — VARCHAR(255)
- url — VARCHAR(255)
- toName — VARCHAR(255)
- notisficationType — VARCHAR(255)
COMETITION
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- uesYn — VARCHAR(255)
COMMENTS
- comment_id — VARCHAR(255) — Primary key — NOT NULL
- board_id — VARCHAR(255) — Foreign key → VIEWRECORDS.board_id — NOT NULL
- team_id — bigint — Foreign key → VIEWRECORDS.team_id — NOT NULL
- member_id — bigint — Foreign key → VIEWRECORDS.member_id — NOT NULL
- author — VARCHAR(255)
- content — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- deleteYn — VARCHAR(255)
COMPETITION
- competition_id — VARCHAR(255) — Primary key — NOT NULL
- competiton_name — VARCHAR(255)
- subname — VARCHAR(255)
- poster — VARCHAR(255)
- Field3 — VARCHAR(255)
- registrationDuration — VARCHAR(255)
- totalTeams — VARCHAR(255)
- candidateFee — VARCHAR(255)
- item — VARCHAR(255)
- useYn — VARCHAR(255)
- timePoint — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
- delete_reason — VARCHAR(255)
- selectedCount — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
COMPETITIONCANDIDATELIST
- competition_id — VARCHAR(255) — Foreign key → COMETITION.competition_id — NOT NULL
- team_id — bigint — Foreign key → COMETITION.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
COMPETITIONLEAGUE
- Key — VARCHAR(255) — Primary key — NOT NULL
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- group — VARCHAR(255)
- teamnum — VARCHAR(255)
COMPETITIONMATCH
- match_id — VARCHAR(255) — Primary key — NOT NULL
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id — NOT NULL
- hometeam — VARCHAR(255)
- awayteam — VARCHAR(255)
- homeScore — VARCHAR(255)
- awayScore — VARCHAR(255)
- dateTime — VARCHAR(255)
- Field4 — VARCHAR(255)
- homeVote — VARCHAR(255)
- awayVote — VARCHAR(255)
- Field — VARCHAR(255)
COMPETITIONTOUR
- Key — VARCHAR(255) — Primary key — NOT NULL
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- degree — VARCHAR(255)
- sequence — VARCHAR(255)
- group — VARCHAR(255)
COMPETITIONTOURTEMP
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
MATCHPARTICIPATION
- participation_id — VARCHAR(255) — Primary key — NOT NULL
- match_id — VARCHAR(255) — NOT NULL
- member_id — bigint — NOT NULL
- team_id — bigint — NOT NULL
- playtime_minutes — INT
- starting_lineup — BOOLEAN
- substitution_in — BOOLEAN
- substitution_out — BOOLEAN
- performance_rating — DECIMAL(3,1)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
MEMBER*
- member_id — bigint — Primary key — NOT NULL
- user_name — VARCHAR(255)
- nickname — VARCHAR(255)
- email — VARCHAR(255)
- contract — ENUM
- birth — ENUM
- sex — VARCHAR(255)
- profile_picture — VARCHAR(255)
- university — VARCHAR(255)
- self_intro — VARCHAR(255)
- activeArea — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
- member_type — ENUM
- isDelete — VARCHAR(255)
- pagePublicYn — VARCHAR(255)
- certificateYn — VARCHAR(255)
- emailCertificateYn — VARCHAR(255)
MEMBERSTATISTICS
- stat_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id
- season — VARCHAR(255)
- games_played — INT
- games_started — INT
- minutes_played — INT
- performance_avg — DECIMAL(3,1)
- goals_scored — INT
- assists — INT
- yellow_cards — INT
- red_cards — INT
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
MEMBERTEAMS
- team_id — bigint — Foreign key → TEAMROLE.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- auth — ENUM
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
TEAM*
- team_id — bigint — Primary key — NOT NULL
- team_name — VARCHAR(255)
- team_color — VARCHAR(255)
- item — ENUM
- create_dt — VARCHAR(255)
- active_area — VARCHAR(255)
- logo_url — VARCHAR(255)
- team_intro — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
- join_yn — VARCHAR(255)
- message — VARCHAR(255)
- isDelete — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
TEAMACTIVITYLOG
- log_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id
- activity_type — VARCHAR(255)
- description — VARCHAR(255)
- related_id — VARCHAR(255)
- inp_dthms — VARCHAR(255)
TEAMBOARD
- board_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- title — VARCHAR(255)
- author — VARCHAR(255)
- category — VARCHAR(255)
- content — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
- viewCount — VARCHAR(255)
- deleteYn — VARCHAR(255)
- priority — VARCHAR(255)
- start_date — VARCHAR(255)
- end_date — VARCHAR(255)
- vote_Yn — VARCHAR(255)
TEAMBOARDPICTURE
- board_picture_id — VARCHAR(255) — Primary key — NOT NULL
- board_id — VARCHAR(255) — Foreign key → TEAMBOARD.board_id — NOT NULL
- team_id — bigint — Foreign key → TEAMBOARD.team_id — NOT NULL
- file_path — VARCHAR(255)
- use_yn — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
TEAMCALENDAR
- calendar_id — bigint — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- date — VARCHAR(255)
- content — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_bthms — VARCHAR(255)
- locate — VARCHAR(255)
- Field — VARCHAR(255)
TEAMCATEGORY
- Key — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- category_nm — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
TEAMINVITATION
- invitation_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- inviter_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- invitee_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- status — VARCHAR(255)
- message — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
- expiry_date — VARCHAR(255)
TEAMJOINREQUEST
- request_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- status — VARCHAR(255)
- message — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
TEAMLIKE
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
TEAMROLE
- role_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Primary key — NOT NULL
- role_name — VARCHAR(255)
- description — VARCHAR(255)
- permission_level — INT
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
TEAMSTATISTICS
- stat_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- competition_id — VARCHAR(255) — Foreign key → COMPETITION.competition_id
- season — VARCHAR(255)
- games_played — INT
- wins — INT
- losses — INT
- ties — INT
- points_scored — INT
- points_conceded — INT
- ranking — INT
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
UNIVERSITY
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
Untitled
- vote_id — VARCHAR(255) — Primary key — NOT NULL
- board_id — VARCHAR(255) — Foreign key → TEAMBOARD.board_id — NOT NULL
- team_id — bigint — Foreign key → TEAMBOARD.team_id — NOT NULL
- member_id — VARCHAR(255)
- inp_dthms — VARCHAR(255)
- mdf_dthms — VARCHAR(255)
- maxCount — VARCHAR(255)
- endYn — VARCHAR(255)
- Field — VARCHAR(255)
Untitled2
VIDEO
- video_id — VARCHAR(255) — Primary key — NOT NULL
- team_id — bigint — Foreign key → TEAM*.team_id — NOT NULL
- Field9 — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
VIDEOCOMMENT
- Key — VARCHAR(255) — Primary key — NOT NULL
- video_id — VARCHAR(255) — Foreign key → VIDEO.video_id — NOT NULL
- team_id — bigint — Foreign key → VIDEO.team_id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
VIEWRECORDS
- board_id — VARCHAR(255) — Foreign key → TEAMBOARD.board_id — NOT NULL
- team_id — bigint — Foreign key → TEAMBOARD.team_id — NOT NULL
- member_id — bigint — Foreign key → MEMBER*.member_id — NOT NULL
- Field — VARCHAR(255)