database_cic - Laravel Schema Designer

admin

admin_id increments
admin_name string (255)
admin_email string (255)
admin_pasword string
admin_role tinyInteger
admin_status tinyInteger
timestamps timestamps
softDeletes softDeletes

lessons

lesson_id increments
lesson_status tinyInteger
lesson_no string
lesson_title string
fk_course_id ^FK integer
lesson_level_id integer
lesson_sumary text
lesson_guide text
lesson_admin_note string
lesson_area string
lesson_subject string
lesson_result_public_date datetime
lesson_test_date datetime
lesson_test_status tinyInteger
timestamps timestamps
softDeletes softDeletes

courses

course_id increments
course_name string
softDeletes softDeletes

news

news_id increments
news_title string (255)
news_status tinyInteger
news_date_time datetime
news_summary text
news_reporter string
softDeletes softDeletes

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