Created with Vertabelo

ByteballCore - database model documentation

Database engine: MySQL

Version: 2.3

Description:

Table of contents

  1. Tables
    1. units
    2. balls
    3. skiplist_units
    4. parenthoods
    5. definitions
    6. addresses
    7. unit_authors
    8. authentifiers
    9. unit_witnesses
    10. witness_list_hashes
    11. earned_headers_commission_recipients
    12. messages
    13. spend_proofs
    14. address_definition_changes
    15. data_feeds
    16. polls
    17. poll_choices
    18. votes
    19. attestations
    20. assets
    21. asset_denominations
    22. asset_attestors
    23. inputs
    24. outputs
    25. headers_commission_contributions
    26. headers_commission_outputs
    27. paid_witness_events
    28. witnessing_outputs
    29. dependencies
    30. unhandled_joints
    31. archived_joints
    32. known_bad_joints
    33. joints
    34. unhandled_private_payments
    35. hash_tree_balls
    36. catchup_chain_balls
    37. peer_hosts
    38. peers
    39. peer_events
    40. peer_host_urls
    41. wallets
    42. my_addresses
    43. my_witnesses
    44. devices
    45. device_messages
    46. correspondent_devices
    47. pairing_secrets
    48. extended_pubkeys
    49. wallet_signing_paths
    50. shared_addresses
    51. pending_shared_addresses
    52. pending_shared_address_signing_paths
    53. shared_address_signing_paths
    54. outbox
    55. watched_light_addresses
    56. push_registrations
    57. chat_messages
    58. watched_light_units
    59. bots
    60. asset_metadata
    61. sent_mnemonics
    62. private_profiles
    63. private_profile_fields
  2. References
    1. unitsByLastBallUnit
    2. byBestParentUnit
    3. unitsByWitnessListUnit
    4. byUnit
    5. byUnit
    6. bySkiplistUnit
    7. parenthoodsByChild
    8. parenthoodsByParent
    9. byUnit
    10. unitAuthorsByAddress
    11. byDefinition
    12. byUnit
    13. authentifiersByAddress
    14. byUnit
    15. byUnit
    16. byUnit
    17. byUnit
    18. byUnit
    19. spendProofsByAddress
    20. byUnit
    21. addressDefinitionChangesByAddress
    22. byUnit
    23. byUnit
    24. byPoll
    25. votesByChoice
    26. byUnit
    27. attestationsByAttestorAddress
    28. byUnit
    29. byUnit
    30. byAsset
    31. byUnit
    32. assetAttestorsByAsset
    33. byUnit
    34. inputsBySrcUnit
    35. inputsByAddress
    36. inputsByAsset
    37. byUnit
    38. outputsByAsset
    39. byUnit
    40. byUnit
    41. byWitnessAddress
    42. byWitnessAddress
    43. byLearntFromPeerHost
    44. byPeerHost
    45. byPeerHost
    46. byPeerHost
    47. byWallet
    48. byAddress
    49. byWallet
    50. byTemplate
    51. bySharedAddress
    52. byAddress
    53. byAsset
    54. byMetadataUnit
    55. FK_0
    56. FK_1
    57. FK_2

1. Tables

1.1. Table units

1.1.1. Columns

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

1.1.2. Indexes

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)

1.2. Table balls

1.2.1. Columns

Column name Type Properties Description
ball char(44) PK
creation_date timestamp
unit char(44)
count_paid_witnesses tinyint null

1.2.2. Alternate keys

Key name Columns Description
AK_0 unit

1.2.3. Indexes

Index name Columns Description
byCountPaidWitnesses count_paid_witnesses (ASC)

1.3. Table skiplist_units

1.3.1. Columns

Column name Type Properties Description
unit char(44) PK
skiplist_unit char(44) PK

1.4. Table parenthoods

1.4.1. Columns

Column name Type Properties Description
child_unit char(44) PK
parent_unit char(44) PK

1.5. Table definitions

1.5.1. Columns

Column name Type Properties Description
definition_chash char(32) PK
definition text
has_references tinyint

1.6. Table addresses

1.6.1. Columns

Column name Type Properties Description
address char(32) PK
creation_date timestamp

1.7. Table unit_authors

1.7.1. Columns

Column name Type Properties Description
unit char(44) PK
address char(32) PK
definition_chash char(32) null
_mci int null

1.7.2. Indexes

Index name Columns Description
unitAuthorsIndexByAddressDefinitionChash address (ASC), definition_chash (ASC)
unitAuthorsIndexByAddressMci address (ASC), _mci (ASC)

