Difference between Referenced and Referencing Table Relations?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2022 08:12 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2025 07:00 AM
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