Database Table: SHPARJURGP

Each row of this table indicates that a ShippingArrangement applies to all OrderItems whose shipping addresses match a ShippingJurisdictionGroup. Refer to SHPARRANGE.FLAGS.

Column Name Column Type Column Description
JURSTGROUP_ID INTEGER
NOT NULL
The ShippingJurisdictionGroup.
SHPARRANGE_ID INTEGER
NOT NULL
The ShippingArrangement.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035104980 SHPARRANGE_ID, JURSTGROUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_746 JURSTGROUP_ID JURSTGROUP JURSTGROUP_ID Cascade
F_747 SHPARRANGE_ID SHPARRANGE SHPARRANGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable