posbengkel - Laravel Schema Designer

service

id increments
service_type integer
kode_kendaraan string (20)
created_at timestamps
updated_at timestamps

users

id increments
name string (191)
email string (191)
remember_token string (100)
phone string (191)
company_name string (191)
role_id integer
biller_id integer
warehouse_id integer
is_active tinyInteger
is_deleted tinyInteger
created_at timestamps
updated_at timestamps

warehouses

id increments
name string (191)
phone string (191)
email string (191)
address text
is_active tinyInteger
created_at timestamps
updated_at timestamps

units

id increments
unit_code string (191)
unit_name string (191)
base_unit integer
opera string (191)
operation_value double
is_active tinyInteger
created_at timestamps
updated_at timestamps

transfers

id increments
reference_no string (191)
user_id integer
status integer
from_warehouse_id integer
to_warehouse_id integer
item integer
total_qty double
total_tax double
total_cost double
shipping_cost double
grand_total double
document string (191)
note text
created_at timestamps
updated_at timestamps

taxes

id increments
name string (191)
rate double
is_active tinyInteger
created_at timestamps
timestamps timestamps

suppliers

id increments
name string (191)
image string (191)
company_name string (191)
vat_number string (191)
email string (191)
phone_numberemail string (191)
address string (191)
city string (191)
state string (191)
postal_code string (191)
country string (191)
is_active tinyInteger
created_at timestamps
updated_at timestamps

stock_counts

id increments
reference_no string (191)
warehouse_id integer
category_id string (191)
brand_id string (191)
user_id integer
type string (191)
initial_file string (191)
final_file string (191)
note text
is_adjusted tinyInteger
created_at timestamps
updated_at timestamps

sales

id increments
reference_no string (191)
user_id integer
customer_id integer
warehouse_id integer
biller_id integer
item integer
total_qty double
total_discount double
total_tax double
total_price double
grand_total double
order_tax_rate double
order_tax double
order_discount double
coupon_id integer
coupon_discount double
shipping_cost double
sale_status integer
payment_status integer
document string (191)
paid_amount double
sale_note text
staff_note text
created_at timestamps
updated_at timestamps

roles

id increments
name string (191)
description text
guard_name string (191)
is_active tinyInteger
created_at timestamps
updated_at timestamps

role_has_permissions

permission_id integer
role_id integer

returns

id increments
reference_no string (191)
user_id integer
customer_id integer
warehouse_id integer
biller_id integer
account_id integer
item integer
total_qty double
total_discount double
total_tax double
total_price double
order_tax_rate double
order_tax double
grand_total double
document string (191)
return_note text
staff_note text
created_at timestamps
updated_at timestamps

return_purchases

id increments
reference_no string (191)
supplier_id integer
warehouse_id integer
user_id integer
account_id integer
item integer
total_qty double
total_discount double
total_tax double
total_cost double
order_tax_rate double
order_tax double
grand_total double
document string (191)
return_note text
staff_note text
created_at timestamps
updated_at timestamps

quotations

id increments
reference_no string (191)
user_id integer
biller_id integer
supplier_id integer
customer_id integer
warehouse_id integer
item integer
total_qty double
total_discount double
total_tax double
total_price double
order_tax_rate double
order_tax double
order_discount double
shipping_cost double
grand_total double
quotation_status integer
document string (191)
note text
created_at timestamps
updated_at timestamps

purchases

id increments
reference_no string (191)
user_id integer
warehouse_id integer
supplier_id integer
item integer
total_qty double
total_discount double
total_tax double
total_cost double
order_tax_rate double
order_tax double
order_discount double
shipping_cost double
grand_total double
paid_amount double
status integer
payment_status integer
document string (191)
note text
created_at timestamps
updated_at timestamps

purchase_product_return

id increments
return_id integer
product_id integer
qty double
purchase_unit_id integer
net_unit_cost double
discount double
tax_rate double
tax double
total double
created_at timestamps
updated_at timestamps

products

id increments
name string (191)
code string (191)
type string (191)
barcode_symbology string (191)
brand_id integer
category_id integer
unit_id integer
purchase_unit_id integer
sale_unit_id integer
cost string (191)
price string (191)
qty double
alert_quantity double
promotion tinyInteger
promotion_price string (191)
starting_date string (200)
last_date date
tax_id integer
tax_method integer
image string (191)
file string (191)
featured tinyInteger
product_list string (191)
qty_list string (191)
price_list string (191)
product_details text
product_invoice_details text
is_active tinyInteger
created_at timestamps
updated_at timestamps

product_warehouse

id increments
product_id string (191)
warehouse_id integer
qty double
created_at timestamps
updated_at timestamps

product_transfer

id increments
transfer_id integer
product_id integer
qty double
purchase_unit_id integer
net_unit_cost double
tax_rate double
tax double
total double
created_at timestamps
updated_at timestamps

product_sales

id increments
timestamps timestamps
softDeletes softDeletes

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