Tables : ir_mail_server


Columns

14

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
smtp_host smtp_host CHARACTER VARYING
smtp_port smtp_port INTEGER
smtp_user smtp_user CHARACTER VARYING
smtp_pass smtp_pass CHARACTER VARYING
smtp_encryption smtp_encryption CHARACTER VARYING
smtp_debug smtp_debug BOOLEAN
sequence sequence 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_mail_server_pkey true

Indexes

Name UNIQUE Type Description
ir_mail_server_name_index Ascending

Columns Detail :

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

Name name
Table ir_mail_server
Type CHARACTER VARYING
Domain
Not null true

Name smtp_host
Table ir_mail_server
Type CHARACTER VARYING
Domain
Not null true

Name smtp_port
Table ir_mail_server
Type INTEGER
Domain
Not null true

Name smtp_user
Table ir_mail_server
Type CHARACTER VARYING
Domain

Name smtp_pass
Table ir_mail_server
Type CHARACTER VARYING
Domain

Name smtp_encryption
Table ir_mail_server
Type CHARACTER VARYING
Domain
Not null true

Name smtp_debug
Table ir_mail_server
Type BOOLEAN
Domain

Name sequence
Table ir_mail_server
Type INTEGER
Domain

Name active
Table ir_mail_server
Type BOOLEAN
Domain

Name create_uid
Table ir_mail_server
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_mail_server
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_mail_server
Type INTEGER
Domain
Foreign key true

Name write_date
Table ir_mail_server
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description