which tables and columns are used in SQL when entry is made

which tables and columns are used in SQL when entry is made

by Sidd Lep -
Number of replies: 2

Hello.

I am just wondering which tables and columns in SQL are used when one simple entry is made. 

For example, I create a simple form in dataform with two fields: text and number.

I realized, it is created in "dataform_fields" table.

But, when someone enter a values in those fields, where exactly the data are stored in SQL database and which tables and columns are affected. I want to understand relationship of the database.


Thank you.

Average of ratings: -
In reply to Sidd Lep

Re: which tables and columns are used in SQL when entry is made

by Itamar Tzadok -

dataform - Dataform instance records.

dataform_fields - Dataform field records.

dataform_views - Dataform view records.

dataform_filters - Dataform filter records.

dataform_entries - Dataform entry records.

dataform_contents - Dataform entry content records (by entry id and field id).

smile


In reply to Itamar Tzadok

Odgovor: Re: which tables and columns are used in SQL when entry is made

by Sidd Lep -

Thank you.

smile