ltfc_alumni - Laravel Schema Designer

students

id increments
sid string (9)
name string
cname string
gender string (6)
timestamps timestamps

schoollevels

id increments
year smallInteger
level string (2)
class string (5)
sid ^FK integer
timestamps timestamps

sports

id increments
name string
cname string
timestamps timestamps
othername string
category string

athlete_records

id increments
year smallInteger
student_id ^FK integer
sport_id ^FK integer
organisation_id ^FK integer
title string
details string
timestamps timestamps

sport_organisations

id increments
name string
cname string
details string
timestamps timestamps

graduate_logs

id increments
year smallInteger
event string
details string
timestamps timestamps

contacts

id increments
phone string
whatsapp string
timestamps timestamps

graduates

id increments
sid ^FK integer
year smallInteger
timestamps timestamps

sport_achievements

id increments
student_id ^FK integer
event_id ^FK integer
grade string
position integer
achievement_name string
achievement_cname string
achievement_level string
timestamps timestamps

sport_games

id increments
name string
cname string
othername string
grade string
timestamps timestamps

sport_competitions

id increments
year smallInteger
name string
cname string
game_id ^FK integer
timestamps timestamps
location string
details string

sport_events

id increments
timestamps timestamps
event_name string
event_cname string
competition_id ^FK integer
type string
sport_id ^FK integer

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