Table SEGMENT_SUMMARY

DescriptionA summary table which stores the individual customer values at category level, which will be used in segmenting the customer.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CATEGORY_IDCATEGORY_ID
SUB_CATEGORY_IDSUB_CATEGORY_ID
PERCENTAGEPERCENTAGE

Column Details

 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionUnique Customer ID
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_ID
DescriptionUnique ID identifies the category of the entry
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUB_CATEGORY_ID
DescriptionUnique ID identifies the sub category of the entry
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERCENTAGE
DescriptionThe percentage of the particular sub category respective to the customer
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse