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	[e-mail]
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	KYC Issuer name
	type	short string	KYC
	content	long base64 string	(ciphertext)