---
# System prepended metadata

title: Database Anonymization

---

# Database Anonymization

## Fields that need to be anonymized and their types

### Tenant Table


| Column | Type |
| -------- | -------- |
| name     | String     |
| slug     | String     |

### ServiceProvider Table


| Column | Type |
| -------- | -------- |
| name     | String     |
| slug     | String     |


### ServiceProviderCredentialIssuerConfiguration Table


| Column | Type |
| -------- | -------- |
| tokenEndpoint     | String     |
| token     | String     |
| redirectUrl     | String     |


### Identifier Table

| Column | Type |
| -------- | ------- |
| alias    | String     |

### Credential Table

| Column  | Type |
| --------| -----|
| data    | json |

Only some changes need to be anonymized, because it's a json field

```
{
    "id": "urn:uuid:3b974556-37f4-47c1-ab98-3205bb2930da",
    "type": [
        "VerifiableCredential",
        "DSCSAATPCredential"
    ],
    "proof": {
        "jws": "ANONYMIZED",
        "type": "Ed25519Signature2018",
        "created": "2022-04-11T12:48:27Z",
        "proofPurpose": "assertionMethod",
        "verificationMethod": ANONYMIZED"
    },
    "issuer": "did:key:z6MkjoZCDjCDqy49ruK6VMDpJV5SqqmpbQ1bmFDgvUZSBnEW",
    "@context": [
        "https://www.w3.org/2018/credentials/v1",
        "https://open-credentialing-initiative.github.io/schemas/credentials/DSCSAATPCredential-v1.0.0.jsonld",
        "https://spherity.github.io/vc-status-2021-ldap/contexts/vc-status-2021-ldap/v1.jsonld"
    ],
    "issuanceDate": "2022-04-11T12:48:27.276Z",
    "expirationDate": "2023-04-11T12:48:27.268Z",
    "credentialSubject": {
        "id": "did:key:z6MkrwsZPz7dHByAdTE9YhkCBep8twVsrr8WmoZUnTXyti5D",
        "type": "DSCSAATPCredential",
        "legalName": "ANONYMIZED",
        "identifier": "ANONYMIZED",
        "issuerName": "ANONYMIZED",
        "postalCode": "ANONYMIZED",
        "addressRegion": "ANONYMIZED",
        "streetAddress": "ANONYMIZED",
        "addressCountry": "ANONYMIZED",
        "addressLocality": "ANONYMIZED",
        "organizationType": "ANONYMIZED"
    }
}
```
### Invitation Table

| Column  | Type |
| --------| -----|
| invitedBy    | String |
| email    | String |
| usedBy    | String |
| secret    | String |

### Onboarding Table

| Column  | Type |
| --------| -----|
| userId   | String |

### TradingPartner Table

| Column  | Type |
| --------| -----|
| legalName    | String |
| streetAddress    | String |
| addressLocality    | String |
| addressRegion    | String |
| addressCountry    | String |
| postalCode    | String |
| parentOrganization    | String |

### PresentationEvent Table

| Column  | Type |
| --------| -----|
| data    | json |

Only some changes need to be anonymized, because it's a json field.
Also keep in mind the data for a `verification` event and `generation` event are is different.

