Tables : ir_filters


Columns

14

Keys

2

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
user_id user_id INTEGER
domain domain TEXT
context context TEXT
sort sort TEXT
model_id model_id CHARACTER VARYING
is_default is_default BOOLEAN
action_id action_id INTEGER
active active 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_filters_pkey true
ir_filters_name_model_uid_unique

Indexes

Name UNIQUE Type Description
ir_filters_name_model_uid_unique_action_index true Ascending

Columns Detail :

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

Name name
Table ir_filters
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name user_id
Table ir_filters
Type INTEGER
Domain
Foreign key true
Unique true

Name domain
Table ir_filters
Type TEXT
Domain
Not null true

Name context
Table ir_filters
Type TEXT
Domain
Not null true

Name sort
Table ir_filters
Type TEXT
Domain
Not null true

Name model_id
Table ir_filters
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name is_default
Table ir_filters
Type BOOLEAN
Domain

Name action_id
Table ir_filters
Type INTEGER
Domain
Unique true

Name active
Table ir_filters
Type BOOLEAN
Domain

Name create_uid
Table ir_filters
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_filters
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_filters
Type INTEGER
Domain
Foreign key true

Name write_date
Table ir_filters
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description