.. extensions:


Table Extensions
================

The following table extensions habe been made in the PostgreSQL database. The additional fields must be added directly in ``Odoo`` as also to adapt the fields to the corresponding database models.

1. Table **product_template**

Additional fields:

== ============ ========= ======= ====================== =======================================================
\  column_name  data_type indexed foreign_key 			     comment
== ============ ========= ======= ====================== =======================================================
42 x_partner_id many2one  yes     public.res_partner(id) partner of the product (reference to table res_partner)
43 x_place      varchar   yes                            logical place of the product
44 x_rfid_id    varchar   yes                            RFID tag identifier of the product
== ============ ========= ======= ====================== =======================================================

Used by the program :func:`odoo_xmlrpc_twisted.functions.create_product` and other. The database model is **product**.

The field ``x_place`` store the logical place of the product. Possible values:

  - Error
  - Init
  - Home
  - Storage
  - Lend
  - Sale
  - Transfer
  - Disposal
  - Donation

|

1. Table **res_users**

Additional fields:

== =================== ========= ======= =========== ===============================
\  column_name         data_type indexed foreign_key comment
== =================== ========= ======= =========== ===============================
29 x_activate_token    varchar   no                  individual activation token
30 x_activate_date     timestamp no                  end date for the activation
31 x_activate_complete bool      no                  activation of user is completed
32 x_reset_token       varchar   no                  individual reset token
33 x_reset_date        timestamp no                  end date for the reset
34 x_reset_complete    bool      no                  reset of user is completed
== =================== ========= ======= =========== ===============================

Used by the programs :func:`odoo_xmlrpc_twisted.functions.create_user` and other. The database model is **User**.