1.8. Table authentifiers

1.8.1. Columns

Column name Type Properties Description
unit char(44) PK
address char(32) PK
path varchar(40) PK
authentifier varchar(4096)

1.9. Table unit_witnesses

1.9.1. Columns

Column name Type Properties Description
unit char(44) PK
address varchar(32) PK

1.9.2. Indexes

Index name Columns Description
byAddress address (ASC)

1.10. Table witness_list_hashes

1.10.1. Columns

Column name Type Properties Description
witness_list_unit char(44) PK
witness_list_hash char(44)
creation_date timestamp

1.10.2. Alternate keys

Key name Columns Description
AK_1 witness_list_hash

1.11. Table earned_headers_commission_recipients

1.11.1. Columns

Column name Type Properties Description
unit char(44) PK
address varchar(32) PK
earned_headers_commission_share int

1.11.2. Indexes

Index name Columns Description
byAddress address (ASC)

1.12. Table messages

1.12.1. Columns

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

1.13. Table spend_proofs

1.13.1. Columns

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)

1.13.2. Alternate keys

Key name Columns Description
bySpendProof spend_proof, unit

1.14. Table address_definition_changes

1.14.1. Columns

Column name Type Properties Description
unit char(44) PK
message_index tinyint PK
address char(32)
definition_chash varchar(32)

1.14.2. Alternate keys

Key name Columns Description
byAddressUnit address, unit

1.15. Table data_feeds

1.15.1. Columns

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

1.15.2. Indexes

Index name Columns Description
byNameStringValue feed_name (ASC), value (ASC)
byNameIntValue feed_name (ASC), int_value (ASC)

1.16. Table polls

1.16.1. Columns

Column name Type Properties Description
unit char(44) PK
message_index tinyint
question varchar(4096)

1.17. Table poll_choices

1.17.1. Columns

Column name Type Properties Description
unit char(44) PK
choice_index tinyint PK
choice varchar(32)

1.17.2. Alternate keys

Key name Columns Description
AK_2 unit, choice

1.18. Table votes

1.18.1. Columns

Column name Type Properties Description
unit char(44) PK
message_index tinyint PK
poll_unit char(44)
choice varchar(32)

1.18.2. Alternate keys

Key name Columns Description
AK_3 unit, choice

1.19. Table attestations

1.19.1. Columns

Column name Type Properties Description
unit char(44) PK
message_index tinyint PK
attestor_address varchar(32)
address varchar(32)

1.19.2. Indexes

Index name Columns Description
byAddress address (ASC)

1.20. Table assets

1.20.1. Columns

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

1.21. Table asset_denominations

1.21.1. Columns

Column name Type Properties Description
asset char(44) PK
denomination int PK
count_coins bigint null
max_issued_serial_number bigint

1.22. Table asset_attestors

1.22.1. Columns

Column name Type Properties Description
unit char(44) PK
message_index tinyint PK
asset char(44)
attestor_address char(32)

1.22.2. Alternate keys

Key name Columns Description
byAssetAttestorUnit asset, attestor_address, unit

1.23. Table inputs

1.23.1. Columns

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)

1.23.2. Alternate keys

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

1.23.3. Indexes

Index name Columns Description
byAssetType asset (ASC), type (ASC)
byAddressTypeToMci address (ASC), type (ASC), to_main_chain_index (ASC)

1.24. Table outputs

1.24.1. Columns

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

1.24.2. Alternate keys

Key name Columns Description
AK_4 unit, message_index, output_index

1.24.3. Indexes

Index name Columns Description
byAddressSpent address (ASC), is_spent (ASC)
bySerial is_serial (ASC)

1.25. Table headers_commission_contributions

1.25.1. Columns

Column name Type Properties Description
unit char(44) PK
address char(32) PK
amount bigint
creation_date timestamp

1.25.2. Indexes

Index name Columns Description
byAddress address (ASC)

1.26. Table headers_commission_outputs

1.26.1. Columns

Column name Type Properties Description
main_chain_index int PK
address char(32) PK
amount bigint
is_spent tinyint
creation_date timestamp

1.26.2. Alternate keys

Key name Columns Description
AK_5 address, main_chain_index
AK_6 address, is_spent, main_chain_index

1.27. Table paid_witness_events

1.27.1. Columns

Column name Type Properties Description
unit char(44) PK
address char(32) PK
delay tinyint null

1.28. Table witnessing_outputs

