Tables : ir_rule


Columns

14

Keys

1

Triggers

0

Comment:

Description:

Indexes

2

Contraints

1


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
active active BOOLEAN
model_id model_id INTEGER
domain_force domain_force TEXT
perm_read perm_read BOOLEAN
perm_write perm_write BOOLEAN
perm_create perm_create BOOLEAN
perm_unlink perm_unlink BOOLEAN
global global BOOLEAN
create_uid create_uid INTEGER
create_date create_date TIMESTAMP(6)
write_uid write_uid INTEGER
write_date write_date TIMESTAMP(6)

Keys :

Name Primary Key Description
ir_rule_pkey true

Indexes

Name UNIQUE Type Description
ir_rule_model_id_index Ascending
ir_rule_name_index Ascending

Constraints

Name Expression Description
ir_rule_no_access_rights

(((perm_read <> false) OR (perm_write <> false) OR (perm_create <> false) OR (perm_unlink <> false)))

Columns Detail :

Name id
Table ir_rule
Type INTEGER
Domain
Primary Key true
Not null true
Default Value nextval('ir_rule_id_seq'::regclass)

Name name
Table ir_rule
Type CHARACTER VARYING
Domain

Name active
Table ir_rule
Type BOOLEAN
Domain

Name model_id
Table ir_rule
Type INTEGER
Domain
Not null true
Foreign key true

Name domain_force
Table ir_rule
Type TEXT
Domain

Name perm_read
Table ir_rule
Type BOOLEAN
Domain

Name perm_write
Table ir_rule
Type BOOLEAN
Domain

Name perm_create
Table ir_rule
Type BOOLEAN
Domain

Name
Table ir_rule
Type BOOLEAN
Domain

Name global
Table ir_rule
Type BOOLEAN
Domain

Name create_uid
Table ir_rule
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_rule
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_rule
Type INTEGER
Domain
Foreign key true

Name write_date
Table ir_rule
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description