Home
school
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
pupils
id
increments
name
string
(255)
admno
string
(20)
admdate
datetime
dateofbirth
date
parent_id
FK
integer
branch_id
FK
integer
created_by
FK
integer
timestamps
timestamps
updated_by
FK
integer
softDeletes
softDeletes
subjects
id
increments
subjectname
string
(255)
subjectcode
string
(50)
timestamps
timestamps
softDeletes
softDeletes
classes
id
increments
classname
string
(255)
created_by
FK
integer
timestamps
timestamps
updated_by
FK
integer
softDeletes
softDeletes
teacherSubjects
id
increments
teacher_id
FK
integer
subject_id
FK
integer
class_id
FK
integer
timestamps
timestamps
softDeletes
softDeletes
tests
id
increments
testname
string
(50)
timestamps
timestamps
softDeletes
softDeletes
branches
id
increments
branchname
string
(255)
timestamps
timestamps
softDeletes
softDeletes
terms
id
increments
term
string
(100)
timestamps
timestamps
softDeletes
softDeletes
roles
id
increments
rolename
string
(255)
timestamps
timestamps
softDeletes
softDeletes
permissions
id
increments
pname
string
(255)
slugname
string
(255)
timestamps
timestamps
softDeletes
softDeletes
permissionRole
id
increments
role_id
FK
integer
permission_id
FK
integer
timestamps
timestamps
performances
id
increments
classpupil_id
FK
integer
subject_id
FK
integer
class_id
FK
integer
teacher_id
FK
integer
test_id
FK
integer
branch_id
FK
integer
term_id
FK
integer
timestamps
timestamps
softDeletes
softDeletes
users
id
increments
name
string
(255)
email
string
(255)
username
string
(255)
password
string
(255)
timestamps
timestamps
role_id
FK
integer
softDeletes
softDeletes
classPupil
id
increments
pupil_id
FK
integer
class_id
FK
integer
year
date
timestamps
timestamps
softDeletes
softDeletes
parent
id
increments
parent
string
(100)
mother
string
(100)
phoneno
string
(20)
email
string
(50)
created_by
FK
integer
timestamps
timestamps
updated_by
FK
integer
softDeletes
softDeletes
×
Comments for school
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01