# 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"
}
}
]