exacutor - Laravel Schema Designer

students

student_id increments
first_name string (50)
last_name string (50)
batch_id integer
timestamps timestamps
softDeletes softDeletes

extra_curricular_activities

activity_id increments
type enum
sp_id ^FK integer
comp_id ^FK integer
clb_id ^FK integer
defined_effort integer
timestamps timestamps
softDeletes softDeletes

student_activity

stu_act_id increments
stu_id ^FK integer
act_id ^FK integer
role string
effort integer
joined date
is_validated boolean
timestamps timestamps
softDeletes softDeletes

supervisors

supervisor_id increments
first_name string (50)
last_name string (50)
field string (100)
timestamps timestamps
softDeletes softDeletes

student_login

stu_log_id increments
stu_id ^FK integer
username string (50)
password string (50)
timestamps timestamps
softDeletes softDeletes

supervisor_login

sup_log_id increments
sup_id ^FK integer
username string (50)
password string (50)
timestamps timestamps
softDeletes softDeletes

supervisor_activity

sup_act_id increments
sup_id ^FK integer
act_id ^FK integer
timestamps timestamps
softDeletes softDeletes

sports

sport_id increments
sport_name string (50)
team string (50)
logo binary
description text
timestamps timestamps
softDeletes softDeletes

clubs

club_id increments
club_name string (50)
logo binary
division string (50)
timestamps timestamps
softDeletes softDeletes

competitions

competition_id increments
competitiopn_name string (50)
logo binary
host string (60)
description text
timestamps timestamps
softDeletes softDeletes

achievements

ach_id increments
act_id ^FK integer
stu_id ^FK integer
position enum
description text
timestamps timestamps
softDeletes softDeletes

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