1.28.1. Columns

Column name Type Properties Description
main_chain_index int PK
address char(32) PK
amount bigint
is_spent tinyint
creation_date timestamp

1.28.2. Alternate keys

Key name Columns Description
AK_7 address, main_chain_index
AK_8 address, is_spent, main_chain_index

1.29. Table dependencies

1.29.1. Columns

Column name Type Properties Description
unit char(44)
depends_on_unit char(44) null
creation_date timestamp

1.29.2. Alternate keys

Key name Columns Description
AK_9 depends_on_unit, unit

1.29.3. Indexes

Index name Columns Description
byUnit unit (ASC)

1.30. Table unhandled_joints

1.30.1. Columns

Column name Type Properties Description
unit char(44) PK
peer varchar(100)
json longtext
creation_date timestamp

1.31. Table archived_joints

1.31.1. Columns

Column name Type Properties Description
unit char(44) PK
reason enum('uncovered','voided')
json longtext
creation_date timestamp

1.32. Table known_bad_joints

1.32.1. Columns

Column name Type Properties Description
joint char(44) null
unit char(44) null
json longtext
error text
creation_date timestamp

1.32.2. Alternate keys

Key name Columns Description
AK_10 joint
AK_11 unit

1.33. Table joints

1.33.1. Columns

Column name Type Properties Description
unit char(44) PK
json longtext
creation_date timestamp

1.34. Table unhandled_private_payments

1.34.1. Columns

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

1.35. Table hash_tree_balls

1.35.1. Columns

Column name Type Properties Description
ball_index int PK
ball char(44)
unit char(44)

1.35.2. Alternate keys

Key name Columns Description
AK_12 ball
AK_13 unit

1.36. Table catchup_chain_balls

1.36.1. Columns

Column name Type Properties Description
member_index int PK
ball char(44)

1.36.2. Alternate keys

Key name Columns Description
AK_14 ball

1.37. Table peer_hosts

1.37.1. Columns

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

1.38. Table peers

1.38.1. Columns

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

1.39. Table peer_events

1.39.1. Columns

Column name Type Properties Description
peer_host varchar(100)
event_date timestamp
event enum('new_good','invalid','nonserial','known_good','known_bad')

1.40. Table peer_host_urls

1.40.1. Columns

Column name Type Properties Description
peer_host varchar(100)
url varchar(100)
creation_date timestamp
is_active tinyint null
revocation_date timestamp null

1.40.2. Alternate keys

Key name Columns Description
byHostActive peer_host, is_active

1.41. Table wallets

1.41.1. Columns

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

1.42. Table my_addresses

1.42.1. Columns

Column name Type Properties Description
address char(32) PK
wallet char(44)
is_change tinyint
address_index int
definition text
creation_date timestamp

1.42.2. Alternate keys

Key name Columns Description
byWalletPath wallet, is_change, address_index

1.43. Table my_witnesses

1.43.1. Columns

Column name Type Properties Description
address varchar(32) PK

1.44. Table devices

1.44.1. Columns

Column name Type Properties Description
device_address char(33) PK
pubkey char(44)
temp_pubkey_package text null
creation_date timestamp

1.45. Table device_messages

1.45.1. Columns

Column name Type Properties Description
message_hash char(44) PK
device_address char(33)
message longtext
creation_date timestamp

1.46. Table correspondent_devices

1.46.1. Columns

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

1.47. Table pairing_secrets

1.47.1. Columns

Column name Type Properties Description
pairing_secret varchar(40) PK
is_permanent tinyint
creation_date timestamp
expiry_date timestamp

1.48. Table extended_pubkeys

1.48.1. Columns

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

1.49. Table wallet_signing_paths

1.49.1. Columns

Column name Type Properties Description
wallet char(44)
signing_path varchar(255) null
device_address char(33)
creation_date timestamp

1.49.2. Alternate keys

Key name Columns Description
byWalletSigningPath wallet, signing_path

1.50. Table shared_addresses

1.50.1. Columns

Column name Type Properties Description
shared_address char(32) PK
definition text
creation_date timestamp

1.51. Table pending_shared_addresses

1.51.1. Columns

Column name Type Properties Description
definition_template_chash char(32) PK
definition_template text
creation_date timestamp

1.52. Table pending_shared_address_signing_paths

1.52.1. Columns

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

1.53. Table shared_address_signing_paths

1.53.1. Columns

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

1.53.2. Alternate keys

Key name Columns Description
bySharedAddressSigningPath shared_address, signing_path

