Jump to content
  • 0

Different types of Caspio tables



9 answers to this question

Recommended Posts

  • 0

Hi @ParkLoey,

I can't find the reference anymore, but I got this answer from somebody:

E.g. you have employee master table which contains master information of all employees like Employee Code, Employee name, Employee Date of Birth etc whereas detail table contains detail information of those employees like every month's salary information and i.e. one to many relationship. Whereas domain table contains constant information like all states/ zip code of a Country.

Does that mean anything to you?

Link to comment
Share on other sites

  • 0

Hello @TeamVilla,

It looks like the Master/Detail tables are  equal to Parent/Child tables. 

A Parent table is the table that stores the primary key (a field that uniquely identifies the table records).

 A Child table is the table that references the parent with a foreign key. 

Here is the article https://howto.caspio.com/tables-and-views/relationships/database-relationships/

I believe, that Domain table is equal to Lookup table (Countries_table, Months_of_the_Year_table, etc. ). It stores data you've pulled out of your table to make the table smaller. You may set the relationship between the Lookup table and other tables by the use of foreign keys.

You may want to check this article https://howto.caspio.com/tables-and-views/lookup-tables/

Hope this helps. 

Link to comment
Share on other sites

  • 0
On 11/10/2020 at 5:21 PM, sandy159 said:

Hello @TeamVilla,

I am quite not sure what you mean by different types of tables...

It is actually really easy to create Tables with Caspio. Please check the following resources:

Creating Tables

Learn How to Get Started with Caspio / Part 2 of 5 / Create a Table


Every type of Table is mentioned here, You should clarify what type of further information you are expecting.

Link to comment
Share on other sites

  • 0

Hiya! Wanted to update this thread re: recent AI assistant improvements:

  • Enhanced, interactive chat experience
  • Preview of the proposed table structure before generation
  • Alternative table proposals based on the same request
  • Option to hide or show the AI Assistant panel
  • Option for account owners to turn AI Assistant on or off

source: https://howto.caspio.com/release-notes/caspio-44-0/#:~:text=Enhancements to AI Assistant

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...