DIREKT Data Dictionary¶
This dictionary sets naming and sensitivity rules. Detailed columns are finalized with migrations.
| Domain field | Type/format | Sensitivity | Rule |
|---|---|---|---|
user_id |
UUID | Internal | opaque |
phone_e164 |
string | Personal | encrypted/protected, masked |
email_normalized |
string | Personal | normalized, protected |
provider_id |
UUID | Internal | stable |
display_name |
string | Public after moderation | versioned |
provider_type |
enum | Public | sole trader/business/organization |
operating_model |
enum | Public | fixed/mobile/hybrid |
public_location |
PostGIS point/area | Public/coarsened | consent and precision |
private_location |
PostGIS point/address | Sensitive | restricted |
service_area |
geometry/place set | Public | provider-declared unless checked |
verification_check_type |
enum/key | Operational/public summary | controlled taxonomy |
verification_status |
enum | Operational/public subset | state machine |
evidence_object_key |
string | Highly sensitive | private storage |
decision_reason_code |
key | Restricted/public mapped copy | controlled |
amount_minor |
bigint | Financial | no floating point |
currency |
ISO code | Financial | initially ZMW |
audit_actor_id |
UUID/system | Restricted | immutable event |
occurred_at |
timestamptz | Internal | UTC |
Classification¶
- Public
- Internal
- Personal
- Sensitive
- Highly sensitive/restricted
- Financial
- Security secret
Every new field requires purpose, classification, retention, visibility and audit consideration.