Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Database Defaults

Is there any way to delete the automatically generated fields in tables? Or change the names?

Tagged:

Comments

  • Hi,

    Unfortunately, there is no way at present to delete or rename these fields. The ID field is required as the primary key for the table that uniquely identifies every record. It is an unsigned integer and will be called yourTableNameID.

    timeCreated will store a timestamp in seconds (in UTC) for when the record was initially created and timeUpdated will automatically be updated to store the timestamp in seconds (in UTC) whenever the record was last updated.

    These fields can be used to sort and/or filter the results of an API method to return only those records updated recently as is shown here.

    https://docs.kumulos.com/build/api/#filtering-by-timecreated-or-timeupdated

    Hope this helps.

    Mark.

Sign In or Register to comment.