whms - Laravel Schema Designer

customers

id increments
name string
tax_number string
timestamps timestamps
softDeletes softDeletes
taxoffice string
brand_name text

products

id increments
timestamps timestamps
softDeletes softDeletes
product_name text
category_id integer
variant string
variant_2 string
user_id integer
customer_id integer

warehouses

id increments
timestamps timestamps
softDeletes softDeletes
warehouse_name string
adress text
district text
city_id integer
district_id integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
category_name string
customer_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name text
last_name text
e_mail text
role_id integer
customer_id integer

stock_transactions

id increments
timestamps timestamps
softDeletes softDeletes
invoice_number string
accept_date datetime
damage_status string
receipt_amount integer
count_amount integer
count_match boolean
move_type_id integer
restock_status boolean
user_id integer
warehouse_id integer
exit_location string
arrival_location string

stocks

id increments
product_id integer
total_quantity decimal
reserved_quantity decimal
timestamps timestamps
softDeletes softDeletes

stock_movements

id increments
timestamps timestamps
softDeletes softDeletes
type string
product_id integer
stok_transaction_id integer
quantity decimal
user_id integer
stock_id integer
damage_status string
warehouse_id integer

move_types

id increments
timestamps timestamps
type text

location_types

id increments
timestamps timestamps
type text

stock_transaction_differences

id increments
timestamps timestamps
stock_transaction_id integer
difference_amount decimal
difference_type string
user_id integer

orders

id increments
timestamps timestamps
status_id integer
vendor_reference_number string
platform_order_id string
stock_transaction_id integer
order_channel string
delivery_company string
delivery_company_barcode string
recipient_name string
recipient_phone string
recipient_mail string
city_id string
district_id string
address string
neighborhood string
order_reference_number_1 string
order_reference_number_2 string
order_reference_number_3 string
order_reference_number_4 string

order_lines

id increments
timestamps timestamps
product_barcode string
quantity integer
giftable string
product_id integer
order_id integer

product_barcodes

id increments
timestamps timestamps
produc_id string
product_barcode string

order_statuses

id increments
timestamps timestamps
name string
type string

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string

districts

id increments
timestamps timestamps
softDeletes softDeletes
name string

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