lms - Laravel Schema Designer

lessons

id increments
softDeletes softDeletes
total_seats integer
start_date datetime
end_date datetime
tutor_id integer
lesson_type string
lesson_details longText
duration integer
slug string (255)
meta_title string (255)
meta_description string (255)
meta_keywords string (255)
cover_image string (255)
price integer
access_period datetime
status tinyInteger
timestamps timestamps

lesson_faq

id increments
lesson_id ^FK integer
faq_id integer
timestamps timestamps

faqs

id increments
question string (255)
answer text
status tinyInteger
timestamps timestamps

lesson_types

id increments
name string (255)
status tinyInteger
timestamps timestamps

tutor_availability

id increments
unavailable_date datetime
timestamps timestamps
unavailable_slots string (255)
status tinyInteger

lesson_availibiity

id increments
timestamps timestamps
lesson_id ^FK integer
tutor_availability_id ^FK integer
slots string (255)
status tinyInteger

sample_videos

id increments
timestamps timestamps
tite string (255)
details string (255)
video_url string (255)
lesson_id ^FK integer
status tinyInteger

bundles

id increments
timestamps timestamps
lesson_id smallInteger
status tinyInteger
lesson_type_id tinyInteger

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