fetchmail_server

-1 rows


Description

Incoming Mail Server

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('fetchmail_server_id_seq'::regclass)
mail_mail.fetchmail_server_id mail_mail_fetchmail_server_id_fkey N
port int4 10 √ null

Port
object_id int4 10 √ null
ir_model.id fetchmail_server_object_id_fkey N

Create a New Record
priority int4 10 √ null

Server Priority
create_uid int4 10 √ null
res_users.id fetchmail_server_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
state varchar 2147483647 √ null

Status
server varchar 2147483647 √ null

Server Name
server_type varchar 2147483647 null

Server Type
user varchar 2147483647 √ null

Username
password varchar 2147483647 √ null

Password
script varchar 2147483647 √ null

Script
configuration text 2147483647 √ null

Configuration
active bool 1 √ null

Active
is_ssl bool 1 √ null

SSL/TLS
attach bool 1 √ null

Keep Attachments
original bool 1 √ null

Keep Original
date timestamp 29,6 √ null

Last Fetch Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
google_gmail_access_token_expiration int4 10 √ null

Access Token Expiration Timestamp
google_gmail_authorization_code varchar 2147483647 √ null

Authorization Code
google_gmail_refresh_token varchar 2147483647 √ null

Refresh Token
google_gmail_access_token varchar 2147483647 √ null

Access Token

Indexes

Constraint Name Type Sort Column(s)
fetchmail_server_pkey Primary key Asc id
fetchmail_server__server_type_index Performance Asc server_type
fetchmail_server__state_index Performance Asc state

Relationships

Close relationships within degrees of separation