smartElimu Content - Laravel Schema Designer

package

id increments
package_name string (255)
publish_date date
package_category string (255)
description text
class string (255)
price integer
status boolean
timestamps timestamps

subjects

id increments
package_id ^FK integer
subject_name string (255)
publish_date datetime
description text
status boolean
timestamps timestamps

chapters

id increments
subject_id ^FK integer
description text
status boolean
timestamps timestamps

section

id increments
chapter_id ^FK integer
section_name string (255)
text_file text
video_file string (255)
audio_file string (255)
photo string (255)
timestamps timestamps

games

id increments
subject string (255)
publishDate date
description text
timestamps timestamps

paymentsRec

id increments
tokenNumber bigInteger
userID integer
recordNumber integer
packageName string
transactionDate date
status string
amount integer
vendor string
description text
tax integer
vat integer
timestamps timestamps

code

id increments
code string (255)
timestamps timestamps

code_values

id increments
code_id integer
values string (255)
timestamps timestamps

syllabus

id increments
timestamps timestamps
name string
file string

examinations

id increments
subject string (255)
class string (255)
year string (255)
file string (255)
timestamps timestamps

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