invoicewebplatform - Laravel Schema Designer

admins

id increments
name string (255)
email string (255)
password string (255)
phone string (255)
remember_token string (255)
is_deleted boolean
timestamps timestamps

admin_roles

id increments
name string (255)
is_deleted boolean
timestamps timestamps

admin_role_permissions

id increments
role_id ^FK integer
route_id ^FK integer
permission tinyInteger
timestamps timestamps

route_details

id increments
menu_id ^FK integer
name string (255)
route string (255)
is_deleted boolean
timestamps timestamps

menus

id increments
name string (255)
is_deleted boolean
timestamps timestamps

admin_settings

id increments
is_user_register boolean
is_admin_register boolean
default_image string (255)
timestamps timestamps

businesses

id increments
account_id ^FK integer
package_id ^FK integer
name string (255)
email string (255)
address string (255)
address_1 string (255)
city string (255)
state string (255)
country string (255)
phone string (255)
phone_1 string (255)
description string (255)
token string (255)
is_deleted boolean
timestamps timestamps

users

id increments
account_id ^FK integer
role_id ^FK integer
name string (255)
type tinyInteger
email string (255)
password string (255)
phone string (255)
phone_1 string (255)
remember_token string (255)
position string (255)
address string (255)
address_1 string (255)
image string (255)
is_deleted boolean
timestamps timestamps

roles

id increments
account_id ^FK integer
name string (255)
is_deleted boolean
timestamps timestamps

role_permissions

id increments
role_id ^FK integer
route_id ^FK integer
permission tinyInteger
timestamps timestamps

business_users

id increments
business_id ^FK integer
user_id ^FK integer
timestamps timestamps

categories

id increments
account_id ^FK integer
business_id ^FK integer
name string (255)
is_deleted boolean
timestamps timestamps

invoices

id increments
account_id ^FK integer
payer string (255)
payor string (255)
currency string (255)
total_amount string (255)
date string (255)
is_deleted boolean
timestamps timestamps

items

id increments
account_id ^FK integer
item string (255)
amount string (255)
is_deleted boolean
timestamps timestamps

invoice_items

id increments
invoice_id ^FK integer
item_id ^FK integer
timestamps timestamps

labels

id increments
account_id ^FK integer
business_id ^FK integer
label string (255)
is_deleted boolean
timestamps timestamps

label_values

id increments
account_id ^FK integer
business_id ^FK integer
label_id ^FK integer
value string (255)
is_deleted boolean
timestamps timestamps

logs

id increments
user_id ^FK integer
account_id ^FK integer
description longText
extra_values string (255)
timestamps timestamps

packages

id increments
name string (255)
price double (8,2)
allowed_user string (255)
description longText
is_deleted boolean
timestamps timestamps

suppliers

id increments
account_id ^FK integer
name string (255)
email string (255)
phone string (255)
phone_1 string (255)
address string (255)
address_1 string (255)
industry string (255)
bank_name string (255)
bank_account string (255)
is_deleted boolean
timestamps timestamps

uploads

id increments
account_id ^FK integer
business_id ^FK integer
folder string (255)
file_name string (255)
name string (255)
extention string (255)
file_mime string (255)
ocr_xml string (255)
timestamps timestamps

upload_label_values

id increments
upload_id ^FK integer
label_value_id ^FK integer
timestamps timestamps

file_categories

id increments
upload_id ^FK integer
category_id ^FK integer
timestamps timestamps

accounts

id increments
name string (255)
email string (255)
phone string (255)
phone_1 string
address string (255)
address_1 string (255)
is_deleted boolean
timestamps timestamps

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