Standard fields in chrono form tables..what are they?

mwhhrci 17 Dec, 2010
When I create a form and link it to a table...looking at the table structure, there are some default fields already built in. Like Uid, cfid and cfuserid. What are these exactly. How can I make use of these fields in my application... is there documentation anywhere? Thanks for your help.
GreyHead 18 Dec, 2010
Hi mwhhrci,

The columns are:

[list]
  • cf_id : the unique primary key for the record (auto-incremented)

  • uid : a random number string that can ge used as a unique identifier*

  • recordtime : the data and time the record was created

  • ipaddress : the IP address of the user (if it was available)

  • cf_user_id : the Joomal User ID of the user (0 for a guest)
  • [/list]

    You can use them for anything you like. You need to keep cf_id (or replace it with a different primary key). You can remove any of the other columns if you don't want them.

    Bob

    * Techically it isn't verified as unique, but the chances of a duplicate are very, very small.
    This topic is locked and no more replies can be posted.