Naming convention

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



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


_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