| BANKING Data Model |
Description | Transaction Fact is a fact table recording the key measures relating to Transactions. |
Primary Key | |
![]() |
Indexes | |
![]() |
|
![]() |
Column Details |
Description | The unique identifier of the Calendar Date Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Channel Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Customer Dimension. |
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 | The unique identifier of the Account Arrangement Dimension |
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 | The unique identifier of the Geographic Area Dimension. |
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 | The unique identifier applied to the Transaction. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that indicates the transaction amount. Negative amount indicates the debits/expense and Positive amount indicates the credits/income. |
Data Type | DECIMAL(20 , 5) |
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 Transaction Time dimension. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that indicates the running account balance of the indiviual customer. |
Data Type | DECIMAL(20 , 5) |
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 cash flow pattern dimension. |
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 |
Foreign Key Details |
Description | The unique identifier of the Calendate Date dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CALENDAR_DATE_DIMENSION_PK |
Description | The unique identifier of the channel dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | CHANNEL_DIMENSION_ID [BIGINT] |
Parent Table | CHANNEL_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CHANNEL_DIMENSION_PK |
Description | The unique dimension of the geographic area dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | GEOGRAPHIC_AREA_DIMENSION_ID [BIGINT] |
Parent Table | GEOGRAPHIC_AREA_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | GEOGRAPHIC_AREA_DIMENSION_PK |
Description | The unique identifier of the Individual Customer dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Description | The unique identifier of the transaction time dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | TRANSACTION_TIME_DIMENSION_ID [INTEGER] |
Parent Table | TRANSACTION_TIME_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | TRANSACTION_TIME_DIMENSION_PK |
Description | The unique identifier of the Transaction Type dimension. |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | TRANSACTION_TYPE_DIMENSION_ID [BIGINT] |
Parent Table | TRANSACTION_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | TRANSACTION_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Transaction Fact. |
Member | TRANSACTION_ID [BIGINT] |
Index Details |
Is Unique | false |
Is Clustered | false |
Is Unique | true |
Is Clustered | false |
Member | TRANSACTION_ID [BIGINT] Ascending |
| BANKING Data Model |