Database Table: SHPMODCLCD

Reserved for IBM internal use.

Column Name Column Type Column Description
CALCODE_ID INTEGER
NOT NULL
Reserved for IBM internal use.
SHIPMODE_ID INTEGER
NULL
Reserved for IBM internal use.
SHPMODCLCD_ID INTEGER
NOT NULL
Reserved for IBM internal use.
STORE_ID INTEGER
NOT NULL
Reserved for IBM internal use.
TRADING_ID BIGINT
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000268 TRADING_ID Non-Unique Index
I0000269 CALCODE_ID Non-Unique Index
I0000270 SHIPMODE_ID Non-Unique Index
I0000271 STORE_ID Non-Unique Index
I0000303 STORE_ID, CALCODE_ID, SHIPMODE_ID, TRADING_ID Unique Index
SQL030416035106010 SHPMODCLCD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_927 CALCODE_ID CALCODE CALCODE_ID Cascade
F_928 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade
F_929 TRADING_ID TRADING TRADING_ID Cascade
F_930 STORE_ID STORE STORE_ID Cascade

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