To store graph insights from banking fraud detection (covering IDT, SID, ATO) for downstream investigation and mitigation, design a table schema that captures algorithm output, network features, entity context, and traceability links. The schema should support storage of graph metrics, community and cluster data, and allow for extensibility (such as JSON fields) to accommodate evolving analytics.
| Column Name | Data Type | Description |
|---|---|---|
| insight_id | UUID / PK | Unique identifier for each insight |
| entity_id | VARCHAR | Primary node/entity reference (user/account/device/etc.) |
| entity_type | VARCHAR | Type of entity (user, account, device, etc.) |
| insight_type | VARCHAR | Algorithm/category: e.g., 'IDT', 'SID', 'ATO', 'centrality', 'path', 'community', 'anomaly' |