WebSphere Commerce database table: SHPMODEDSC
Each row of this table contains language-dependent information about a ShippingMode.
Column Descriptions
| Column Name
| Column Type
| Description |
| SHIPMODE_ID
| INTEGER NOT NULL
| The ShippingMode.
|
| LANGUAGE_ID
| INTEGER NOT NULL
| The Language. For a list of language components, see the LANGUAGE table.
|
| DESCRIPTION
| VARCHAR(254)
| A brief description of the ShippingMode, suitable for display to a customer for selection.
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| FIELD2
| VARCHAR(254)
| Customizable.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235250970
| SHIPMODE_ID+LANGUAGE_ID
| Primary Key
|
Constraints
| Constraint Name
| Column Names
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_756
| LANGUAGE_ID
| LANGUAGE
| LANGUAGE_ID
| Cascade
|
| F_755
| SHIPMODE_ID
| SHIPMODE
| SHIPMODE_ID
| Cascade
|
Related reference