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

customers

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
last_name string
license string
email string
organization string
referred tinyInteger
contact_person string
customer_group_id ^FK integer
contact_id ^FK integer
network_id ^FK integer

customer_groups

id increments
timestamps timestamps
name string
repair integer
unlocking integer
accessories integer
tradein integer
casual integer
type tinyInteger

billing_detail

id increments
timestamps timestamps
first_name string
last_name string
email string
organization string
contact_person string
network_id ^FK integer
contact_id ^FK integer

networks

id increments
timestamps timestamps
name string

colors

id increments
timestamps timestamps
color string (50)

manage_invoices

product_name string
id increments
timestamps timestamps
description text
notes text
invoice_id ^FK integer
quantity tinyInteger
price integer
line_discount tinyInteger
taxclass ^FK integer

tex_classes

id increments
timestamps timestamps
name string
percentage integer

manage_tickets

id increments
timestamps timestamps
name string

invoices

id increments
timestamps timestamps
customer_id ^FK integer
due_date datetime
order_date datetime
created_by ^FK integer
slogan string
footer string
notes text
ticket_number ^FK integer