Tables : ir_module_module


Columns

29

Keys

3

Triggers

0

Comment:

Description:

Indexes

3

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
create_uid create_uid INTEGER
create_date create_date TIMESTAMP(6)
write_date write_date TIMESTAMP(6)
write_uid write_uid INTEGER
website website CHARACTER VARYING
summary summary CHARACTER VARYING
name name CHARACTER VARYING
author author CHARACTER VARYING
icon icon CHARACTER VARYING
state state CHARACTER VARYING(16)
latest_version latest_version CHARACTER VARYING
shortdesc shortdesc CHARACTER VARYING
category_id category_id INTEGER
description description TEXT
application application BOOLEAN
demo demo BOOLEAN
web web BOOLEAN
license license CHARACTER VARYING(32)
sequence sequence INTEGER
auto_install auto_install BOOLEAN
to_buy to_buy BOOLEAN
maintainer maintainer CHARACTER VARYING
contributors contributors TEXT
published_version published_version CHARACTER VARYING
url url CHARACTER VARYING
menus_by_module menus_by_module TEXT
reports_by_module reports_by_module TEXT
views_by_module views_by_module TEXT

Keys :

Name Primary Key Description
ir_module_module_pkey true
name_uniq
ir_module_module_name_uniq

Indexes

Name UNIQUE Type Description
ir_module_module_state_index Ascending
ir_module_module_category_id_index Ascending
ir_module_module_name_index Ascending

Columns Detail :

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

Name create_uid
Table ir_module_module
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_module_module
Type TIMESTAMP(6)
Domain

Name write_date
Table ir_module_module
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_module_module
Type INTEGER
Domain
Foreign key true

Name website
Table ir_module_module
Type CHARACTER VARYING
Domain

Name summary
Table ir_module_module
Type CHARACTER VARYING
Domain

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

Name author
Table ir_module_module
Type CHARACTER VARYING
Domain

Name icon
Table ir_module_module
Type CHARACTER VARYING
Domain

Name state
Table ir_module_module
Type CHARACTER VARYING(16)
Domain

Name latest_version
Table ir_module_module
Type CHARACTER VARYING
Domain

Name shortdesc
Table ir_module_module
Type CHARACTER VARYING
Domain

Name category_id
Table ir_module_module
Type INTEGER
Domain
Foreign key true

Name description
Table ir_module_module
Type TEXT
Domain

Name application
Table ir_module_module
Type BOOLEAN
Domain
Default Value false

Name demo
Table ir_module_module
Type BOOLEAN
Domain
Default Value false

Name web
Table ir_module_module
Type BOOLEAN
Domain
Default Value false

Name license
Table ir_module_module
Type CHARACTER VARYING(32)
Domain

Name sequence
Table ir_module_module
Type INTEGER
Domain
Default Value 100

Name auto_install
Table ir_module_module
Type BOOLEAN
Domain
Default Value false

Name to_buy
Table ir_module_module
Type BOOLEAN
Domain
Default Value false

Name maintainer
Table ir_module_module
Type CHARACTER VARYING
Domain

Name contributors
Table ir_module_module
Type TEXT
Domain

Name published_version
Table ir_module_module
Type CHARACTER VARYING
Domain

Name url
Table ir_module_module
Type CHARACTER VARYING
Domain

Name menus_by_module
Table ir_module_module
Type TEXT
Domain

Name reports_by_module
Table ir_module_module
Type TEXT
Domain

Name views_by_module
Table ir_module_module
Type TEXT
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description