kopkar-polyrama - Laravel Schema Designer

categories

id increments
description string (255)
created_by integer
updated_by integer
timestamps timestamps

products

id increments
productcollection_id ^FK integer
position integer
purchase_price decimal (18,2)
margin decimal (5,2)
selling_price decimal (18,2)
stock decimal (10,2)
unit_quantity string (255)
min_quantity integer
quantity_increment integer
sku string (255)
gtin string (255)
mpn string (255)
ean string (255)
length_value decimal (10,4)
width_value decimal (10,4)
height_value decimal (10,4)
weight_value decimal (10,4)
volume_value decimal (10,4)
length_unit string (255)
width_unit string (255)
height_unit string (255)
weight_unit string (255)
volume_unit string (255)
description text
timestamps timestamps
updated_by integer
created_by integer

cart_lines

id bigIncrements
product_id ^FK integer
qty decimal (10,2)
price decimal (18,2)
amount decimal (18,2)
discount decimal (18,2)
total_amount decimal (18,2)
grand_total decimal (18,2)
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

cashiers

id bigIncrements
cashiercash_id ^FK bigInteger
status_process enum
cashier_number string (15)
transaction_date date
total_item integer
total_amount decimal (18,2)
total_discount decimal (18,2)
grand_total decimal (18,2)
created_by integer
payment_method enum
updated_by integer
timestamps timestamps

cashier_cash

id bigIncrements
transaction_date date
status enum
cash_open decimal (18,2)
cash_closed decimal (18,2)
cash_actual decimal (18,2)
created_by integer
updated_by integer
timestamps timestamps

cashier_lines

id bigIncrements
cashier_id ^FK bigInteger
product_id ^FK integer
qty decimal (10,2)
price decimal (18,2)
amount decimal (18,2)
discount decimal (18,2)
total_amount decimal (18,2)
qty_return decimal (10,2)
amount_return decimal (18,2)
grand_total decimal (18,2)
created_by integer
updated_by integer
timestamps timestamps

orders

id bigIncrements
order_number string (15)
order_date date
total_item integer
total_amount decimal (18,2)
total_discount decimal (18,2)
grand_total decimal (18,2)
created_by integer
payment_method enum
updated_by integer
timestamps timestamps

order_lines

id bigIncrements
order_id ^FK bigInteger
product_id ^FK integer
qty decimal (10,2)
price decimal (18,2)
amount decimal (18,2)
discount decimal (18,2)
total_amount decimal (18,2)
qty_return decimal (10,2)
amount_return decimal (18,2)
grand_total decimal (18,2)
created_by integer
updated_by integer
timestamps timestamps

stocks

id increments
product_id ^FK integer
location_id ^FK integer
expired_date date
stock decimal (10,2)
created_by integer
updated_by integer
timestamps timestamps

locations

id increments
description string (255)
created_by integer
updated_by integer
timestamps timestamps

pre_orders

id increments
product_id ^FK integer
qty decimal (10,2)
created_by integer
updated_by integer
timestamps timestamps
added_to_pr boolean

purchase_lines

id bigIncrements
product_id ^FK integer
purchaserequest_id ^FK bigInteger
qty decimal (10,5)
price decimal (18,2)
amount decimal (18,2)
added_to_pr boolean
created_by integer
updated_by integer
timestamps timestamps

medias

id increments
product_id ^FK integer
media_name string (255)
media_path string (255)
position integer
created_by integer
updated_by integer
timestamps timestamps

brands

id increments
description string (255)
created_by integer
updated_by integer
timestamps timestamps

product_collections

id increments
category_id ^FK integer
brand_id ^FK integer
description text
status enum
created_by integer
updated_by integer
timestamps timestamps

purchases

id bigIncrements
pr_number string (20)
pr_date date
po_number string (20)
po_date date
created_by integer
updated_by integer
timestamps timestamps

plafonds

id increments
no_anggota string (10)
plafond_limit decimal (18,2)
allocated decimal (18,2)
balance decimal (18,2)
period_start date
period_end date
is_active boolean
created_by integer
updated_by integer
timestamps timestamps

plafond_transactions

id increments
refference_number string (15)
created_by integer
updated_by integer
timestamps timestamps

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