mohamed_hassan - Laravel Schema Designer

branches

id increments
timestamps timestamps
softDeletes softDeletes
name json
telephone string (255)
phone string (255)
address json
governorate json
country json
commercial_number string (255)
taxes_card string (255)
policies text
code string

settings

id increments
timestamps timestamps
softDeletes softDeletes
name string
value json
model string (255)

journal_code_settings

id increments
timestamps timestamps
softDeletes softDeletes
model string
options json
type string

journal_codes

id increments
timestamps timestamps
softDeletes softDeletes
journal_code_setting_id integer
model string
alias string
latest_number integer

sms_messages

id increments
timestamps timestamps
softDeletes softDeletes
message text

sms_message_numbers

id increments
timestamps timestamps
sms_message_id integer
phone_number string

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
last_name string (255)
email string (255)
user_name string (255)
is_active boolean
remember_token string (255)
password string (255)
branch_id integer
role_id integer

shifts

id increments
timestamps timestamps
name string (255)
branch_id integer
start_from string
end_at string

user_shifts

id increments
timestamps timestamps
user_id integer
shift_id integer

inventories

id increments
timestamps timestamps
softDeletes softDeletes
name json
code string
phone string
telephone string
address json
notes text

user_inventories

id increments
timestamps timestamps
user_id integer
inventory_id string

inventory_items

id increments
timestamps timestamps
inventory_id integer
item_id integer
amount double
reserved_amount double
unit_price float
purchase_price float
sale_price float

transfers

id increments
timestamps timestamps
softDeletes softDeletes
code string
date date
inventory_from integer
inventory_to integer
total float
created_by integer
confirmed_by integer
confirmed_at timestamp
status string (10)
is_reserved boolean
noted text

transfer_items

id increments
timestamps timestamps
transfer_id integer
item_id integer
inventory_item_id integer
amount double
sale_price float
purchase_price float
unit_price float

purchase_invoices

id increments
timestamps timestamps
customer_id integer
code string
date date
total float
created_by integer
confirmed_by integer
confirmed_at integer
status string (10)

purchase_invoice_items

id increments
timestamps timestamps
softDeletes softDeletes
purchase_invoice_id integer
item_id integer
amount double
purchase_price float
sale_price float
unit_price float

items

id increments
timestamps timestamps
name json
code string
description json
category_id integer
brand_id integer
purchase_price float
sale_price float
unit_price float
unit_of_measures integer
item_number string
barcode string
min_sale_amount double
max_sale_amount double
expire_date date
min_stock double
discount_amount float
discount_type string
active_taxes boolean
notes text

inventory_adjustments

id increments
timestamps timestamps
inventory_id integer
title string (255)
date date
created_by integer
status string (10)
confirmed_at date
confirmed_by integer

inventory_adjustment_items

id increments
timestamps timestamps
inventory_adjustment_id integer
item_id integer
inventory_item_id integer
old_amount double
new_amount double
type string (10)

unit_of_measures

id increments
timestamps timestamps
parent_id integer
name json
amount float
parent_amount float
width float
height float
length float
volume float

categories

id increments
timestamps timestamps
name json
description json
parent_id integer

brands

id increments
timestamps timestamps
softDeletes softDeletes
parent_id integer
name json
description json

sales_performas

id increments
timestamps timestamps
softDeletes softDeletes
inventory_id integer
customer_id integer
code string
date date
total float
created_by integer
confirmed_at timestamp
confirmed_by integer
status string (10)
notes text
discount_type string (10)
discount_amount float
total_discount float
taxes_amount float
performa_type enum

sales_performa_items

id increments
timestamps timestamps
sales_performa_id integer
item_id integer
unit_price float
sales_price float
purchase_price float
unit_of_measure_id integer
amount double
discount_type string (10)
discount_amount float
taxes_amount float

customers

id increments
timestamps timestamps
softDeletes softDeletes
code string
name string (255)
email string (255)
phone string
telephone string
address json
initial_balance float
credit_balance float
debit_balance float
type string (10)
notes text
national_id string
min_credit float
min_debit float
max_debit float
max_credit float
invoice_type enum
installment_days integer
is_active boolean
group_id integer
country string
governorate string
city string
fax string

customers_groups

id increments
timestamps timestamps
softDeletes softDeletes
name json
description json
type string (10)

sales_men

id increments
timestamps timestamps
softDeletes softDeletes
employee_id integer
code string
name string
email string
address text
phone string
target_amount float
comission float
notes text
is_active boolean
created_by integer
shift_id integer

sales_men_visits

id increments
timestamps timestamps
softDeletes softDeletes
code string
sales_man_id integer
customer_id integer
date date
title string
notes text
cost float

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