Help

0

Many2one relationship, meaning of index and copy

Avatar
E.M.

order_id = fields.Many2one('sale.order', string='Order Reference', required=True, ondelete='cascade', index=True, copy=False)


What index and copy means?

What about ondelete='cascade'?

头像
丢弃
1 答案
14
Avatar
Nilmar Shereef
Best Answer

copy=False
If you put copy=False to a field, When you duplicate a record, That value is not copied to duplicating (Newly created)record.

ondelete='cascade'

If you put this to a Many2one field, the deletion of record will cause to deletion of one2one records according to that record.
Eg:

When you delete a Sale Order, It will delete sale order lines also.

Index=True

you can speed the database search performance. However, you should be careful not to add indexes on too many fields because the size of the database can rapidly increase. What means, you should carefully detect the most searchable fields and to create indexes for them only.

Hope it may help you :)

2 注释
头像
丢弃
Avatar
E.M.
-

Thanks, it helps.

Avatar
Nilmar Shereef
-

Happy To help you. :)