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.
OPTCOUNTERSMALLINTThe 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