s_list_shipment table - SuperOffice

s_list_shipment Table (348)

A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
list_id	Reference to the list	FK s_list	No
shipment_id	Reference to the shipment	FK s_shipment	No
type	Indicates if this is a static/dynamic spmlist or a selection	Int	Yes
status	Status of shipment list	Enum ShipmentListStatus	Yes

Indexes

Fields	Types	Description
list_id	FK	Index
shipment_id	FK	Index

Relationships

Table	Description
s_list	A list, dynamic or static
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

s_list table s_shipment table Enum values for ShipmentListStatus ShipmentType table ShipmentTypeReservation table s_shipment_addr table

⌘I