attendify - Laravel Schema Designer

admins

id increments
f_name string (100)
l_name string (100)
email string (255)
password string (255)
photo string (255)
access_id ^FK bigInteger
created_at timestamp
updated_at timestamp

access_types

id increments
name string (100)
created_at timestamp
updated_at timestamp

locations

id increments
name string (100)
address string (255)
map string (255)
created_admin_id ^FK bigInteger
created_at timestamp
updated_at timestamp

classes

id increments
name string (255)
teacher_id ^FK bigInteger
location_id ^FK bigInteger
created_admin_id ^FK bigInteger
created_at timestamp
updated_at timestamp

sessions

id increments
name string (100)
barcode string (255)
class_id ^FK bigInteger
created_at timestamp
updated_at timestamp

students

id integer
student_no string (100)
Fname string (100)
Lname string (100)
password string (255)
email string (255)
photo string (255)
section_id ^FK integer
gender_id ^FK integer
created_at timestamp
updated_at timestamp

genders

id integer
name string (20)
created_at timestamp
updated_at timestamp

sections

id integer
name string (100)
created_at timestamp
updated_at timestamp

class_students

id integer
class_id ^FK integer
student_id ^FK integer
created_at timestamp
updated_at timestamp

session_students

id integer
session_id ^FK integer
student_id ^FK integer
status tinyInteger
created_at timestamp
updated_at timestamp

logins

id integer
admin_id ^FK integer
created_at timestamp

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