fixitcounter - Laravel Schema Designer

countries

id increments
name string
code string
status tinyInteger

states

id increments
name string
country_id ^FK integer
status tinyInteger

cities

id increments
name string
state_id ^FK integer
status tinyInteger

timezones

id increments
abbreviation string
time_start datetime
gmt_offset string
zone_id ^FK integer

zones

id increments
country_id ^FK integer
name string

languages

id increments
name string
code string
status tinyInteger

currencies

id increments
name string
sign string
placement string
status tinyInteger

contacts

id increments
timestamps timestamps
phone string
mobile string
fax string
address string
country_id ^FK integer
state_id ^FK integer
city_id ^FK integer
zip string
website string
default_address string

stores

id increments
timestamps timestamps
softDeletes softDeletes
registration_no string
business_name string
alternative_name string
email string
logo string
contact_id ^FK integer
currency_id ^FK integer
start_time datetime
end_time datetime
status tinyInteger

roles

id increments
name string

users

id increments
name string
timestamps timestamps
softDeletes softDeletes
email string
password string
gender tinyInteger
access_pin string
image string
confirmed tinyInteger
confirmation_code string
contact_id ^FK integer
status tinyInteger
store_id ^FK integer

module

id increments
name string

role_user

id increments
user_id ^FK integer
role_id ^FK integer

role_permisiions

id increments
role_id ^FK integer
module_id ^FK integer
view tinyInteger
edit integer
delete tinyInteger

categories

id increments
name string
parent_id ^FK integer
status tinyInteger

manufacturers

id increments
name string
contact_id ^FK integer

devices

id increments
name string
manufacturer_id ^FK integer
store_id ^FK integer

suppliers

id increments
name string
email string
contact_id ^FK integer

products

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string
warranty_duration integer
warranty_plan string
sku string
upc_code string
has_barcode tinyInteger
image string
is_displayed tinyInteger
category_id ^FK integer
store_id ^FK integer
manufacturer_id ^FK integer
retail_price integer
cost_price integer
sale_price integer
TAX_CLASS string
tax_inclusive tinyInteger
is_inventory_managed tinyInteger
in_stock integer
stock_warning_limit integer
reorder_level integer
physical_location string
supplier_id ^FK integer
MANAGE_SERIALIZED_INVENTORY string

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