Shipment

Shipments are children of transactions which record movement of material.

shipment_id

primary key

transaction_id

Foreign key —> transaction

container_id

Foreign key —> container

packed_by_agent_id

Foreign key —> agent

The agent handling the material.

shipped_carrier_method

Foreign key —> ctshipped_carrier_method

carriers_tracking_number

Identifier (ideally URL) provided by the carrier.

shipped_date

Date

package_weight

text; include units as necessary

hazmat_fg

yes/no

insured_for_insured_value

Numeric, assume USD

shipment_remarks

Elaborate here

contents

Describe

foreign_shipment_fg

yes/no

shipped_to_addr_id

Foreign key —> agent_attribute

shipped_from_addr_id

Foreign key —> agent_attribute

shipment_type

Foreign key —> ctshipment_type

Edit this Documentation

If you see something that needs to be edited in this document, you can create an issue using the link under the search widget at the top left side of this page, or you can edit directly here.