**VERIFICATION EVENT**

    "vp": {
        "type": [
            "VerifiablePresentation"
        ],
        "@context": [
            "https://www.w3.org/2018/credentials/v1"
        ],
        "verifiableCredential": [
            {
                "id": "urn:uuid:590bd6b9-6a4b-43a0-bfbf-5b6d4b23fc9b",
                "type": [
                    "VerifiableCredential",
                    "DSCSAATPCredential"
                ],
                "proof": {
                    "jws": "ANONYMIZED",
                    "type": "Ed25519Signature2018",
                    "created": "2022-04-11T12:50:49Z",
                    "proofPurpose": "assertionMethod",
                    "verificationMethod": "ANONYMIZED"
                },
                "issuer": "did:key:z6Mkrhhctb4LKfTJcWtXpe1dk9AgGnv5MESjkjh8zKNHgsYZ",
                "@context": [
                    "https://www.w3.org/2018/credentials/v1",
                    "https://open-credentialing-initiative.github.io/schemas/credentials/DSCSAATPCredential-v1.0.0.jsonld",
                    "https://spherity.github.io/vc-status-2021-ldap/contexts/vc-status-2021-ldap/v1.jsonld"
                ],
                "issuanceDate": "2022-04-11T12:50:49.961Z",
                "expirationDate": "2023-04-11T12:50:49.949Z",
                "credentialSubject": {
                    "id": "did:key:z6MkpDSfe4ik6sWC49H1VfgzRC9SYUQR9ywrB91TXo8xDnic",
                    "type": "DSCSAATPCredential",
                    "legalName": "ANONYMIZED",
                    "identifier": "ANONYMIZED",
                    "issuerName": "ANONYMIZED",
                    "postalCode": "ANONYMIZED",
                    "addressRegion": "ANONYMIZED",
                    "streetAddress": "ANONYMIZED",
                    "addressCountry": "ANONYMIZED",
                    "addressLocality": "ANONYMIZED",
                    "organizationType": "ANONYMIZED"
                }
            }
        ]
    },
    "exp": 1681217449,
    "iat": 1661582950,
    "iss": "did:key:z6MkpDSfe4ik6sWC49H1VfgzRC9SYUQR9ywrB91TXo8xDnic",
    "nbf": 1649681449,
    "nonce": "d3e1e39d-e84c-4cdd-89f9-8a346f8f2a6d",
    "issuanceDate": "2022-08-27T06:49:10.951Z"


**GENERATION EVENT**

    "iat": 1661582947,
    "nbf": 1649681307,
    "type": [
        "VerifiablePresentation"
    ],
    "nonce": "d3e1e39d-e84c-4cdd-89f9-8a346f8f2a6d",
    "proof": {
        "jwt": "ANONYMIZED",
        "type": "JwtProof2020"
    },
    "holder": "did:key:z6MkrwsZPz7dHByAdTE9YhkCBep8twVsrr8WmoZUnTXyti5D",
    "@context": [
        "https://www.w3.org/2018/credentials/v1"
    ],
    "issuanceDate": "2022-08-27T06:49:07.600Z",
    "expirationDate": "2023-04-11T12:48:27.000Z",
    "verifiableCredential": [
        {
            "id": "urn:uuid:3b974556-37f4-47c1-ab98-3205bb2930da",
            "type": [
                "VerifiableCredential",
                "DSCSAATPCredential"
            ],
            "proof": {
                "jws": "ANONYMIZED",
                "type": "Ed25519Signature2018",
                "created": "2022-04-11T12:48:27Z",
                "proofPurpose": "assertionMethod",
                "verificationMethod": "ANONYMIZED"
            },
            "issuer": "did:key:z6MkjoZCDjCDqy49ruK6VMDpJV5SqqmpbQ1bmFDgvUZSBnEW",
            "@context": [
                "https://www.w3.org/2018/credentials/v1",
                "https://open-credentialing-initiative.github.io/schemas/credentials/DSCSAATPCredential-v1.0.0.jsonld",
                "https://spherity.github.io/vc-status-2021-ldap/contexts/vc-status-2021-ldap/v1.jsonld"
            ],
            "issuanceDate": "2022-04-11T12:48:27.276Z",
            "expirationDate": "2023-04-11T12:48:27.268Z",
            "credentialSubject": {
                "id": "did:key:z6MkrwsZPz7dHByAdTE9YhkCBep8twVsrr8WmoZUnTXyti5D",
                "type": "DSCSAATPCredential",
                "legalName":  "ANONYMIZED",
                "identifier":  "ANONYMIZED",
                "issuerName":  "ANONYMIZED",
                "postalCode":  "ANONYMIZED",
                "addressRegion":  "ANONYMIZED",
                "streetAddress":  "ANONYMIZED",
                "addressCountry":  "ANONYMIZED",
                "addressLocality":  "ANONYMIZED",
                "organizationType": "Test Organization Type"
            }
        }
    ]