Tables : res_partner_category


Columns

10

Keys

1

Triggers

0

Comment:

Description:

Indexes

2

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
parent_path parent_path CHARACTER VARYING
name name CHARACTER VARYING
color color INTEGER
parent_id parent_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
res_partner_category_pkey true

Indexes

Name UNIQUE Type Description
res_partner_category_parent_path_index Ascending
res_partner_category_parent_id_index Ascending

Columns Detail :

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

Name parent_path
Table res_partner_category
Type CHARACTER VARYING
Domain

Name name
Table res_partner_category
Type CHARACTER VARYING
Domain
Not null true

Name color
Table res_partner_category
Type INTEGER
Domain

Name parent_id
Table res_partner_category
Type INTEGER
Domain
Foreign key true

Name active
Table res_partner_category
Type BOOLEAN
Domain

Name create_uid
Table res_partner_category
Type INTEGER
Domain
Foreign key true

Name create_date
Table res_partner_category
Type TIMESTAMP(6)
Domain

Name write_uid
Table res_partner_category
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_partner_category
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description