home_red_card The number of red int 1 to 15 cards given to the home team away_red_card The number of int 1 to 15 red cards given to the away team home_yellow_card The total number of int 1 to 15 yellow cards given to the home team away_yellow_card The total number of int 1 to 15 yellow cards given to the away team scrums_contested Value of 1 indicates tinyint 0 or 1 the scrums were contested scrums_contested Value of 1 indicates tinyint 0 or 1 the scrums were contested uncontested_request Which team varchar(50) Carlow, CYM, requested the Tallaght scrums to be uncontested User Database user_database This holds the individual user records and all associated data Attribute Description Type Examples of Values f_name The first name varchar(255) Amy, Laura, Dave l_name The users last varchar(255) Stafford, Conlon, name McGrath email The users email varchar(255) address club_name The name of the varchar(255) Athy RFC, Carlow RFC, club the user is Malahide RFC working with user_role The role of the user varchar(255) Head Coach, Backs within their club Coach, Assistant Coach user_password The user password varchar password123, abc123 for their accound Player Database player_database This table holds the individual player records and all associated data
home_red_card The number of red cards given to the home team int 1 to 15 away_red_card The number of red cards given to the away team int 1 to 15 home_yellow_card The total number of yellow cards given to the home team int 1 to 15 away_yellow_card The total number of yellow cards given to the away team int 1 to 15 scrums_contested Value of 1 indicates the scrums were contested tinyint 0 or 1 scrums_contested Value of 1 indicates the scrums were contested tinyint 0 or 1 uncontested_request Which team requested the scrums to be uncontested varchar(50) Carlow, CYM, Tallaght User Database user_database This holds the individual user records and all associated data Attribute Description Type Examples of Values f_name The first name varchar(255) Amy, Laura, Dave l_name The users last name varchar(255) Stafford, Conlon, McGrath email The users email address varchar(255) club_name The name of the club the user is working with varchar(255) Athy RFC, Carlow RFC, Malahide RFC user_role The role of the user within their club varchar(255) Head Coach, Backs Coach, Assistant Coach user_password The user password for their accound varchar password123, abc123 Player Database player_database This table holds the individual player records and all associated data