STOREDEF

Each row of this table contains default information for a Store.

Column Descriptions:

NameTypeDescription
STORE_IDINTEGER NOT NULLThe Store.
CONTRACT_IDBIGINTThe default Contract for the Store.
SHIPMODE_IDINTEGERThe default ShippingMode for the Store.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STORE_IDPrimary Key
I0000785CONTRACT_IDNon-Unique Index
I0000786SHIPMODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_786STORE_IDSTORESTORE_IDCascade
F_787SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_788CONTRACT_IDCONTRACTCONTRACT_IDCascade