im curius about how the insert data would look like im trying to make a sql database, but im actually uncertain about my insert data to be guided by$.$

CREATE TABLE gamers $($

gamer$\_$id MEDIUMINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

gamertag VARCHAR$(30)$ NOT NULL,

pass CHAR$(128)$ NOT NULL,

first$\_$name VARCHAR$(20)$ NOT NULL,

last$\_$name VARCHAR$(40)$ NOT NULL,

email VARCHAR$(60)$ NOT NULL,

PRIMARY KEY $($user$\_$id$),$

UNIQUE $($username$),$

UNIQUE $($email$),$

INDEX login $($pass$,$ email$)$

$)$ ENGINE $=$ INNODB;

CREATE TABLE towerdefence $($

Tower$\_$id MEDIUMINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

gamer$\_$id INT UNSIGNED NOT NULL,

gamertag VARCHAR$(30)$ NOT NULL,

playerlevel INT NOT NULL,

wave INT NOT NULL,

goldearned INT NOT NULL,

totalkills DOUBLE NOT NULL,

FOREIGN KEY $($from$\_$gamer$\_$id$)$ REFERENCES gamers $($gamer$\_$id$)$

ON DELETE NO ACTION ON UPDATE NO ACTION,

PRIMARY KEY $($Tower$\_$id$),$

$)$ ENGINE $=$ INNODB;

CREATE TABLE racingracer $($

racing$\_$id MEDIUMINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

gamer$\_$id INT UNSIGNED NOT NULL,

gamertag VARCHAR$(30)$ NOT NULL,

playerlevel INT NOT NULL,

goldearned INT NOT NULL,

race$1$ INT NOT NULL,

race$2$ INT NOT NULL,

race$3$ INT NOT NULL,

FOREIGN KEY $($from$\_$gamer$\_$id$)$ REFERENCES gamers $($gamer$\_$id$)$

ON DELETE NO ACTION ON UPDATE NO ACTION,

PRIMARY KEY $($racing$\_$id$),$

$)$ ENGINE $=$ INNODB;

CREATE TABLE shooterfps $($

shooter$\_$id MEDIUMINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

gamer$\_$id INT UNSIGNED NOT NULL,

gamertag VARCHAR$(30)$ NOT NULL,

playerlevel INT NOT NULL,

bulletshot INT NOT NULL,

goldearned INT NOT NULL,

totalkills DOUBLE NOT NULL,

bestkillgame INT NOT NULL,

FOREIGN KEY $($from$\_$gamer$\_$id$)$ REFERENCES gamers $($gamer$\_$id$)$

ON DELETE NO ACTION ON UPDATE NO ACTION,

PRIMARY KEY $($shooter$\_$id$),$

$)$ ENGINE $=$ INNODB;