angkasapos_db - Laravel Schema Designer

users

id_user increments
id_tenant ^FK integer
id_level ^FK integer
user_name string (25)
uname string (25)
passwd string (255)
active enum
last_login datetime
rememberToken rememberToken

level

id_level increments
level_name string (6)

categories

id_category increments
id_tenant ^FK integer
category_name string (25)

units

id_units increments
unit_name string (25)

suppliers

id_supplier increments
id_tenant ^FK integer
timestamps timestamps
softDeletes softDeletes
supplier_name string (25)
supplier_phone string (20)
supplier_address string (100)
supplier_info text

racks

id_rack increments
id_tenant ^FK integer
rack_name string (25)

goods

id_goods increments
id_tenant ^FK integer
id_units ^FK integer
id_category ^FK integer
id_supplier ^FK integer
id_rack ^FK integer
id_stock ^FK integer
id_discount integer
barcode string (25)
goods_name string (25)
selling_price bigInteger
purchase_price bigInteger
timestamps timestamps
deleted enum
softDeletes softDeletes

stocks

id_stock increments
id_tenant ^FK integer
id_rack ^FK integer
id_goods ^FK integer
amount integer

purchase_order

id_po increments
id_tenant ^FK integer
timestamps timestamps
softDeletes softDeletes
id_supplier ^FK integer
id_poitems ^FK integer
id_paytype ^FK integer
po_invoice_num string (25)
amount integer
po_requester string (25)
credit enum

po_items

id_poitems increments
id_tenant ^FK integer
id_goods ^FK integer
amount integer
purchase_price bigInteger

goods_receipt

id_gr increments
id_tenant ^FK integer
id_supplier ^FK integer
id_gritem integer
timestamps timestamps
softDeletes softDeletes
gr_invoice_num string (25)
po_invoice_num string (25)
receiver string (25)

goods_receipt_items

id_gritem increments
id_tenant ^FK integer
id_goods ^FK integer
difference integer
amount integer

payment_types

id_paytype increments
payment_type string (6)

selling

id_selling increments
id_tenant ^FK integer
id_discount ^FK integer
id_paytype ^FK integer
id_sellingitem integer
id_customer integer
timestamps timestamps
softDeletes softDeletes
invoice_num string (26)
paid bigInteger
change bigInteger
debt enum

selling_items

id_sellingitem increments
id_tenant ^FK integer
id_goods ^FK integer
barcode string (25)
goods_name string (25)
amount integer
selling_price bigInteger

customers

id_customer increments
id_tenant ^FK integer
id_discount integer
timestamps timestamps
softDeletes softDeletes
name string (25)
customer_number string (16)
customer_address string (100)
customer_phone string (20)
disable enum

discount

id_discount increments
id_tenant ^FK integer
timestamps timestamps
softDeletes softDeletes
discount_type string (10)
percent smallInteger
expired datetime
disable enum

return_goods

id_rg increments
id_tenant ^FK integer
return_invoice_number string (17)
id_returnitem integer
total_return_price bigInteger
reason text
returnee string (25)

return_items

id_returnitem increments
id_tenant ^FK integer
id_goods ^FK integer
id_paytype ^FK integer
id_supplier ^FK integer
return_date datetime
barcode string (25)
goods_name string (25)
amount integer
purchase_price bigInteger

credits

id_credit increments
id_tenant ^FK integer
timestamps timestamps
softDeletes softDeletes
id_po ^FK integer
credit_num string (18)
credit_due_date datetime
credit_requester string (25)
approved enum
approval string (25)
approved_date datetime
paid_date datetime
paymaster string (25)
status enum

debts

id_debt increments
id_tenant ^FK integer
id_customer ^FK integer
id_selling ^FK integer
timestamps timestamps
softDeletes softDeletes
debt_due_date datetime

debt_billing

id_debtbill increments
id_tenant ^FK integer
timestamps timestamps
softDeletes softDeletes
id_debt ^FK integer
id_customer ^FK integer
billing_invoice_num string (26)
paid bigInteger
paid_date datetime
proof_of_payment string (100)

tenant

id_tenant increments
timestamps timestamps
tenant_name string (25)
tenant_address string (100)
tenant_phone string (20)
expire_date datetime
contract_num string (30)
logo string (25)
active enum
info text

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