invantive documentation
Invantive Support ForumsLog In / Sign Up

model_data: Odoo itgen_odoo_model_data

read only per partition

  • Catalog: Odoo
  • Schema: ir
  • Label: itgen_odoo_model_data

Model Data

Can only retrieve data.

Summary

Holds external identifier keys for records in the database. This has two main uses:

       * allows easy data integration with third-party systems,
         making import/export/sync of data possible, as records
         can be uniquely identified across multiple systems
       * allows tracking the origin of data installed by Odoo
         modules themselves, thus making it possible to later
         update them seamlessly.

Table Columns

The columns of the table model_data are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
complete_name varchar2 Complete ID
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
id int32 ID
model varchar2 Model Name
module varchar2 Module
name varchar2 External Identifier External Key/Identifier that can be used for data integration with third-party systems
noupdate boolean Non Updatable
reference varchar2 Reference
res_id int32 Record ID ID of the target record in the database
studio boolean Studio Checked if it has been edited with Studio.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: