b2v_courses - Laravel Schema Designer

users

id increments
name string
last_name string
photo string
privilege integer
email string
password string
rememberToken rememberToken
phone string
mobile string
profession string
level1 string
level2 string
level3 string
position string
company_name string
country_name string
city_name string
type_user string
coach_info text
status string
active tinyInteger
notes text
company_id ^FK integer
project_id integer
timestamps timestamps

companies

id increments
company_name string
description text
image string
timestamps timestamps

courses

id increments
course_name string
no_modules integer
image_icon string
active tinyInteger
addressed text
description text
meta_keywords string
meta_description text
plan string
no_lessons integer
priority smallInteger
default_price float
no_tests integer
timestamps timestamps

modules

id increments
module_name string
no_lessons integer
image_icon string
active tinyInteger
description text
meta_keywords string
meta_description string
plan string
order mediumInteger
course_id ^FK integer
timestamps timestamps

lessons

id increments
lesson_name string
number integer
no_videos integer
no_exercises integer
image_icon string
active tinyInteger
pdf_file string
module_id ^FK integer
timestamps timestamps

videos

id increments
video_name string
is_full tinyInteger
part integer
url_video string
active tinyInteger
video_file string
lesson_id ^FK integer
timestamps timestamps

tests

id increments
test_name string
instructions text
description text
notes text
total_questions integer
typetest_id ^FK integer
timestamps timestamps
order integer
is_evaluation tinyInteger
algorithm mediumInteger
coach_assistance tinyInteger
active tinyInteger
video_url string

typetests

id increments
type_name string
description text
notes text
timestamps timestamps

questions

id increments
number integer
question text
total_options integer
total_answers integer
test_id ^FK integer
timestamps timestamps

options

id increments
number integer
option text
correct tinyInteger
value integer
explanation text
question_id ^FK integer
timestamps timestamps

typeresults

id increments
type_name string
notes text
description text
timestamps timestamps

results

id increments
total float
explanation text
graphic_img text
answers text
coach_retro text
test_id ^FK integer
user_id ^FK integer
typeresult_id ^FK integer
timestamps timestamps

projects

id increments
project_name string
project_image string
start_date datetime
end_date datetime
active tinyInteger
timestamps timestamps
company_id ^FK integer

assignments

id increments
all_tests tinyInteger
specific_tests text
coach_user integer
user_id ^FK integer
timestamps timestamps
default_coach integer

retros

id increments
retro text
notes text
course_user integer
user_id ^FK integer
result_id ^FK integer
timestamps timestamps

userlogins

id increments
login_ip string
user_id ^FK integer
timestamps timestamps

explanations

id increments
explanation text
sum integer
inf_limit float
sup_limit float
identifier string
test_id ^FK integer
timestamps timestamps

packages

id increments
identifier string
template_tests text
description text
project_id ^FK integer
user_id ^FK integer
timestamps timestamps

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