OnlineEducation - Laravel Schema Designer

Episodes

Id increments
Title string
Description string
Price string
Duration string
Cover string
CategoryId ^FK integer
ParentId ^FK integer
created_at timestamps
updated_at timestamps
softDeletes softDeletes

Episode_Publisher

Id increments
EpisodeId ^FK integer
PublisherId ^FK integer
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Sessions

Id increments
Title string (128)
Description string
DownloadUrl string (512)
EpisodeId ^FK integer
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Episode_User

Id increments
UserId ^FK integer
EpisodeId ^FK integer
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Users

Id increments
Full_name string (128)
Native_ID string (10)
Email string
Mobile string (11)
Profile string
Story string (4000)
IP string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Category

Id increments
Title string
Description string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Tags

Id increments
Title string
Description string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Episode_Tag

Id increments
TagId ^FK integer
EpisodeId ^FK integer
created_at timestamp
updated_at timestamp
softDeletes softDeletes

Baskets

Id increments
Title string
UserId ^FK integer
Total string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Basket_Episode

Id increments
BasketId ^FK integer
EpisodeId ^FK integer
Quantity smallInteger
TotalPrice string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Comments

Id increments
Commentable_Id integer
Commentable_Type string
Message string (4000)
ParentId ^FK integer
EpisodeId ^FK integer
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Discounts

Id increments
Code string (64)
Value smallInteger
Valid boolean
HasFilter boolean
Start_Date string (10)
End_Date string (10)
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Discount_Episode

Id increments
EpisodeId ^FK integer
DiscountId ^FK integer
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Payments

Id increments
UserId ^FK integer
Cost string
DiscountId ^FK integer
Transaction_ID string
paid_at timestamp
Paid_ID string
created_at timestamps
updated_at timestamp
softDeletes softDeletes

Sliders

Id increments
Title string
created_at timestamp
softDeletes softDeletes
updated_at timestamp

Slides

Id increments
Image string
Text string
SliderId ^FK integer
created_at timestamp
updated_at timestamp
softDeletes softDeletes

Publishers

Id increments
Full_name string (64)
Email string
Mobile string (11)
Native_ID string (10)
Profile string
Story string (4000)
IP string
created_at timestamp
updated_at timestamp
softDeletes softDeletes

Payment_Episode

Id increments
PayId ^FK integer
EpisodeId ^FK integer
created_at timestamp
updated_at timestamp
softDeletes softDeletes

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