Al ahly tripoli - Laravel Schema Designer

users

id increments
first_name string
last_name string
birthdate date
phone string
email string
address text
city_id integer
country_id integer
province_id integer
status enum
role enum
verified enum
language string
password text
image string
secret_token text
softDeletes softDeletes
timestamps timestamps
google_id text
facebook_id text

teams

id increments
name string
image string
country_id integer
city_id integer
coach_id integer
stadium string
goals_scored integer
goals_conceded integer
league_position integer
points integer
wins integer
draws integer
foundes date
losses integer
players string
softDeletes softDeletes
timestamps timestamps

team_members

id increments
user_id ^FK integer
team_id ^FK integer
type enum
matches_number integer
player_number integer
Biography text
height string
weight string
assists_number integer
goals_scored integer
wins integer
draws integer
total_passes integer
successful_passes string
passes_in_ninety_minutes integer
total_shots string
shots_on_target integer
offside_cases integer
errors integer
yellow_card integer
red_card integer
softDeletes softDeletes
timestamps timestamps

matches_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

matches

id increments
match_type_id ^FK integer
first_team_id ^FK integer
second_team_id ^FK integer
half enum
date datetime
group_id ^FK integer
home_and_away enum
softDeletes softDeletes
timestamps timestamps

groups

id increments
name string
timestamps timestamps
softDeletes softDeletes

medias

id increments
url_type enum
file_type enum
url text
team_id ^FK integer
timestamps timestamps
softDeletes softDeletes
match_id ^FK integer

news

id increments
title string
description string
team_id ^FK integer
image string
timestamps timestamps

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