ir_rule

173 rows


Description

Record Rule

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_rule_id_seq'::regclass)
rule_group_rel.rule_group_id rule_group_rel_rule_group_id_fkey C
model_id int4 10 null
ir_model.id ir_rule_model_id_fkey C

Model
create_uid int4 10 √ null
res_users.id ir_rule_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id ir_rule_write_uid_fkey N

Last Updated by
name varchar 2147483647 √ null

Name
domain_force text 2147483647 √ null

Domain
active bool 1 √ null

Active
perm_read bool 1 √ null

Read
perm_write bool 1 √ null

Write
perm_create bool 1 √ null

Create
perm_unlink bool 1 √ null

Delete
global bool 1 √ null

Global
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
ir_rule_pkey Primary key Asc id
ir_rule__model_id_index Performance Asc model_id
ir_rule__name_index Performance Asc name

Check Constraints

Constraint Name Constraint
ir_rule_no_access_rights (((perm_read <> false) OR (perm_write <> false) OR (perm_create <> false) OR (perm_unlink <> false)))

Relationships

Close relationships within degrees of separation