Reference > Database > WebSphere Commerce database tables > J
WebSphere Commerce database table: JURSTGROUP
Each row in this table represents an instance of a particular subclass of JurisdictionGroup. A JurisdictionGroup of a particular subclass is a grouping of Jurisdiction definitions of that subclass.
Column Name Column Type Description JURSTGROUP_ID INTEGER NOT NULL Generated unique key. DESCRIPTION VARCHAR(254) A brief description of the JurisdictionGroup, suitable for display in a user interface that manages JurisdictionGroups. SUBCLASS INTEGER NOT NULL Indicates the JurisdictionGroup subclass...
1 = ShippingJurisdictionGroup.
2 = TaxJurisdictionGroup.STOREENT_ID INTEGER NOT NULL The StoreEntity associated with this JurisdictionGroup. CODE CHAR(30) NOT NULL A code which, together with its StoreEntity and SubClass, uniquely identifies this JurisdictionGroup. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000143 CODE+STOREENT_ID+SUBCLASS Unique Index SQL100520030349430 JURSTGROUP_ID Primary Key I0000602 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_412 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_411 JURSTGROUP_ID JURSTGPREL JURSTGROUP_ID Cascade F_746 JURSTGROUP_ID SHPARJURGP JURSTGROUP_ID Cascade F_752 JURSTGROUP_ID SHPJCRULE JURSTGROUP_ID Cascade F_822 JURSTGROUP_ID TAXJCRULE JURSTGROUP_ID Cascade
Related reference
- Ship data model
- Calculation rule - tax data model
- Calculation rule - shipping data model
- Jurisdiction data model
_vcc_freeselect_bottom_