robotics - Laravel Schema Designer

users

id increments
role_id integer
email string
password string
first_name string
last_name string
phone string (20)
active boolean
timestamps timestamps
rememberToken rememberToken
softDeletes softDeletes
course_class_id ^FK integer
agent_id ^FK integer
api_token string (60)
avatar_id ^FK integer
nickname string

roles

id increments
value string

password_resets

email string
token string
created_at timestamp

course_templates

id increments
timestamps timestamps
difficulty_id ^FK integer
description text
agent_id ^FK integer
active boolean

course_agent_templates

template_id ^FK integer
agent_id ^FK integer

course_classes

id increments
timestamps timestamps
softDeletes softDeletes
name string
institute_id ^FK integer

difficulties

id integer
value string
level integer

courses

id increments
timestamps timestamps
softDeletes softDeletes
template_id ^FK integer
instructor_id ^FK integer
course_class_id ^FK integer
course_datetime timestamp

lessons

id increments
timestamps timestamps
softDeletes softDeletes
name string
difficulty_id ^FK integer
description text
xml_data text
hint_translation string
min_points integer
max_points integer

course_lessons

course_template_id ^FK integer
lesson_id ^FK integer

lesson_feedbacks

user_id ^FK integer
lesson_id ^FK integer
hard_value integer
fun_value integer

lesson_outputs

id increments
timestamps timestamps
xml_data text
user_id ^FK integer
lesson_id ^FK integer
rate_id ^FK integer

rates

id integer
rate integer
value string

avatars

id integer
src string

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