Jump to content

Question

6 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 post
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 post
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

Regards

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

Link to post
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.

Guest
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.

Loading...
×
×
  • Create New...