STOREDEFCAT

This table holds the relationship between store and the default catalog.

Column Descriptions:

NameTypeDescription
STOREDEFCAT_IDBIGINT NOT NULLThe primary key.
STOREENT_IDINTEGER NOT NULLThe reference number of the store.
CATALOG_IDBIGINT NOT NULLThe reference number of the default catalog for this store.
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (256)Customizable field.
FIELD3VARCHAR (256)Customizable field.
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
P_0001STOREDEFCAT_IDPrimary Key
I0001439STOREENT_ID+CATALOG_IDNon-Unique Index
I0001440CATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3714CATALOG_IDCATALOGCATALOG_IDCascade
F_3715STOREENT_IDSTOREENTSTOREENT_IDCascade