The following diagram shows the primary schemas for each collection in the database: Block, Transaction, Message, and Account. To increase performance of reads/queries and reduce overall storage requirements, we have chosen to not denormalize and nest these different entities to show relationships. This shows the primary key for each collection document and any foreign keys as well.
下图显示了数据库中每个集合的主要模式: Block, Transaction, Message, 和 Account。 为了提高读取/查询的性能并减少总体存储需求, 我们选择不规范化和嵌套这些不同的实体来显示关系。 这将显示每个集合的主键和外键。
Conventions
- Primary and Foreign key fields should end with
_id, unless it’s a list of keys, in which case the field name should be the plural of the schema type of the referenced object.
约定
- 主键和外键字段应以 "_id" 结尾, 除非它表示的是列表, 在这种情况下, 字段名应该是被引用对象的模式类型的复数。
| Field | Type | Ref ID | Description |
|---|---|---|---|
| id | String | PK | System unique id （系统唯一标识符） |
| block_num | Integer | Ordinal numeric identifier （序号数字标识符） | |
| previous | String | FK | SHA256 of previous block （上个区块的SHA256） |
| timestamp | MongoDB Date (timestamp) | Scheduled time （计划时间） | |
| transaction_merkle_root | String | checksum (SHA256) of block when generated （区块产生时的校验和 (SHA256)） | |
| producer | String | FK | Account name of block producer （区块生产者的账户名） |
| producer_signature | String | ||
| transactions | [ObjectId,...] | List of transaction ids associated with this block （这个区块关联的交易 ids 列表） | |
| ref_block_prefix | Integer | ||
| producer_changes | Array | Changes to list of producers （区块生产者变更列表） |
{
"previous": "000000099271295c7e73dcf268802491f8d7e715608a6ec8182f0d4c4d6921bf",
"timestamp": "2017-12-04T03:09:10",
"transaction_merkle_root": "0000000000000000000000000000000000000000000000000000000000000000",
"producer": "inita",
"producer_changes": [],
"producer_signature": "20621b7582a272a8ef15e0caa2590c279b706b851e9007ba558855c0b2844e0bb975481417ecbe7f3b5ffb488ec733f508c6455743bc26604d5f220bcd25e4f731",
"cycles": [],
"id": "0000000abf6baeb841293e7b6423f47e98517206595bbae4eb69281ca0501a57",
"block_num": 10,
"ref_block_prefix": 2067671361
}
| Field | Type | Ref ID | Description |
|---|---|---|---|
| transaction_id | ObjectId | PK | System unique id （系统唯一标识符） |
| ref_block_num | Integer | Reference block number （引用的区块号） | |
| ref_block_prefix | Integer | Reference block header （引用的区块头） | |
| expiration | String | Expiration time of transaction （交易过期时间） | |
| scope | Array | Account scopes （账户范围） | |
| transaction_merkle_root | String | checksum (SHA256) of block when generated （区块产生时的校验和 (SHA256)） | |
| producer_account_id | String | FK | Account nmae of block producer （区块生产者的账户名） |
| signatures | Array | Array of signatures （签名集合） |
{
"transaction_id": "f989025b959026f4d1e97346c0808b0fa316f7426384ce4ded83d52fde0404bf",
"transaction": {
"ref_block_num": 7284,
"ref_block_prefix": 1294303748,
"expiration": "2017-12-04T07:31:48",
"scope": [
"benchmark...3",
"benchmark...i"
],
"signatures": [
"1f58d30c249bebfca299d485636b1bf6836df9df4a362221648f433897170fb70f1dc8933f70936d82266534883d187ba39f6fa7a448e881803c8c7530ff3afb18"
]
| Field | Type | Ref ID | Description |
|---|---|---|---|
| code | String | Name of contract （合约名称） | |
| type | String | Name of action （行为名称） | |
| authorization | Nested_Document | Authorizing account and permission （授权账户和权限） | |
| data | Nested document | A nested document, any format, specific to message in use （内嵌文档, 任何形式的消息） | |
| hex_data | String | Hexadecimal representation of data （数据的16进制的表现形式） |
"messages": [{
"code": "eos",
"type": "transfer",
"authorization": [{
"account": "benchmark...i",
"permission": "active"
}
],
"data": {
"from": "benchmark...i",
"to": "benchmark...3",
"amount": 1,
"memo": "2017-12-04T07:31:19 1512372679244267"
},
"hex_data": "0e0080d7c886a63a030080d7c886a63a010000000000000024323031372d31322d30345430373a33313a31392031353132333732363739323434323637"
}
]
| Field | Type | Ref ID | Description |
|---|---|---|---|
| account | String | FK | Authorizing account name （授权账户名） |
| permission | Permission | Permission used to authorize transaction （授权交易的权限 ） |
"authorization": [{
"account": "benchmark...i",
"permission": "active"
}
]
| Field | Type | Ref ID | Description |
|---|---|---|---|
| name | String | PK | Account Name（账户名） |
| eos_balance | String | Balance （余额） | |
| staked_balance | String | Staked balance （下注余额） | |
| unstaking_balance | String | Unstaking balance （未下注余额） | |
| last_unstaking_time | Date (timestamp)) | Timestamp of last modified date/time （最后修改时间） | |
| permissions | [Nested document,...] | Nested permission structure （内嵌的权限结构） |
{
"account_name": "inita",
"eos_balance": "999977.9995 EOS",
"staked_balance": "0.0000 EOS",
"unstaking_balance": "0.0000 EOS",
"last_unstaking_time": "1969-12-31T23:59:59",
"permissions": [{
"perm_name": "active",
"parent": "owner",
"required_auth": {
"threshold": 1,
"keys": [{
"key": "EOS6MRyAjQq8ud7hVNYcfnVPJqcVpscN5So8BhtHuGYqET5GDW5CV",
"weight": 1
}
],
"accounts": []
}
},{
"perm_name": "owner",
"parent": "",
"required_auth": {
"threshold": 1,
"keys": [{
"key": "EOS6MRyAjQq8ud7hVNYcfnVPJqcVpscN5So8BhtHuGYqET5GDW5CV",
"weight": 1
}
],
"accounts": []
}
}
]
}