countries name required short_code required
lesson_tags belongs to a lesson belongs to a tag
institutes name required country_id required
pack_lessons belongs to lesson (lesson_pack_id) belongs to lesson (lesson_id)
belongs to a country has many users has many lessons lesson_files lesson_id required path required
reviews review not empty, required belongs to a user belongs to a lesson ratings rating not empty, required
belongs to lessons belongs to a user belongs to a lesson
categories name required belongs to categories has many sub categories
purchased_lessons belongs to a user belongs to a lesson belongs to a transaction
users user_name required email required belongs to country belongs to institue has many lessons has many reviews has many ratings has many transactions has many favorite lessons
transaction_items belongs to a transaction belongs to a lesson transactions description required price required qty required txn_ref_id required receipt_dump required not-empty
lessons
belongs to a user has many transaction items has many purchased items
name required category_id numeric required belongs to a user belongs to a institute belongs to a category has many lesson_files has many ratings has many reviews has many pack_lessons has many lesson_tags favorite_lessons belongs to a users belongs to a lessons
tags keyword required, not empty has many lesson_tags