Contains mappings and metadata for Odoo relational fields (many2one, many2many) to identify dependencies, support module development, and ensure data integrity.

View-Specific Information

Select

The connector uses the Odoo API to filter the results by the following columns and operators:

Column	Supported Operators
ReferenceTable	=

To select from FieldReferences use the following query:

    SELECT * FROM FieldReferences WHERE ReferenceTable = 'account_account';

The rest of the filter is executed client-side within the connector.

Columns

Name	Type	References	Description
ReferenceTable	String		The name of the source table that contains the reference field, which points to a key field in another table to establish a relational link.
ReferenceColumn	String		The specific column within the source table that holds the reference to a field in a different table. This is typically a foreign key used to enforce referential integrity.
TargetTable	String		The name of the target table whose primary key or unique field is referenced by the column specified in the source table. This defines the relationship endpoint.
IsMultiValued	Boolean		Indicates whether the reference column is designed to store multiple values, meaning it can hold a list of references instead of a single one. This is common in many-to-many relationships or JSON-based field storage.