FFS_CATALOG_SCHEMA

Contains lists of custom fields available for particular catalogs.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: DATA

Primary Key

Name	Columns
FFS_CATALOG_SCHEMA_PK	SCHEMA_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SCHEMA_ID	NUMBER		10	Yes	Unique identifier of catalog schema.
CATALOG_ID	NUMBER		10	Yes	Reference to corresponding FFS_CATALOG the catalog schema belongs to.
LABEL	VARCHAR2	240			Short text identifier if the item field.
NAME	VARCHAR2	400			Name of the item field to be shown in user interface.
PROPERTY_LABEL	VARCHAR2	160			Short text identifier of the property represented by this item field.
SEARCHABLE	NUMBER		1		Flag. Marks field as full-text searchable.
PREVIEW	NUMBER		1		Flag. Marks field as required to display in offline mode and in preview item card.
CATALOG_SCM_MAP_ID	NUMBER		10		Reference to corresponding FFS_CATALOG_SCM_MAP or NULL.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
FFS_CATALOG_SCHEMA_PK	Unique	DATA	SCHEMA_ID
FFS_CATALOG_SCHEMA_U1	Unique	DATA	CATALOG_ID, LABEL