Table "Table Relations Metadata"
Virtual table that exposes metadata about table relationships defined in the system.
Remarks
This table provides detailed information about field relationships between tables, including foreign key constraints, conditions, and validation settings. Essential for understanding database schema relationships and building dynamic data integrity validations. Used by tools that need to analyze or validate table relationships programmatically. The table is not per-company and provides read-only access to relationship metadata across all tables in the system.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
| InherentPermissions | rX |
Fields
| Name | Type | Description |
|---|---|---|
| "Table ID" | Integer | The ID of the source table that contains the field with the relationship. |
| "Field No." | Integer | The field number in the source table that has the relationship definition. |
| "Relation No." | Integer | The sequence number of the relationship when multiple relationships exist for the same field. |
| "Condition No." | Integer | The sequence number of the condition when multiple conditions exist for the same relationship. |
| "Related Table ID" | Integer | The ID of the target table that the field relates to. |
| "Related Field No." | Integer | The field number in the related table that this field references. |
| "Condition Type" | Option | The type of condition applied to this table relationship (CONST or FILTER). |
| "Condition Field No." | Integer | The field number used in the relationship condition. |
| "Condition Value" | Text[30] | The value used in the relationship condition when condition type is CONST. |
| "Test Table Relation" | Boolean | Indicates whether the table relation should be tested for validity. |
| "Validate Table Relation" | Boolean | Indicates whether the table relation should be validated during data entry. |
| "Table Name" | Text[30] | The name of the source table. |
| "Field Name" | Text[30] | The name of the field in the source table. |
| "Related Table Name" | Text[30] | The name of the related target table. |
| "Related Field Name" | Text[30] | The name of the field in the related table. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |