Database Schema

• 1. Primary Schema Relationships 主要模式关系
• 2. Blocks
• 3. Transactions
• 4. Messages
• 5. Accounts

1. Primary Schema Relationships

1. 主要模式关系

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" 结尾, 除非它表示的是列表, 在这种情况下, 字段名应该是被引用对象的模式类型的复数。

2. Blocks

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 （区块生产者变更列表）

Example

{
  "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
}

3. Transaction

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 （签名集合）

Example

{
  "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"
    ]

4. Message

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进制的表现形式）

Example

    "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"
      }
    ]

Authorization Nested Document

Field	Type	Ref ID	Description
account	String	FK	Authorizing account name （授权账户名）
permission	Permission		Permission used to authorize transaction （授权交易的权限 ）

Example

        "authorization": [{
            "account": "benchmark...i",
            "permission": "active"
          }
        ]

5. Accounts (Collection)

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 （内嵌的权限结构）

Example

{
  "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": []
      }
    }
  ]
}