agrs_students - Laravel Schema Designer

learners

id increments
address_id ^FK integer
living_with ^FK integer
religion ^FK integer
last_name string
first_name string
middle_name string
extension_name string
nickname string
sex string (1)
date_of_birth date
hand string (1)
id_number string
lrn string

sections

id increments
section_name_id ^FK integer
adviser_id ^FK integer
grade_level integer
quarter integer
school_year string

learner_section

id increments
learner_id ^FK integer
section_id ^FK integer

section_names

id increments
name string
code string

subjects

id increments
name string
description text
code string

section_subject

id increments
section_id ^FK integer
subject_id ^FK integer

teachers

id increments
last_name string
first_name string
extension_name string
middle_name string
sex string
id_number string
code string
date_of_birth date
contact string
email string

section_subject_teacher

id increments
section_subject_id ^FK integer
teacher_id ^FK integer

special_sections

id increments
section_name_id ^FK integer
subject_id ^FK integer
teacher_id ^FK integer
grade_level integer
school_year string
quarter integer

learner_special_section

id increments
learner_id ^FK integer
special_section_id ^FK integer

guardians

id increments
name string
sex string (1)
date_of_birth date
contact string
home_address_line_one string
barangay string
city_municipality string
province string
citizenship string
religion string
work string
company string
company_address string

guardian_learner

id increments
guardian_id ^FK integer
learner_id ^FK integer

behavioral_concerns

id increments
name string

behavioral_concern_learner

id increments
behavioral_concern_id ^FK integer
learner_id ^FK integer

health_concerns

id increments
name string

health_concern_learner

id increments
health_concern_id ^FK integer
learner_id ^FK integer

addresses

id increments
line_1 string
barangay string
city_municipality string
province string
country string

religions

id increments
name string

living_with

id increments
name string

alumni_batches

id increments
level string

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