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.
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 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
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 odoo_xmlrpc_twisted.functions.create_user() and other. The database model is User.