Azure SQL database
How Azure SQL stores extracted document data and hosts the stored procedures used for data cleansing.
Overview
Azure SQL is the primary relational database of the platform. It stores all structured data extracted from refugee documents by Azure Document Intelligence, and hosts the stored procedures that implement the data cleansing business rules.
Tables
Each document type maps to its own set of tables — one for the document record itself, and one for its associated family members:
| Document Type | Tables |
|---|---|
| Master Card | front-master-card, front-master-card-family-members |
| Red Cross Card | red-cross-card, red-cross-family-members |
| Index Card | (Not yet implemented) |
Stored Procedures
Business rule cleansing is implemented as stored procedures and executed by the Data Cleansing Azure Function after extraction. Each SP targets specific fields and applies the normalization logic defined by the business team (e.g. country code expansion, special character removal from codes).
Access
The database can be accessed and inspected directly via SQL Server Management Studio (SSMS) or any compatible SQL client connected to the Azure SQL server.