Home
school
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
username
string
(200)
email
string
(200)
password
string
(200)
type
tinyInteger
remember_token
string
(100)
timestamps
timestamps
roles
id
increments
name
string
(100)
guard_name
string
(100)
timestamps
timestamps
permissions
id
increments
name
string
(100)
desc
string
(200)
timestamps
timestamps
role_has_permissions
id
increments
permission_id
integer
role_id
integer
timestamps
timestamps
logs
id
increments
user_id
integer
type
enum
notes
text
timestamps
timestamps
classes
id
increments
name
string
(200)
timestamps
timestamps
sections
id
increments
class_id
integer
name
string
(200)
timestamps
timestamps
students
id
increments
user_id
integer
name
string
(255)
parent_id
integer
calss_id
integer
section_id
integer
roll
integer
Birthday
string
(50)
Gender
enum
Address
text
Phone
string
(50)
dormitory_id
integer
transport_id
integer
photo
string
timestamps
timestamps
syllabus
id
increments
title
string
(255)
Description
text
class_id
integer
subject_id
integer
file
string
(100)
timestamps
timestamps
dormitories
id
increments
name
string
(255)
timestamps
timestamps
desc
text
rooms
integer
transports
id
increments
name
string
(255)
vehicle
integer
desc
text
fare
integer
timestamps
timestamps
stu_materials
id
increments
date
string
(100)
title
string
(255)
desc
text
class_id
integer
subject_id
integer
timestamps
timestamps
exams
id
increments
name
string
(255)
date
string
(100)
comment
text
timestamps
timestamps
exam_grades
id
increments
timestamps
timestamps
name
string
(250)
point
integer
mark_from
integer
mark_upto
integer
comment
text
noticeboards
id
increments
timestamps
timestamps
title
string
(255)
Notice
text
Date
string
(100)
photo
string
(100)
active
tinyInteger
books
id
increments
name
string
(255)
author
string
(255)
desc
text
price
integer
class_id
integer
timestamps
timestamps
teachers
id
increments
timestamps
timestamps
user_id
integer
name
string
(255)
designation
string
(255)
birthday
string
(100)
gender
enum
address
text
phone
string
(50)
social_links
text
show
tinyInteger
photo
string
(100)
parents
id
increments
user_id
integer
name
string
(255)
phone
string
(50)
address
text
profession
integer
timestamps
timestamps
librarians
id
increments
user_id
integer
name
string
(255)
timestamps
timestamps
accountants
id
increments
user_id
integer
name
string
(255)
timestamps
timestamps
messages
id
increments
user_id
integer
user_to
integer
body
text
read_at
string
(100)
timestamps
timestamps
settings
id
increments
slug
string
(50)
name
string
(150)
value
text
type
integer
orderBy
integer
timestamps
timestamps
pages
id
increments
pName
string
(150)
pLink
string
(150)
content
text
type
tinyInteger
active
tinyInteger
timestamps
timestamps
subjects
id
increments
name
string
(255)
calss_id
integer
teacher_id
integer
timestamps
timestamps
model_has_roles
id
increments
timestamps
timestamps
role_id
integer
model_type
string
(191)
model_id
bigInteger
invoices
id
increments
timestamps
timestamps
accountant_id
integer
parent_id
integer
details
text
due_date
timestamp
admins
id
increments
user_id
integer
name
string
(255)
timestamps
timestamps
professions
id
increments
name
string
(255)
timestamps
timestamps
menus
id
increments
parent_id
integer
title
string
(255)
link
string
(255)
target
integer
order_by
integer
status
tinyInteger
type
text
contacts
id
increments
name
string
(255)
email
string
(255)
phone
string
(50)
subject
string
(255)
body
text
active
tinyInteger
timestamps
timestamps
×
Comments for school
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01