Different types of Caspio tables

[TeamVilla]

Hi everybody, 

I have read everything about the 3 different types of Caspio tables; Master, Detail and Domain, but I still find it very hard to explain others the difference and when to use which. 

Does somebody have a simpel explanation when to use which tables type? 

[sandy159]

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

Regards

[TeamVilla]

Hi @sandy159, 

Thank you for your response! The links were definitely helpful, but my question remains: 

What is the difference between Master, Detail and Domain tables and when do you use which one?

Please help :-)

[ParkLoey]

Hi @TeamVilla,

I'm curious about these types of tables you mentioned. I've been creating Tables for quite some time now, but I haven't been able to run into these types. Would it be possible if you could provide links where you've read about them? Thanks!

[TeamVilla]

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?

[CoopperBackpack]

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. 

[trevortex]

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

Regards

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

[ParkLoey]

Hello! Just in case you guys haven't seen it yet, Caspio now has AI Assistant for help in creating tables:

https://howto.caspio.com/release-notes/caspio-43-0/#:~:text=Release Notes-,AI Assistant,-As we embark

[ParkLoey]

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

[Queso]

Hello @TeamVilla, you can watch this video tutorial by Ned on how to create a table in Caspio: