| Insurance Data Model |
Description | A summary table which stores the individual customer values at category level, which will be used in segmenting the customer. |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
Column Details |
Description | Unique Customer ID |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique ID identifies the category of the entry |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique ID identifies the sub category of the entry |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The percentage of the particular sub category respective to the customer |
Data Type | DECIMAL(5 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
| Insurance Data Model |