1.54. Table outbox

1.54.1. Columns

Column name Type Properties Description
message_hash char(44) PK
to char(33)
message longtext
creation_date timestamp
last_error text null

1.55. Table watched_light_addresses

1.55.1. Columns

Column name Type Properties Description
peer varchar(100) PK
address char(32) PK
creation_date timestamp

1.55.2. Indexes

Index name Columns Description
byAddress address (ASC)

1.56. Table push_registrations

1.56.1. Columns

Column name Type Properties Description
registrationId varchar(200) null
device_address char(33) PK

1.57. Table chat_messages

1.57.1. Columns

Column name Type Properties Description
id integer PK
correspondent_address char(33)
message longtext
creation_date timestamp
is_incoming tinyint
type char(15)

1.57.2. Indexes

Index name Columns Description
chatMessagesIndexByDeviceAddress correspondent_address (ASC), id (ASC)

1.58. Table watched_light_units

1.58.1. Columns

Column name Type Properties Description
peer varchar(100) PK
unit char(44) PK
creation_date timestamp

1.58.2. Indexes

Index name Columns Description
wlabyUnit unit (ASC)

1.59. Table bots

1.59.1. Columns

Column name Type Properties Description
id integer PK
rank integer
name varchar(100)
pairing_code varchar(200)
description longtext

1.59.2. Alternate keys

Key name Columns Description
AK_15 name

1.60. Table asset_metadata

1.60.1. Columns

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

1.60.2. Alternate keys

Key name Columns Description
byNameRegistry name, registry_address

1.61. Table sent_mnemonics

1.61.1. Columns

Column name Type Properties Description
unit char(44)
address char(32)
mnemonic varchar(107)
textAddress varchar(120)
creation_date timestamp

1.61.2. Indexes

Index name Columns Description
sentByAddress address (ASC)

1.62. Table private_profiles

1.62.1. Columns

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

1.63. Table private_profile_fields

1.63.1. Columns

Column name Type Properties Description
private_profile_id integer
field varchar(50)
value varchar(50)
blinding char(16)
creation_date timestamp

1.63.2. Alternate keys

Key name Columns Description
byProfileIdField private_profile_id, field

1.63.3. Indexes

Index name Columns Description
ppfByField field (ASC)

2. Reference

2.1. Reference unitsByLastBallUnit

2.1.1. Columns

units 0..* units
unit <-> last_ball_unit

2.2. Reference byBestParentUnit

2.2.1. Columns

units 0..* units
unit <-> best_parent_unit

2.3. Reference unitsByWitnessListUnit

2.3.1. Columns

units 0..* units
unit <-> witness_list_unit

2.4. Reference byUnit

2.4.1. Columns

units 0..1 balls
unit <-> unit

2.5. Reference byUnit

2.5.1. Columns

units 0..* skiplist_units
unit <-> unit

2.6. Reference bySkiplistUnit

2.6.1. Columns

units 0..* skiplist_units
unit <-> skiplist_unit

2.7. Reference parenthoodsByChild

2.7.1. Columns

units 0..* parenthoods
unit <-> child_unit

2.8. Reference parenthoodsByParent

2.8.1. Columns

units 0..* parenthoods
unit <-> parent_unit

2.9. Reference byUnit

2.9.1. Columns

units 0..* unit_authors
unit <-> unit

2.10. Reference unitAuthorsByAddress

2.10.1. Columns

addresses 0..* unit_authors
address <-> address

2.11. Reference byDefinition

2.11.1. Columns

definitions 0..* unit_authors
definition_chash <-> definition_chash

2.12. Reference byUnit

2.12.1. Columns

units 0..* authentifiers
unit <-> unit

2.13. Reference authentifiersByAddress

2.13.1. Columns

addresses 0..* authentifiers
address <-> address

2.14. Reference byUnit

2.14.1. Columns

units 0..* unit_witnesses
unit <-> unit

2.15. Reference byUnit

2.15.1. Columns

units 0..1 witness_list_hashes
unit <-> witness_list_unit

2.16. Reference byUnit

2.16.1. Columns

units 0..* earned_headers_commission_recipients
unit <-> unit

2.17. Reference byUnit

2.17.1. Columns

units 0..* messages
unit <-> unit

2.18. Reference byUnit

2.18.1. Columns

units 0..* spend_proofs
unit <-> unit

2.19. Reference spendProofsByAddress

2.19.1. Columns

addresses 0..* spend_proofs
address <-> address

