Home
school_db
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
students
id
increments
name
string
(255)
gender
integer
date_of_birth
date
religion
string
(255)
mobile
string
email
string
stage_id
FK
integer
guardians
id
increments
father_name
string
mother_name
string
guardian_name
string
father_mobile
string
mother_mobile
string
guardian_mobile
string
guardian_email
string
employees
id
increments
timestamps
timestamps
number
string
name
string
department_id
FK
integer
sallary
integer
departments
id
increments
timestamps
timestamps
name
string
parent
FK
integer
moderators
id
increments
timestamps
timestamps
name
string
email
string
password
string
moderator_departments
id
increments
timestamps
timestamps
moderator_id
FK
integer
department_id
FK
integer
leaves
id
increments
start_from
datetime
end_at
datetime
employee_id
FK
integer
leave_type
FK
integer
department_id
FK
integer
image
string
timestamps
timestamps
leaves_types
id
increments
timestamps
timestamps
name
string
note
text
payrolls
id
increments
timestamps
timestamps
rewards
id
increments
timestamps
timestamps
amount
string
note
text
status
enum
employee_id
FK
integer
moderator_id
FK
integer
borrows
id
increments
amount
string
note
text
employee_id
FK
integer
moderator_id
FK
integer
timestamps
timestamps
status
enum
discounts
id
increments
amount
string
note
text
employee_id
FK
integer
moderator_id
FK
integer
date
timestamps
timestamps
timestamps
rates
id
increments
rate
integer
date
timestamps
moderator_id
FK
integer
employee_id
FK
integer
related_type
enum
timestamps
timestamps
student_id
FK
integer
holidays
id
increments
start_from
timestamps
ends_at
timestamps
note
text
department_id
FK
integer
timestamps
timestamps
moderator_id
FK
integer
stages
id
increments
timestamps
timestamps
name
string
parent
FK
integer
behaviors
id
increments
rate
integer
date
date
note
text
student_id
FK
integer
employee_id
FK
integer
timestamps
timestamps
tests_students
id
increments
date
date
materials
json
timestamps
timestamps
student_id
FK
integer
finalgrade
integer
finalgrade_result
integer
account_cats
id
increments
type
enum
name
string
timestamps
timestamps
accounts
id
increments
amount
string
note
text
type
enum
moderator_id
FK
integer
acccount_cat_id
FK
integer
employee_id
FK
integer
student_id
FK
integer
timestamps
timestamps
×
Comments for school_db
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01