Database engine: MySQL
Version: 2.3
Description:
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
creation_date | timestamp | ||
version | varchar(10) | ||
alt | varchar(3) | ||
witness_list_unit | char(44) | null | |
last_ball_unit | char(44) | null | |
content_hash | char(44) | null | |
headers_commission | int | ||
payload_commission | int | ||
is_free | tinyint | ||
is_on_main_chain | tinyint | ||
main_chain_index | int | null | |
latest_included_mc_index | int | null | |
level | int | null | |
witnessed_level | int | null | |
is_stable | tinyint | ||
sequence | enum('good','temp-bad','final-bad') | ||
best_parent_unit | char(44) | null |
Index name | Columns | Description |
---|---|---|
byMainChain | is_on_main_chain (ASC) | |
byMcIndex | main_chain_index (ASC) | |
byLimci | latest_included_mc_index (ASC) | |
byLevel | level (ASC) | |
byFree | is_free (ASC) | |
byStableMci | is_stable (ASC), main_chain_index (ASC) | |
byDate | creation_date (ASC) | |
bySequence | sequence (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
ball | char(44) | PK | |
creation_date | timestamp | ||
unit | char(44) | ||
count_paid_witnesses | tinyint | null |
Key name | Columns | Description |
---|---|---|
AK_0 | unit |
Index name | Columns | Description |
---|---|---|
byCountPaidWitnesses | count_paid_witnesses (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
skiplist_unit | char(44) | PK |
Column name | Type | Properties | Description |
---|---|---|---|
child_unit | char(44) | PK | |
parent_unit | char(44) | PK |
Column name | Type | Properties | Description |
---|---|---|---|
definition_chash | char(32) | PK | |
definition | text | ||
has_references | tinyint |
Column name | Type | Properties | Description |
---|---|---|---|
address | char(32) | PK | |
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | char(32) | PK | |
definition_chash | char(32) | null | |
_mci | int | null |
Index name | Columns | Description |
---|---|---|
unitAuthorsIndexByAddressDefinitionChash | address (ASC), definition_chash (ASC) | |
unitAuthorsIndexByAddressMci | address (ASC), _mci (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | char(32) | PK | |
path | varchar(40) | PK | |
authentifier | varchar(4096) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | varchar(32) | PK |
Index name | Columns | Description |
---|---|---|
byAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
witness_list_unit | char(44) | PK | |
witness_list_hash | char(44) | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
AK_1 | witness_list_hash |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | varchar(32) | PK | |
earned_headers_commission_share | int |
Index name | Columns | Description |
---|---|---|
byAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
app | varchar(30) | ||
payload_location | enum('inline','uri','none') | ||
payload_hash | varchar(44) | ||
payload | text | null | |
payload_uri_hash | varchar(44) | null | |
payload_uri | varchar(500) | null |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
spend_proof_index | tinyint | PK | |
spend_proof | char(44) | ||
address | char(32) |
Key name | Columns | Description |
---|---|---|
bySpendProof | spend_proof, unit |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
address | char(32) | ||
definition_chash | varchar(32) |
Key name | Columns | Description |
---|---|---|
byAddressUnit | address, unit |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | ||
feed_name | varchar(64) | PK | |
value | varchar(64) | null | |
int_value | bigint | null |
Index name | Columns | Description |
---|---|---|
byNameStringValue | feed_name (ASC), value (ASC) | |
byNameIntValue | feed_name (ASC), int_value (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | ||
question | varchar(4096) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
choice_index | tinyint | PK | |
choice | varchar(32) |
Key name | Columns | Description |
---|---|---|
AK_2 | unit, choice |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
poll_unit | char(44) | ||
choice | varchar(32) |
Key name | Columns | Description |
---|---|---|
AK_3 | unit, choice |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
attestor_address | varchar(32) | ||
address | varchar(32) |
Index name | Columns | Description |
---|---|---|
byAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | ||
cap | bigint | null | |
is_private | tinyint | ||
is_transferrable | tinyint | ||
auto_destroy | tinyint | ||
fixed_denominations | tinyint | ||
issued_by_definer_only | tinyint | ||
cosigned_by_definer | tinyint | ||
spender_attested | tinyint | ||
issue_condition | text | null | |
transfer_condition | text | null |
Column name | Type | Properties | Description |
---|---|---|---|
asset | char(44) | PK | |
denomination | int | PK | |
count_coins | bigint | null | |
max_issued_serial_number | bigint |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
asset | char(44) | ||
attestor_address | char(32) |
Key name | Columns | Description |
---|---|---|
byAssetAttestorUnit | asset, attestor_address, unit |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
input_index | tinyint | PK | |
asset | char(44) | null | |
denomination | int | ||
is_unique | tinyint | null | |
type | enum('transfer','headers_commission','witnessing','issue') | ||
src_unit | char(44) | null | |
src_message_index | tinyint | null | |
src_output_index | tinyint | null | |
from_main_chain_index | int | null | |
to_main_chain_index | int | null | |
serial_number | bigint | null | |
amount | bigint | null | |
address | char(32) |
Key name | Columns | Description |
---|---|---|
bySrcOutput | src_unit, src_message_index, src_output_index, is_unique | |
byIndexAddress | type, from_main_chain_index, address, is_unique | |
byAssetDenominationSerialAddress | asset, denomination, serial_number, address, is_unique |
Index name | Columns | Description |
---|---|---|
byAssetType | asset (ASC), type (ASC) | |
byAddressTypeToMci | address (ASC), type (ASC), to_main_chain_index (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
output_id | int | PK | |
unit | char(44) | ||
message_index | tinyint | ||
output_index | tinyint | ||
asset | char(44) | null | |
denomination | int | ||
address | varchar(32) | null | |
amount | bigint | ||
blinding | char(16) | null | |
output_hash | char(44) | null | |
is_serial | tinyint | null | |
is_spent | tinyint |
Key name | Columns | Description |
---|---|---|
AK_4 | unit, message_index, output_index |
Index name | Columns | Description |
---|---|---|
byAddressSpent | address (ASC), is_spent (ASC) | |
bySerial | is_serial (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | char(32) | PK | |
amount | bigint | ||
creation_date | timestamp |
Index name | Columns | Description |
---|---|---|
byAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
main_chain_index | int | PK | |
address | char(32) | PK | |
amount | bigint | ||
is_spent | tinyint | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
AK_5 | address, main_chain_index | |
AK_6 | address, is_spent, main_chain_index |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
address | char(32) | PK | |
delay | tinyint | null |
Column name | Type | Properties | Description |
---|---|---|---|
main_chain_index | int | PK | |
address | char(32) | PK | |
amount | bigint | ||
is_spent | tinyint | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
AK_7 | address, main_chain_index | |
AK_8 | address, is_spent, main_chain_index |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | ||
depends_on_unit | char(44) | null | |
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
AK_9 | depends_on_unit, unit |
Index name | Columns | Description |
---|---|---|
byUnit | unit (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
peer | varchar(100) | ||
json | longtext | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
reason | enum('uncovered','voided') | ||
json | longtext | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
joint | char(44) | null | |
unit | char(44) | null | |
json | longtext | ||
error | text | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
AK_10 | joint | |
AK_11 | unit |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
json | longtext | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | PK | |
message_index | tinyint | PK | |
output_index | tinyint | PK | |
json | longtext | ||
peer | varchar(100) | ||
linked | tinyint | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
ball_index | int | PK | |
ball | char(44) | ||
unit | char(44) |
Key name | Columns | Description |
---|---|---|
AK_12 | ball | |
AK_13 | unit |
Column name | Type | Properties | Description |
---|---|---|---|
member_index | int | PK | |
ball | char(44) |
Key name | Columns | Description |
---|---|---|
AK_14 | ball |
Column name | Type | Properties | Description |
---|---|---|---|
peer_host | varchar(100) | PK | |
creation_date | timestamp | ||
count_new_good_joints | int | ||
count_invalid_joints | int | ||
count_nonserial_joints | int |
Column name | Type | Properties | Description |
---|---|---|---|
peer | varchar(100) | PK | |
peer_host | varchar(100) | ||
learnt_from_peer_host | varchar(100) | null | |
is_self | tinyint | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
peer_host | varchar(100) | ||
event_date | timestamp | ||
event | enum('new_good','invalid','nonserial','known_good','known_bad') |
Column name | Type | Properties | Description |
---|---|---|---|
peer_host | varchar(100) | ||
url | varchar(100) | ||
creation_date | timestamp | ||
is_active | tinyint | null | |
revocation_date | timestamp | null |
Key name | Columns | Description |
---|---|---|
byHostActive | peer_host, is_active |
Column name | Type | Properties | Description |
---|---|---|---|
wallet | char(44) | PK | |
account | int | ||
definition_template | text | ||
creation_date | timestamp | ||
full_approval_date | timestamp | null | |
ready_date | timestamp | null |
Column name | Type | Properties | Description |
---|---|---|---|
address | char(32) | PK | |
wallet | char(44) | ||
is_change | tinyint | ||
address_index | int | ||
definition | text | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
byWalletPath | wallet, is_change, address_index |
Column name | Type | Properties | Description |
---|---|---|---|
address | varchar(32) | PK |
Column name | Type | Properties | Description |
---|---|---|---|
device_address | char(33) | PK | |
pubkey | char(44) | ||
temp_pubkey_package | text | null | |
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
message_hash | char(44) | PK | |
device_address | char(33) | ||
message | longtext | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
device_address | char(33) | PK | |
name | varchar(100) | ||
pubkey | char(44) | ||
hub | varchar(100) | ||
is_confirmed | tinyint | ||
is_indirect | tinyint | ||
creation_date | timestamp | ||
my_record_pref | integer | null | |
peer_record_pref | integer | null |
Column name | Type | Properties | Description |
---|---|---|---|
pairing_secret | varchar(40) | PK | |
is_permanent | tinyint | ||
creation_date | timestamp | ||
expiry_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
wallet | char(44) | PK | |
extended_pubkey | char(112) | null | |
device_address | char(33) | PK | |
creation_date | timestamp | ||
approval_date | timestamp | null | |
member_ready_date | timestamp | null |
Column name | Type | Properties | Description |
---|---|---|---|
wallet | char(44) | ||
signing_path | varchar(255) | null | |
device_address | char(33) | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
byWalletSigningPath | wallet, signing_path |
Column name | Type | Properties | Description |
---|---|---|---|
shared_address | char(32) | PK | |
definition | text | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
definition_template_chash | char(32) | PK | |
definition_template | text | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
definition_template_chash | char(32) | PK | |
device_address | char(33) | ||
signing_path | varchar(255) | PK | |
address | char(32) | null | |
device_addresses_by_relative_signing_paths | text | null | |
creation_date | timestamp | ||
approval_date | timestamp | null |
Column name | Type | Properties | Description |
---|---|---|---|
shared_address | char(32) | ||
signing_path | varchar(255) | null | |
address | char(32) | ||
member_signing_path | varchar(255) | null | |
device_address | char(33) | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
bySharedAddressSigningPath | shared_address, signing_path |
Column name | Type | Properties | Description |
---|---|---|---|
message_hash | char(44) | PK | |
to | char(33) | ||
message | longtext | ||
creation_date | timestamp | ||
last_error | text | null |
Column name | Type | Properties | Description |
---|---|---|---|
peer | varchar(100) | PK | |
address | char(32) | PK | |
creation_date | timestamp |
Index name | Columns | Description |
---|---|---|
byAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
registrationId | varchar(200) | null | |
device_address | char(33) | PK |
Column name | Type | Properties | Description |
---|---|---|---|
id | integer | PK | |
correspondent_address | char(33) | ||
message | longtext | ||
creation_date | timestamp | ||
is_incoming | tinyint | ||
type | char(15) |
Index name | Columns | Description |
---|---|---|
chatMessagesIndexByDeviceAddress | correspondent_address (ASC), id (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
peer | varchar(100) | PK | |
unit | char(44) | PK | |
creation_date | timestamp |
Index name | Columns | Description |
---|---|---|
wlabyUnit | unit (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
id | integer | PK | |
rank | integer | ||
name | varchar(100) | ||
pairing_code | varchar(200) | ||
description | longtext |
Key name | Columns | Description |
---|---|---|
AK_15 | name |
Column name | Type | Properties | Description |
---|---|---|---|
asset | char(44) | PK | |
metadata_unit | char(44) | ||
registry_address | char(32) | null | |
suffix | varchar(20) | null | |
name | varchar(20) | null | |
decimals | tinyint | null | |
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
byNameRegistry | name, registry_address |
Column name | Type | Properties | Description |
---|---|---|---|
unit | char(44) | ||
address | char(32) | ||
mnemonic | varchar(107) | ||
textAddress | varchar(120) | ||
creation_date | timestamp |
Index name | Columns | Description |
---|---|---|
sentByAddress | address (ASC) |
Column name | Type | Properties | Description |
---|---|---|---|
private_profile_id | integer | PK | |
unit | char(44) | ||
payload_hash | char(44) | ||
attestor_address | char(32) | ||
address | char(32) | ||
src_profile | text | ||
creation_date | timestamp |
Column name | Type | Properties | Description |
---|---|---|---|
private_profile_id | integer | ||
field | varchar(50) | ||
value | varchar(50) | ||
blinding | char(16) | ||
creation_date | timestamp |
Key name | Columns | Description |
---|---|---|
byProfileIdField | private_profile_id, field |
Index name | Columns | Description |
---|---|---|
ppfByField | field (ASC) |
units | 0..* | units |
unit | <-> | last_ball_unit |
units | 0..* | units |
unit | <-> | best_parent_unit |
units | 0..* | units |
unit | <-> | witness_list_unit |
units | 0..1 | balls |
unit | <-> | unit |
units | 0..* | skiplist_units |
unit | <-> | unit |
units | 0..* | skiplist_units |
unit | <-> | skiplist_unit |
units | 0..* | parenthoods |
unit | <-> | child_unit |
units | 0..* | parenthoods |
unit | <-> | parent_unit |
units | 0..* | unit_authors |
unit | <-> | unit |
addresses | 0..* | unit_authors |
address | <-> | address |
definitions | 0..* | unit_authors |
definition_chash | <-> | definition_chash |
units | 0..* | authentifiers |
unit | <-> | unit |
addresses | 0..* | authentifiers |
address | <-> | address |
units | 0..* | unit_witnesses |
unit | <-> | unit |
units | 0..1 | witness_list_hashes |
unit | <-> | witness_list_unit |
units | 0..* | earned_headers_commission_recipients |
unit | <-> | unit |
units | 0..* | messages |
unit | <-> | unit |
units | 0..* | spend_proofs |
unit | <-> | unit |
addresses | 0..* | spend_proofs |
address | <-> | address |
units | 0..* | address_definition_changes |
unit | <-> | unit |
addresses | 0..* | address_definition_changes |
address | <-> | address |
units | 0..* | data_feeds |
unit | <-> | unit |
units | 0..1 | polls |
unit | <-> | unit |
polls | 0..* | poll_choices |
unit | <-> | unit |
poll_choices | 0..* | votes |
unit | <-> | poll_unit |
choice | <-> | choice |
units | 0..* | votes |
unit | <-> | unit |
addresses | 0..* | attestations |
address | <-> | attestor_address |
units | 0..* | attestations |
unit | <-> | unit |
units | 0..1 | assets |
unit | <-> | unit |
assets | 0..* | asset_denominations |
unit | <-> | asset |
units | 0..* | asset_attestors |
unit | <-> | unit |
assets | 0..* | asset_attestors |
unit | <-> | asset |
units | 0..* | inputs |
unit | <-> | unit |
units | 0..* | inputs |
unit | <-> | src_unit |
addresses | 0..* | inputs |
address | <-> | address |
assets | 0..* | inputs |
unit | <-> | asset |
units | 0..* | outputs |
unit | <-> | unit |
assets | 0..* | outputs |
unit | <-> | asset |
units | 0..* | headers_commission_contributions |
unit | <-> | unit |
units | 0..* | paid_witness_events |
unit | <-> | unit |
addresses | 0..* | paid_witness_events |
address | <-> | address |
addresses | 0..* | witnessing_outputs |
address | <-> | address |
peer_hosts | 0..* | peers |
peer_host | <-> | learnt_from_peer_host |
peer_hosts | 0..* | peers |
peer_host | <-> | peer_host |
peer_hosts | 0..* | peer_events |
peer_host | <-> | peer_host |
peer_hosts | 0..* | peer_host_urls |
peer_host | <-> | peer_host |
wallets | 0..* | my_addresses |
wallet | <-> | wallet |
devices | 0..* | device_messages |
device_address | <-> | device_address |
wallets | 0..* | wallet_signing_paths |
wallet | <-> | wallet |
pending_shared_addresses | 0..* | pending_shared_address_signing_paths |
definition_template_chash | <-> | definition_template_chash |
shared_addresses | 0..* | shared_address_signing_paths |
shared_address | <-> | shared_address |
correspondent_devices | 0..* | chat_messages |
device_address | <-> | correspondent_address |
assets | 0..1 | asset_metadata |
unit | <-> | asset |
units | 0..* | asset_metadata |
unit | <-> | metadata_unit |
units | 0..* | sent_mnemonics |
unit | <-> | unit |
units | 0..* | private_profiles |
unit | <-> | unit |
private_profiles | 0..* | private_profile_fields |
private_profile_id | <-> | private_profile_id |