the description for this gist

bojan_db_design.skema

[{"name":"Players","color":"Red","position":{"x":100,"y":100},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"name","type":"string","length":"100","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c41","order":0},{"name":"news","type":"string","length":"200","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c49","order":1},{"name":"id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c57","order":2},{"name":"minutes","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c74","order":3},{"name":"goals","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c82","order":4},{"name":"assists","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c90","order":5},{"name":"clean_sheets","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c98","order":6},{"name":"goals_conceded","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c106","order":7},{"name":"own_goals","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c114","order":8},{"name":"penalties_saved","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c150","order":9},{"name":"penalties_missed","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c158","order":10},{"name":"yellow_cards","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c166","order":11},{"name":"red_cards","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c174","order":12},{"name":"saves","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c182","order":13},{"name":"bonus","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c190","order":14},{"name":"team_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c201","order":15},{"name":"position","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c250","order":16}],"relation":[{"extramethods":"","foreignkeys":"","name":"team","relatedmodel":"Teams","relationtype":"belongsTo","usenamespace":""}],"seeding":[]},{"name":"Teams","color":"Green","position":{"x":574,"y":91},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c267","order":0},{"name":"name","type":"string","length":"50","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c275","order":1},{"name":"short_name","type":"string","length":"3","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c283","order":2}],"relation":[],"seeding":[[{"colid":"c267","content":"1"},{"colid":"c275","content":"Aston Villa"},{"colid":"c283","content":"AVL"}],[{"colid":"c267","content":"2"},{"colid":"c275","content":"Bournemouth"},{"colid":"c283","content":"BOU"}],[{"colid":"c267","content":"3"},{"colid":"c275","content":"Brighton"},{"colid":"c283","content":"BHA"}],[{"colid":"c267","content":"4"},{"colid":"c275","content":"Burnley"},{"colid":"c283","content":"BUR"}],[{"colid":"c267","content":"5"},{"colid":"c275","content":"Chelsea"},{"colid":"c283","content":"CHE"}],[{"colid":"c267","content":"6"},{"colid":"c275","content":"Crystal Palace"},{"colid":"c283","content":"CRY"}],[{"colid":"c267","content":"7"},{"colid":"c275","content":"Everton"},{"colid":"c283","content":"EVE"}],[{"colid":"c267","content":"8"},{"colid":"c275","content":"Leicester"},{"colid":"c283","content":"LEI"}],[{"colid":"c267","content":"9"},{"colid":"c275","content":"Liverpool"},{"colid":"c283","content":"LIV"}],[{"colid":"c267","content":"10"},{"colid":"c275","content":"Man City"},{"colid":"c283","content":"MCI"}],[{"colid":"c267","content":"11"},{"colid":"c275","content":"Man Utd"},{"colid":"c283","content":"MUN"}],[{"colid":"c267","content":"12"},{"colid":"c275","content":"Newcastle"},{"colid":"c283","content":"NEW"}],[{"colid":"c267","content":"13"},{"colid":"c275","content":"Norwich"},{"colid":"c283","content":"NOR"}],[{"colid":"c267","content":"14"},{"colid":"c275","content":"Sheffield Utd"},{"colid":"c283","content":"SHE"}],[{"colid":"c267","content":"15"},{"colid":"c275","content":"Southampton"},{"colid":"c283","content":"SOU"}],[{"colid":"c267","content":"16"},{"colid":"c275","content":"Spurs"},{"colid":"c283","content":"TOT"}],[{"colid":"c267","content":"17"},{"colid":"c275","content":"Watford"},{"colid":"c283","content":"WAT"}],[{"colid":"c267","content":"18"},{"colid":"c275","content":"West Ham"},{"colid":"c283","content":"WHU"}],[{"colid":"c267","content":"19"},{"colid":"c275","content":"Wolves"},{"colid":"c283","content":"WOL"}]]},{"name":"Gameweeks","color":"Blue","position":{"x":524,"y":549},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c300","order":0},{"name":"name","type":"string","length":"12","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c308","order":1},{"name":"deadline","type":"datetime","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c316","order":2},{"name":"active","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c432","order":3}],"relation":[],"seeding":[]},{"name":"Users","color":"Yellow","position":{"x":933,"y":122},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c345","order":0},{"name":"team_name","type":"string","length":"50","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c541","order":1}],"relation":[],"seeding":[]},{"name":"Selections","color":"Grey","position":{"x":1331,"y":440},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c368","order":0},{"name":"user_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c376","order":1},{"name":"player_ids","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c384","order":2},{"name":"gameweek_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c392","order":3}],"relation":[{"extramethods":"","foreignkeys":"user_id","name":"user","relatedmodel":"Users","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"gameweek_id","name":"gameweek","relatedmodel":"Gameweeks","relationtype":"hasOne","usenamespace":""}],"seeding":[]},{"name":"PlayerGameweeks","color":"Green","position":{"x":296,"y":796},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c565","order":0},{"name":"player_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c573","order":1},{"name":"gameweek_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c581","order":2},{"name":"points","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c589","order":3}],"relation":[{"extramethods":"","foreignkeys":"player_id","name":"player","relatedmodel":"Players","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"gameweek_id","name":"gameweek","relatedmodel":"Gameweeks","relationtype":"hasOne","usenamespace":""}],"seeding":[]},{"name":"Fixtures","color":"Red","position":{"x":941,"y":707},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c354","order":0},{"name":"gameweek_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c362","order":1},{"name":"home_team_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c373","order":2},{"name":"away_team_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c381","order":3},{"name":"kickoff","type":"datetime","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c389","order":4}],"relation":[{"extramethods":"","foreignkeys":"gameweek_id","name":"gameweek","relatedmodel":"Gameweeks","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"home_team_id","name":"home_team","relatedmodel":"Teams","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"away_team_id","name":"away_team","relatedmodel":"Teams","relationtype":"hasOne","usenamespace":""}],"seeding":[]}]

laravel-artisan-generate

php artisan generate:migration create_players_table --fields="name:string(100), news:string(200), id:integer, minutes:integer, goals:integer, assists:integer, clean_sheets:integer, goals_conceded:integer, own_goals:integer, penalties_saved:integer, penalties_missed:integer, yellow_cards:integer, red_cards:integer, saves:integer, bonus:integer, team_id:integer, position:integer, "

php artisan generate:migration create_teams_table --fields="id:integer, name:string(50), short_name:string(3), "

php artisan generate:migration create_gameweeks_table --fields="id:integer, name:string(12), deadline, active, "

php artisan generate:migration create_users_table --fields="id:increments, team_name:string(50), "

php artisan generate:migration create_selections_table --fields="id:increments, user_id:integer, player_ids:string, gameweek_id:integer, "

php artisan generate:migration create_playergameweeks_table --fields="id:increments, player_id:integer, gameweek_id:integer, points:integer, "

php artisan generate:migration create_fixtures_table --fields="id:integer, gameweek_id:integer, home_team_id:integer, away_team_id:integer, kickoff, "