TrackRecordPro API Documentation TrackRecordPro

Custom Database Fields

The TrackRecordPro database supports the concept of custom fields. The custom fields are stored within a column on each table called 'data'. This column is always called 'data', and will always be of type LONGTEXT. The field must contain valid JSON or NULL, this is checked by a database trigger.

Users may add extra fields to the database using this functionality, for display on the frontend of the application. API users may also add custom fields by altering the JSON stored within the field. Note that adding a field to one record makes that same field visible on all records of the same type, and will display that value as empty/NULL on all other records until it is populated.

Fields beginning with $ are visible and editable only from the API, meaning you can use this to store keys to remote database records, and other private metadata.