iccn - Laravel Schema Designer

trainings

id increments
timestamps timestamps
softDeletes softDeletes
title string (199)
thumbnail string (255)
preview string (255)
description text
location string (255)
overall_rating integer
price integer
is_online boolean
creator_id integer

training_schedules

id increments
timestamps timestamps
softDeletes softDeletes
start_date datetime
end_date datetime
current_participant integer
max_participant integer
training_id ^FK integer

enrolled_training

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
progress integer
schedule_id ^FK integer

lessons

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer
title string (199)
description text
lesson_number integer

lessons_section

id increments
timestamps timestamps
softDeletes softDeletes
title string (199)
video string (255)
paragraph text
lesson_id ^FK integer
lessons_section_number integer

supporting_materials

id increments
timestamps timestamps
softDeletes softDeletes
file_name string (255)
lesson_id ^FK integer

payments

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer
user_id ^FK integer
status boolean
payment_time datetime

enrollments

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer
user_id ^FK integer
payment_id ^FK integer
enrollment_key string (255)

e_certificates

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer
user_id ^FK integer
file_name string (255)

reviews

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer
user_id ^FK integer
rating float (3,2)
review_text string (255)

conversations

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
author_id ^FK integer

messages

id increments
timestamps timestamps
softDeletes softDeletes
conversation_id ^FK integer
message string (255)

pre_tests

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer

post_tests

id increments
timestamps timestamps
softDeletes softDeletes
training_id ^FK integer

users

id increments
timestamps timestamps
softDeletes softDeletes

tips_and_tricks

id increments
timestamps timestamps
softDeletes softDeletes
title string (199)
content text
thumbnail string (255)

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