Alpine Football - Laravel Schema Designer

users

players

id increments
first_name_th string
last_name_th string
first_name_en string
last_name_en string
id_card string
gender enum
birthdate date
nick_name string
religion string
race string
nationality string
phone string
email string
club string
address string
provice integer
district integer
subdistrict integer
zipcode integer
position enum
number string
height integer
weight integer
dominant_foot enum
file_photo string
timestamps timestamps
softDeletes softDeletes

player_owners

id increments
user_id ^FK integer
player_id ^FK integer
start_date date
finish_date date
timestamps timestamps
softDeletes softDeletes

course_coaches

id increments
name string
place string
start_date date
finish_date date
start_time time
finish_time time
register_date date
amount integer
detail text
qualification text
timestamps timestamps
softDeletes softDeletes

course_coach_register

id increments
course_id ^FK integer
user_id ^FK integer
register_date date
register_status integer
timestamps timestamps
softDeletes softDeletes

course_players

id increments
name string
place string
start_date date
finish_date date
start_time time
finish_time time
detail text
timestamps timestamps
softDeletes softDeletes

test_topic

id increments
course_id ^FK integer
name string
score integer
timestamps timestamps
softDeletes softDeletes

course_player_register

id increments
timestamps timestamps
softDeletes softDeletes
course_id ^FK integer
player_id ^FK integer

player_testing

id increments
course_id ^FK integer
player_id ^FK integer
test_id ^FK integer
test_date date
score integer
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01