| Insurance Data Model |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Foreign Key | |
![]() |
|
![]() |
Primary Key | |
![]() |
Column Details |
Description | The unique identifier of the Top level financial services agreement |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | CHAR(5) |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | TIMESTAMP |
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 unique identifier of the Coverage component |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE |
Child Role Name | Verb1 |
Child Multiplicity | * |
Key Column | INSURANCE_POLICY_ID [BIGINT] |
Parent Table | INSURANCE_POLICY |
Parent Multiplicity | 1 |
Unique Constraint | INSURANCE_POLICY_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE |
Child Role Name | Verb3 |
Child Multiplicity | * |
Key Column | COVERAGE_COMPONENT_ID [BIGINT] |
Parent Table | COVERAGE_COMPONENT |
Parent Multiplicity | 1 |
Unique Constraint | COVERAGE_COMPONENT_PK |
Primary Key Details |
Member | INSURANCE_POLICY_ID [BIGINT] |
Member | COVERAGE_COMPONENT_ID [BIGINT] |
Member | NATURE_ID [CHAR(5)] |
Member | EFFECTIVE_FROM_DATE [TIMESTAMP] |
| Insurance Data Model |