OICOFR - Laravel Schema Designer

oicofr_institute

id increments
institute_code integer
institute_name string (191)
institute_logo string (191)
institute_address string (191)
institute_contact string (191)
institute_website string (191)
authorized_signature string (191)
timestamps timestamps
softDeletes softDeletes

students

id increments
institute_id ^FK integer
student_name string (191)
student_photo string (191)
student_parents string (191)
student_class string (191)
student_section string (191)
student_batch string (191)
roll_no integer
registration_no integer
student_date_of_birth date
student_blood_group string (191)
student_contact string (191)
student_department string (191)
student_signature string (191)
timestamps timestamps
softDeletes softDeletes

teachers

id increments
institute_id ^FK integer
teacher_name string (191)
teacher_photo string (191)
employee_code integer
teacher_blood_group string (191)
teacher_date_of_birth date
teacher_contact string (191)
teacher_department string (191)
teacher_signature string (191)
timestamps timestamps
softDeletes softDeletes

student_teacher

id increments
timestamps timestamps
teacher_id ^FK integer
student_id ^FK integer

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