Common - tables and fields

• Table name and fields name are in lowercase
• Underscores separate the distinct terms as per the standard conventions
• All table names are in plural form
• Table names are only having the following characters:
  • a to z / A to Z
  • 0 to 9
  • underscore (_) instead of spaces
• Table names may have multiple underscores

Tables

Prefixes

ud_: means user define, data contributed by the community.

Suffixes

_info. represents the base information table maintained by Footprint and can be used as a hub for data association
_daily_stats. Data in the table are aggregated by day.
_token_transfers. Flow records of data chain tokens.
_transactions. Represents transaction that occurs on the blockchain, and the hash value represents its uniqueness.
_deprecated. Table is no longer relevant.

📘

Deprecated tables

• Same {table} may be deprecated several times. Following popular naming convention, the deprecated tables will have the autoincrimenting number appended so that the table name will look like following: {table}_depecated_{copy_number}
• Deprecated tables will only be for 30 days. Users having the charts that are based on deprecated tables will be guided to use new updated tables instead

Special marks

Beta: data accuracy, stability, data period, update frequency and other important metrics are still being tested