schoolkrant_3 - Laravel Schema Designer

users

id increments
email string
password string
first_name string
last_name string
permissions text
activated tinyInteger
activation_code string
activated_at timestamp
last_login timestamp
persist_code string
reset_password_code string
school_id ^FK integer
timestamps timestamps

user_details

id increments
user_id ^FK integer
birth_date timestamp
timestamps timestamps

groups

id increments
name string
permissions text
timestamps timestamps

throttle

id increments
user_id ^FK integer
ip_address string
attempts integer
suspended tinyInteger
banned tinyInteger
last_attempt_at timestamp
suspended_at timestamp
banned_at timestamp

users_groups

user_id integer
group_id integer

achievements

id increments
titel string (255)
type string (255)
image string (255)
timestamps timestamps

user_achievements

user_id ^FK integer
achievement_id ^FK integer

schools

id increments
name string (255)
logo string (255)
timestamps timestamps

invites

id increments
uid string (255)
user_id ^FK integer
timestamps timestamps

courses

id increments
titel string (255)
slug string (255)
body text
template string (255)
view string (255)
css_class string (255)
custom text
timestamps timestamps

chapters

id increments
lesson_id integer
titel string (255)
slug string
quick_navigation string (255)
order tinyInteger
custom string
timestamps timestamps

lessons

id increments
course_id ^FK integer
avatar_id integer
titel string (255)
slug string
subtitle string (255)
href string (255)
order tinyInteger
custom text
timestamps timestamps

media

id increments
page_id ^FK integer
titel string (255)
path string (255)
media_type tinyInteger
timestamps timestamps

user_progress

id increments
user_id ^FK integer
course_id ^FK integer
lesson_id ^FK integer
chapter_id ^FK integer
page_id ^FK integer
timestamps timestamps

pages

id increments
chapter_id ^FK integer
templateview_id ^FK integer
page_type enum
quick_navigation string (255)
titel string (255)
slug string
subtitel string (255)
body text
view string (255)
css_class string (255)
footer text
expert text
list text
custom text
order integer
timestamps timestamps

page_footer

id increments
timestamps timestamps

page_lists

id increments
timestamps timestamps

templates

id increments
template_name string
template_schema text
timestamps timestamps

template_views

id increments
view string
template_id ^FK integer
timestamps timestamps

avatars

id increments
name string
filename string
timestamps timestamps

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