SVC_CATEGORIES_CF

Column flattening table for categories hierachy

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SVC_CATEGORIES_CF_PK	CATEG

Columns

Name	Datatype	Length	Not-null	Comments
CATEG	NUMBER		Yes	Unique identifier of the category in column flatten structure
PATH1	VARCHAR2	4000		PATH1 from root to node. renamed as certain selects fail when using path as column name
LEV	NUMBER			The level of the category in column flatten structure
LVL0_CAT_ID	NUMBER			Unique identifier of the base level category in column flatten structure
LVL1_CAT_ID	NUMBER			Unique identifier of the 1st level category in column flatten structure
LVL2_CAT_ID	NUMBER			Unique identifier of the 2nd level category in column flatten structure
LVL3_CAT_ID	NUMBER			Unique identifier of the 3rd level category in column flatten structure
LVL4_CAT_ID	NUMBER			Unique identifier of the 4th level category in column flatten structure
LVL5_CAT_ID	NUMBER			Unique identifier of the 5th level category in column flatten structure
LVL6_CAT_ID	NUMBER			Unique identifier of the 6th level category in column flatten structure
LVL7_CAT_ID	NUMBER			Unique identifier of the 7th level category in column flatten structure
LVL8_CAT_ID	NUMBER			Unique identifier of the 8th level category in column flatten structure
LVL9_CAT_ID	NUMBER			Unique identifier of the 9th level category in column flatten structure
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created 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
SVC_CATEGORIES_CF_U1	Unique	Default	CATEG