database

<p>TODO: 数据类型，长度等需要填写</p> <h3>简要描述</h3> <ul> <li>DatabaseName：BitTraceProjectDB</li> <li>每个 Exporter 都有独立的四个表，ExporterName 作为表的后缀来区分</li> </ul> <h3>数据表</h3> <ul> <li>Snapshot Data 表：存储 init 和 final 类型的 snapshot</li> <li>Snapshot Sync 表：存储 sync 类型的 snapshot</li> <li>State 表：存储 init，final 和 sync snapshot 对应的 state</li> <li>Revision 表：存储 init，final snapshot 对应的 revision</li> </ul> <h3><code>Snapshot Data</code> 表</h3> <ul> <li>table_snapshot_data_exporter.test </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>snapshot_id</td> <td>varchar (35)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>target_chain_id</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>target_chain_height</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>block_hash</td> <td>varchar (255)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>is_orphan</td> <td>tinyint (1)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>init_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>final_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> </tbody> </table> <h3><code>Snapshot Sync</code> 表</h3> <ul> <li>table_snapshot_sync_exporter.test </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>snapshot_id</td> <td>varchar (35)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>target_chain_id</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>target_chain_height</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>sync_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> </tbody> </table> <h3><code>State</code> 表</h3> <ul> <li>table_state_exporter.test </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>snapshot_id</td> <td>varchar (35)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>snapshot_type</td> <td>tinyint (1)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>best_block_hash</td> <td>varchar (255)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>height</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>bits</td> <td>int</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>block_size</td> <td>bigint</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>block_weight</td> <td>bigint</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>num_txns</td> <td>bigint</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>total_txns</td> <td>bigint</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>median_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> </tbody> </table> <h3><code>Revision</code> 表</h3> <ul> <li>table_revision_exporter.test </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>snapshot_id</td> <td>varchar (35)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>revision_type</td> <td>tinyint</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>init_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>final_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>init_data</td> <td></td> <td>是</td> <td></td> <td>-</td> </tr> <tr> <td>final_data</td> <td></td> <td>是</td> <td></td> <td>-</td> </tr> </tbody> </table> <h3><code>EventOrphan</code> 表</h3> <ul> <li>table_event_orphan_exporter.test</li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>snapshot_id</td> <td>varchar (35)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>event_type_orphan</td> <td>tinyint (1)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>orphan_parent_block_hash</td> <td>varchar (255)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>orphan_block_hash</td> <td>varchar (255)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>connect_main_chain</td> <td>tinyint (1)</td> <td>否</td> <td></td> <td>-</td> </tr> <tr> <td>event_orphan_timestamp</td> <td>varchar (20)</td> <td>否</td> <td></td> <td>-</td> </tr> </tbody> </table>