Database overview

Table structure

The following diagram describes the structure of the relational database within idOS nodes, as well as the data types for all columns.

Data schema

The following table describes the data schema for all table columns.
Table
Column
Schema
Example
humans
id
UUIDv4
fd227c4f-59db-4bf7-853a-203f162e2eb6
attributes
id
UUIDv4
b9cce79d-ef5b-4d78-bfbb-0c3778162d34
human_id
UUIDv4
fd227c4f-59db-4bf7-853a-203f162e2eb6
key
short string
email_address
value
long string
wallets
id
UUIDv4
8c365c0d-023d-41ea-b257-f77e6e3c2ed4
human_id
UUIDv4
fd227c4f-59db-4bf7-853a-203f162e2eb6
address
short string (blockchain address)
0xae972e214f2cb6b14cff509bac60c5501788d871
message
short string
My idOS ID is fd227c4f-59db-4bf7-853a-203f162e2eb6 and I own 0xae972e214f2cb6b14cff509bac60c5501788d871
signature
short string (cryptographic signature)
0xe3854867634cbc2ccd45fbe568b4c197ba096757a23cccf12bbaddd3ed1aa3a944f90c9544f9f62ee1aa2e987db37b558adc9e912259f55dea5e3d85b44440631c
credentials
id
UUIDv4
a2c77161-9b9f-4935-b532-adaabe7b505e
human_id
UUIDv4
fd227c4f-59db-4bf7-853a-203f162e2eb6
issuer
short string
Fractal ID
type
short string
KYC
content
long base64 string
(ciphertext)