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 |
---|---|---|---|
|
| UUIDv4 | fd227c4f-59db-4bf7-853a-203f162e2eb6 |
|
| UUIDv4 | b9cce79d-ef5b-4d78-bfbb-0c3778162d34 |
| UUIDv4 | fd227c4f-59db-4bf7-853a-203f162e2eb6 | |
| short string | email_address | |
| long string | foo@bar.com | |
|
| UUIDv4 | 8c365c0d-023d-41ea-b257-f77e6e3c2ed4 |
| UUIDv4 | fd227c4f-59db-4bf7-853a-203f162e2eb6 | |
| short string (blockchain address) | 0xae972e214f2cb6b14cff509bac60c5501788d871 | |
| short string | My idOS ID is fd227c4f-59db-4bf7-853a-203f162e2eb6 and I own 0xae972e214f2cb6b14cff509bac60c5501788d871 | |
| short string (cryptographic signature) | 0xe3854867634cbc2ccd45fbe568b4c197ba096757a23cccf12bbaddd3ed1aa3a944f90c9544f9f62ee1aa2e987db37b558adc9e912259f55dea5e3d85b44440631c | |
|
| UUIDv4 | a2c77161-9b9f-4935-b532-adaabe7b505e |
| UUIDv4 | fd227c4f-59db-4bf7-853a-203f162e2eb6 | |
| short string | Fractal ID | |
| short string | KYC | |
| long base64 string | (ciphertext) |
Last updated