tawasol - Laravel Schema Designer

categories

id bigIncrements
timestamps timestamps
name string

subcategories

id bigIncrements
timestamps timestamps
name string
category_id ^FK bigInteger

units

id bigIncrements
timestamps timestamps
name string
countable boolean

subunits

id bigIncrements
timestamps timestamps
name string
quantity integer
unit_id ^FK bigInteger

products

id bigIncrements
timestamps timestamps
name string
subcategory_id ^FK bigInteger
type enum
countable boolean
special_price float
price float
number_of_available_pieces integer
number_of_minimum_pieces integer
about_to_decrease boolean

clients

id bigIncrements
timestamps timestamps
name string
phone string
type enum

resources

id bigIncrements
timestamps timestamps
name string
type enum

utilizations

id bigIncrements
timestamps timestamps
name string

packages

id bigIncrements
timestamps timestamps
resource_id ^FK bigInteger
utilization_id ^FK bigInteger
accounting_method enum
number_of_paid_hours integer
price float

sale_bills

id bigIncrements
timestamps timestamps
client_id ^FK bigInteger
package_id ^FK bigInteger
entry_day date
checkout_day date
entry_time time
checkout_time time
status enum
notes text
discount float
user_id ^FK bigInteger

sale_bill_payments

id bigIncrements
timestamps timestamps
sale_bill_id ^FK bigInteger
price float
notes text

product_sale_bill

id bigIncrements
timestamps timestamps
sale_bill_id ^FK bigInteger
product_id ^FK bigInteger
price float
quantity integer
discount float

histories

id bigIncrements
timestamps timestamps
user_id ^FK bigInteger
description text

users

id bigIncrements
timestamps timestamps

suppliers

id bigIncrements
timestamps timestamps
name string
phone string
address text

expense_items

id bigIncrements
timestamps timestamps
name string
changeable boolean
price float
discount_percentage_1 float
discount_percentage_2 float

expenses

id bigIncrements
timestamps timestamps
expense_item_id ^FK bigInteger
price float
notes text

purchase_bills

id bigIncrements
timestamps timestamps
supplier_id ^FK bigInteger
bill_number string
user_id ^FK bigInteger

purchase_bill_product

id bigIncrements
timestamps timestamps
purchase_bill_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
subunit_id ^FK bigInteger
price float

images

id increments
timestamps timestamps
path text
imageable_type string
imageable_id bigInteger

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