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
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
Updated 5 months ago