|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
3d1eaf09-0972-4a10-8b55-26c5149dd21d
|
NoteType.COMMENT
|
|
Historical data archival policy applies to this entity.
|
188
|
75
|
#d35400
|
null
|
a8c773cb-3202-4e3d-b6a7-c62aecbe74c3
|
Note 15
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
305
|
450
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
572f9a1a-4ef5-4224-a86a-9e77013d8b45
|
NoteType.COMMENT
|
|
Monitor for orphaned records in child tables.
|
284
|
83
|
#34495e
|
null
|
13c67bb8-7e58-4a37-bb38-329d4066437e
|
Note 14
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
544
|
119
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.MODEL
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
NoteType.INFO
|
|
SCD Type 2 tracking enabled - monitor for data growth.
|
193
|
82
|
#e67e22
|
null
|
b33dee81-7c27-4c94-9742-e827206b85f0
|
Note 13
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
467
|
199
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.MODEL
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
NoteType.INFO
|
|
Data masking required for non-production environments.
|
220
|
116
|
#3498db
|
null
|
623f549a-f22e-4d1a-bf2e-30e8e5075ad2
|
Note 12
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
175
|
409
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.MODEL
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
NoteType.TODO
|
|
Integration point with external system - monitor for schema changes.
|
187
|
60
|
#9b59b6
|
null
|
79be7916-97bd-4f1e-bd0b-90a1420a319c
|
Note 11
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
315
|
392
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.MODEL
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
NoteType.TODO
|
|
Implement soft delete pattern for data recovery.
|
193
|
70
|
#34495e
|
null
|
4a52fe27-111e-47af-bd0e-4b51f2b80e26
|
Note 10
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
659
|
430
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
955660e7-eb3a-4d5d-8147-895464ca98c3
|
NoteType.TODO
|
|
Consider adding lookup cache for frequently accessed data.
|
216
|
98
|
#27ae60
|
null
|
117aa1db-d09d-42f5-9283-028fb2982ef1
|
Note 9
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
728
|
446
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
eeaba33c-f1cd-4043-94e3-dc7dbfb6654d
|
NoteType.WARNING
|
|
Data masking required for non-production environments.
|
209
|
110
|
#9b59b6
|
null
|
042d796b-4560-42b5-aed3-85f7c8c406c4
|
Note 8
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
467
|
453
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
eeaba33c-f1cd-4043-94e3-dc7dbfb6654d
|
NoteType.COMMENT
|
|
Consider implementing change data capture (CDC).
|
267
|
64
|
#3498db
|
null
|
e19f1e1b-654e-4eef-bde9-b9c5388b9699
|
Note 7
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
299
|
251
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
085501b9-3637-409f-8e54-4976d9bf0c91
|
NoteType.COMMENT
|
|
Review data retention policies before production deployment.
|
254
|
106
|
#9b59b6
|
null
|
515c1296-9725-411e-ba22-fdc8a969745d
|
Note 6
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
553
|
453
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
eacfebcf-498d-4460-bd60-e53cb965c2b1
|
NoteType.WARNING
|
|
PII data - ensure proper encryption and access controls.
|
293
|
68
|
#e74c3c
|
null
|
9166af4d-54a1-4853-bf9e-47b9cd4d9167
|
Note 5
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
104
|
475
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
2b157f29-635e-43b4-8cdc-afd9a456b154
|
NoteType.WARNING
|
|
Implement soft delete pattern for data recovery.
|
203
|
87
|
#16a085
|
null
|
02a4a8d1-8301-42c5-89a5-2b9409854161
|
Note 4
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
120
|
321
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
a281a2c3-cf8f-4bdf-9153-aebd27666974
|
NoteType.INFO
|
|
Indexes may need optimization based on query patterns.
|
199
|
80
|
#9b59b6
|
null
|
420a0883-7f94-47f2-a053-fdfc516e79d4
|
Note 3
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
212
|
345
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
709d94e4-2e02-435d-81f6-b1a674ccaa07
|
NoteType.INFO
|
|
Consider implementing change data capture (CDC).
|
293
|
112
|
#3498db
|
null
|
e97c6302-7404-4831-9fff-d930f25312e6
|
Note 2
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
100
|
583
|
|
fdfba917-095a-475f-a6f0-fda874b60e87
|
LinkTarget.ENTITY
|
948c36d1-050d-432a-9f2c-30061f78c860
|
NoteType.FIXME
|
|
Historical data archival policy applies to this entity.
|
248
|
80
|
#34495e
|
null
|
1b592f10-3d3c-4cd9-94a8-01bb0ca73038
|
Note 1
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:33
|
2026-01-03 15:41:33
|
1
|
|
120
|
178
|
|
00000000-demo-enrg-mod2-000000000001
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod2-000000000001
|
NoteType.FIXME
|
|
Data refresh frequency should be increased from daily to hourly for real-time analytics dashboards
|
200
|
80
|
#c0392b
|
null
|
00000000-demo-enrg-note-000000000006
|
Data Refresh Frequency Fix
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-enrg-mod1-000000000005
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod1-000000000005
|
NoteType.INFO
|
|
Emissions model tracks CO2 and GHG emissions for ESG reporting. Follows GHG Protocol standards for S...
|
230
|
90
|
#2ecc71
|
null
|
00000000-demo-enrg-note-000000000005
|
Emissions ESG Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-enrg-mod1-000000000004
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod1-000000000004
|
NoteType.TODO
|
|
Integrate battery storage optimization algorithms with demand response signals
|
200
|
70
|
#9b59b6
|
null
|
00000000-demo-enrg-note-000000000004
|
Battery Storage TODO
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-enrg-mod1-000000000003
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod1-000000000003
|
NoteType.WARNING
|
|
Consumption model contains customer meter data which is PII under GDPR. Smart meter readings can rev...
|
220
|
100
|
#f39c12
|
null
|
00000000-demo-enrg-note-000000000003
|
Consumption Data Warning
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-enrg-mod1-000000000002
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod1-000000000002
|
NoteType.INFO
|
|
Grid transport model captures real-time power flow data from smart grid sensors. Includes transmissi...
|
240
|
90
|
#27ae60
|
null
|
00000000-demo-enrg-note-000000000002
|
Grid Transport Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-enrg-mod1-000000000001
|
LinkTarget.MODEL
|
00000000-demo-enrg-mod1-000000000001
|
NoteType.INFO
|
|
Production forecasting model uses ML-based predictions for renewable energy generation. Data from so...
|
240
|
100
|
#3498db
|
null
|
00000000-demo-enrg-note-000000000001
|
Production Forecasting Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-ecom-mod1-000000000003
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod1-000000000003
|
NoteType.FIXME
|
|
Order status transitions need to be tracked with timestamps for SLA monitoring
|
200
|
70
|
#c0392b
|
null
|
00000000-demo-ecom-note-000000000006
|
Order Status Tracking Fix
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
250
|
50
|
|
00000000-demo-ecom-mod2-000000000001
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod2-000000000001
|
NoteType.TODO
|
|
Implement customer lifetime value (CLV) calculation and RFM segmentation in analytics layer
|
200
|
80
|
#9b59b6
|
null
|
00000000-demo-ecom-note-000000000005
|
CLV Analytics TODO
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-ecom-mod1-000000000003
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod1-000000000003
|
NoteType.WARNING
|
|
Payment model is PCI-DSS scope. Card numbers must be tokenized via payment gateway. Never store CVV ...
|
210
|
100
|
#e74c3c
|
null
|
00000000-demo-ecom-note-000000000004
|
Payment PCI-DSS Warning
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-ecom-mod1-000000000003
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod1-000000000003
|
NoteType.INFO
|
|
Order model tracks complete order lifecycle from cart to delivery. Shipping addresses are PII and re...
|
220
|
90
|
#27ae60
|
null
|
00000000-demo-ecom-note-000000000003
|
Order Lifecycle Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-ecom-mod1-000000000002
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod1-000000000002
|
NoteType.WARNING
|
|
Customer model contains PII data subject to GDPR including name, email, address, and phone. Implemen...
|
230
|
100
|
#f39c12
|
null
|
00000000-demo-ecom-note-000000000002
|
Customer PII Warning
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-ecom-mod1-000000000001
|
LinkTarget.MODEL
|
00000000-demo-ecom-mod1-000000000001
|
NoteType.INFO
|
|
Product model includes SKU management, pricing, categories, and inventory levels. Supports multiple ...
|
240
|
100
|
#3498db
|
null
|
00000000-demo-ecom-note-000000000001
|
Product Model Overview
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:30
|
2026-01-03 15:41:30
|
1
|
|
50
|
50
|
|
00000000-demo-bank-mod2-000000000001
|
LinkTarget.ENTITY
|
00000000-demo-bank-e201-000000000008
|
NoteType.COMMENT
|
|
Session data retained for 90 days per security policy. Consider partitioning by login date.
|
200
|
80
|
null
|
null
|
00000000-demo-bank-note-000000000012
|
Session Data Retention
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
100
|
450
|
|
00000000-demo-bank-mod5-000000000001
|
LinkTarget.MODEL
|
00000000-demo-bank-mod5-000000000001
|
NoteType.INFO
|
|
Gold layer: Business-ready aggregates for reporting and analytics. Refreshed daily at 6 AM UTC.
|
230
|
80
|
#ffd700
|
null
|
00000000-demo-bank-note-000000000011
|
Gold Layer Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
50
|
50
|
|
00000000-demo-bank-mod4-000000000001
|
LinkTarget.MODEL
|
00000000-demo-bank-mod4-000000000001
|
NoteType.TODO
|
|
Implement SCD Type 2 for customer dimension to track historical changes
|
220
|
70
|
#9b59b6
|
null
|
00000000-demo-bank-note-000000000010
|
SCD Type 2 TODO
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
50
|
50
|
|
00000000-demo-bank-mod3-000000000001
|
LinkTarget.MODEL
|
00000000-demo-bank-mod3-000000000001
|
NoteType.INFO
|
|
Bronze layer: Raw data ingestion with minimal transformation. Preserves source structure for auditin...
|
240
|
80
|
#cd7f32
|
null
|
00000000-demo-bank-note-000000000009
|
Bronze Layer Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
50
|
50
|
|
00000000-demo-bank-mod1-000000000001
|
LinkTarget.ATTRIBUTE
|
00000000-demo-bank-a101-000000000006
|
NoteType.WARNING
|
|
National ID is a direct PII identifier. Apply column-level encryption and audit logging.
|
200
|
70
|
#e74c3c
|
null
|
00000000-demo-bank-note-000000000008
|
National ID Security
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
300
|
120
|
|
00000000-demo-bank-mod1-000000000001
|
LinkTarget.RELATIONSHIP
|
00000000-demo-bank-r101-000000000001
|
NoteType.INFO
|
|
Customer can have multiple addresses (home, work, correspondence). Primary address is flagged.
|
200
|
70
|
null
|
null
|
00000000-demo-bank-note-000000000007
|
Multiple Addresses Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
350
|
100
|
|
00000000-demo-bank-mod2-000000000001
|
LinkTarget.ENTITY
|
00000000-demo-bank-e201-000000000014
|
NoteType.FIXME
|
|
CARD_NO_HASH should use SHA-256, current implementation uses MD5 which is deprecated
|
220
|
80
|
#c0392b
|
null
|
00000000-demo-bank-note-000000000006
|
Card Hash Algorithm Fix
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
600
|
650
|
|
00000000-demo-bank-mod2-000000000001
|
LinkTarget.ENTITY
|
00000000-demo-bank-e201-000000000001
|
NoteType.TODO
|
|
Add CDC (Change Data Capture) configuration for real-time replication to DWH
|
200
|
70
|
#9b59b6
|
null
|
00000000-demo-bank-note-000000000005
|
CDC Configuration TODO
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
100
|
50
|
|
00000000-demo-bank-mod2-000000000001
|
LinkTarget.MODEL
|
00000000-demo-bank-mod2-000000000001
|
NoteType.INFO
|
|
IT Landscape model shows physical source systems. CBS is the system of record for customer and accou...
|
240
|
80
|
#27ae60
|
null
|
00000000-demo-bank-note-000000000004
|
IT Landscape Info
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
50
|
50
|
|
00000000-demo-bank-mod1-000000000001
|
LinkTarget.ENTITY
|
00000000-demo-bank-e101-000000000009
|
NoteType.WARNING
|
|
Card entity contains PCI-DSS regulated data. Card numbers must be tokenized and CVV must never be st...
|
200
|
90
|
#e74c3c
|
null
|
00000000-demo-bank-note-000000000003
|
Card PCI-DSS Warning
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
600
|
450
|
|
00000000-demo-bank-mod1-000000000001
|
LinkTarget.ENTITY
|
00000000-demo-bank-e101-000000000001
|
NoteType.WARNING
|
|
Customer entity contains PII data subject to GDPR. Ensure data masking in non-production environment...
|
220
|
100
|
#f39c12
|
null
|
00000000-demo-bank-note-000000000002
|
Customer PII Warning
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
100
|
50
|
|
00000000-demo-bank-mod1-000000000001
|
LinkTarget.MODEL
|
00000000-demo-bank-mod1-000000000001
|
NoteType.INFO
|
|
This semantic model represents the business-level view of retail banking domain. It serves as the ca...
|
250
|
100
|
#3498db
|
null
|
00000000-demo-bank-note-000000000001
|
Semantic Model Overview
|
null
|
00000000-demo-user-0000-000000000001
|
00000000-demo-user-0000-000000000001
|
2026-01-03 15:41:28
|
2026-01-03 15:41:28
|
1
|
|
50
|
50
|