books - Laravel Schema Designer

authors

id increments
name string (255)
summary text
timestamps timestamps

categories

id increments
name string (255)
hasAuthor boolean
hasSummary boolean
ordering integer
timestamps timestamps

materials

id increments
category_id ^FK integer
title string (255)
author_id ^FK integer
image string
background_color string (255)
sound_track string (255)
minutes string (255)
description text
listen_count string (255)
is_paid boolean
timestamps timestamps

settings

id increments
terms_condition text
about_app text
fb_link string (255)
tw_link string (255)
insta_link string (255)
tube_link string (255)
whatsapp string (255)
timestamps timestamps

packages

id increments
name string (255)
unit_count string (255)
type_unit enum
price decimal (8,2)
summary text
available_byshare boolean
timestamps timestamps

users

id increments
name string (255)
email string (255)
password string
role_name string (255)
timestamps timestamps

clients

id increments
name string (255)
email string (255)
password string (255)
timestamps timestamps

notifications

id increments
timestamps timestamps
title string (255)
content text
material_id ^FK integer

client_notification

id increments
timestamps timestamps
notification_id ^FK integer
client_id ^FK integer
is_read boolean

subscribtions

id increments
client_id ^FK integer
package_id ^FK integer
package_value decimal (8,2)
date date
order_status enum
from date
to date
timestamps timestamps

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