Table extension functionality allows sharing fields and records with a parent table. Administrators and developers extend tables during table creation.
Typically, tables are extended to create a set of records that share information with each other.
In the use case listed below, the Task table has multiple extensions:
| Original table | Extended tables |
|---|---|
| Task |
|
A table extending another table is called a child table, and a table extended by it is called a parent table. A table can be both a parent and a child at the same time.
Table extending causes the following:
- Cross-table linking between from the new table to the extending one;
- System fields are created in the new table (like the sys_id field).
To check out dependencies between tables, the Show Schema tool can be used (described below).