2.20. Reference byUnit

2.20.1. Columns

units 0..* address_definition_changes
unit <-> unit

2.21. Reference addressDefinitionChangesByAddress

2.21.1. Columns

addresses 0..* address_definition_changes
address <-> address

2.22. Reference byUnit

2.22.1. Columns

units 0..* data_feeds
unit <-> unit

2.23. Reference byUnit

2.23.1. Columns

units 0..1 polls
unit <-> unit

2.24. Reference byPoll

2.24.1. Columns

polls 0..* poll_choices
unit <-> unit

2.25. Reference votesByChoice

2.25.1. Columns

poll_choices 0..* votes
unit <-> poll_unit
choice <-> choice

2.26. Reference byUnit

2.26.1. Columns

units 0..* votes
unit <-> unit

2.27. Reference attestationsByAttestorAddress

2.27.1. Columns

addresses 0..* attestations
address <-> attestor_address

2.28. Reference byUnit

2.28.1. Columns

units 0..* attestations
unit <-> unit

2.29. Reference byUnit

2.29.1. Columns

units 0..1 assets
unit <-> unit

2.30. Reference byAsset

2.30.1. Columns

assets 0..* asset_denominations
unit <-> asset

2.31. Reference byUnit

2.31.1. Columns

units 0..* asset_attestors
unit <-> unit

2.32. Reference assetAttestorsByAsset

2.32.1. Columns

assets 0..* asset_attestors
unit <-> asset

2.33. Reference byUnit

2.33.1. Columns

units 0..* inputs
unit <-> unit

2.34. Reference inputsBySrcUnit

2.34.1. Columns

units 0..* inputs
unit <-> src_unit

2.35. Reference inputsByAddress

2.35.1. Columns

addresses 0..* inputs
address <-> address

2.36. Reference inputsByAsset

2.36.1. Columns

assets 0..* inputs
unit <-> asset

2.37. Reference byUnit

2.37.1. Columns

units 0..* outputs
unit <-> unit

2.38. Reference outputsByAsset

2.38.1. Columns

assets 0..* outputs
unit <-> asset

2.39. Reference byUnit

2.39.1. Columns

units 0..* headers_commission_contributions
unit <-> unit

2.40. Reference byUnit

2.40.1. Columns

units 0..* paid_witness_events
unit <-> unit

2.41. Reference byWitnessAddress

2.41.1. Columns

addresses 0..* paid_witness_events
address <-> address

2.42. Reference byWitnessAddress

2.42.1. Columns

addresses 0..* witnessing_outputs
address <-> address

2.43. Reference byLearntFromPeerHost

2.43.1. Columns

peer_hosts 0..* peers
peer_host <-> learnt_from_peer_host

2.44. Reference byPeerHost

2.44.1. Columns

peer_hosts 0..* peers
peer_host <-> peer_host

2.45. Reference byPeerHost

2.45.1. Columns

peer_hosts 0..* peer_events
peer_host <-> peer_host

2.46. Reference byPeerHost

2.46.1. Columns

peer_hosts 0..* peer_host_urls
peer_host <-> peer_host

2.47. Reference byWallet

2.47.1. Columns

wallets 0..* my_addresses
wallet <-> wallet

2.48. Reference byAddress

2.48.1. Columns

devices 0..* device_messages
device_address <-> device_address

2.49. Reference byWallet

2.49.1. Columns

wallets 0..* wallet_signing_paths
wallet <-> wallet

2.50. Reference byTemplate

2.50.1. Columns

pending_shared_addresses 0..* pending_shared_address_signing_paths
definition_template_chash <-> definition_template_chash

2.51. Reference bySharedAddress

2.51.1. Columns

shared_addresses 0..* shared_address_signing_paths
shared_address <-> shared_address

2.52. Reference byAddress

2.52.1. Columns

correspondent_devices 0..* chat_messages
device_address <-> correspondent_address

2.53. Reference byAsset

2.53.1. Columns

assets 0..1 asset_metadata
unit <-> asset

2.54. Reference byMetadataUnit

2.54.1. Columns

units 0..* asset_metadata
unit <-> metadata_unit

2.55. Reference FK_0

2.55.1. Columns

units 0..* sent_mnemonics
unit <-> unit

2.56. Reference FK_1

2.56.1. Columns

units 0..* private_profiles
unit <-> unit

2.57. Reference FK_2

2.57.1. Columns

private_profiles 0..* private_profile_fields
private_profile_id <-> private_profile_id