shipping_invoice - Laravel Schema Designer

shipping_invoices

id increments
user_id integer
billing_invoice_id integer
invoice_no_big string (5)
invoice_no_tiny string (3)
invoice_date date
shipping_from_company_name string (255)
shipping_from_company_address string (255)
shipping_from_company_phone string (255)
shipping_destination_company_name string (255)
shipping_destination_company_address string (255)
shipping_destination_company_phone string (255)
shipping_destination_company_recepient string (255)
is_same_address tinyInteger
status integer
timestamps timestamps
softDeletes softDeletes

shipping_invoice_products

id increments
shipping_invoice_id ^FK integer
shipping_invoice_category_id ^FK integer
product_id integer
qty float
dosp float
adosp string
amz_sf float
amz_ff float
tdosp float
tadosp float
declared_value_in_yen float
total_declared_value_in_yen float
grand_tdosp float
amz_fees float
grand_tasp float
fosr string (255)
simulator_report string (255)
supporting_documents string
timestamps timestamps

shipping_invoice_categories

id increments
name string
status string
timestamps timestamps

shipping_invoice_status

id increments
name string
timestamps timestamps

shipping_invoice_status_log

id increments
shipping_invoice_product_id ^FK integer
shipping_invoice_status_id ^FK integer
status_updated_by integer
timestamps timestamps

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