Difference between Referenced and Referencing Table Relations?

SB87
Tera Expert

Hi,

When reviewing table schema's I noticed there are the following filters:

  • referenced tables = ?
  • referencing tables = I assume this means means the table is referencing another table e.g. 'problem.reopened_by' references the sys_user table. 
  • extended tables = I assume this means one table is extending another  e.g. if I was focused on the Problem table, then Task is the extended table, since Problem extends Task?
  • extending tables = ?

Can someone please provide a simple/clear definition of all of the above? 

1 REPLY 1

Santon
Tera Contributor

In Schema Map there is referencing and referenced and extending and extended Tables.

 

Extended tables are parent tables 

Extending tables are child tables

 

When a record from one table draws info from a record belonging to another table then it is called a child table

And vice versa it is called parent table.

 

Eg Incidents table is child and task table is Parent . You would see entire record info from a task table inside your incident record

 

When info from one field is drawn from one table to another table it is called referenced

 eg In an Incident form the user name entered is taken from sys_user table

Here the sys_user is the referenced table for Incident table

Similiarly for sys_user table Incident table is the referencing table

 

Reference is where just a field from another table is drawn

Extend is where the entire record from another table is drawn in

 

I hope this is easy and less confusing