snailmail_letter

-1 rows


Description

Snailmail Letter

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('snailmail_letter_id_seq'::regclass)
mail_notification.letter_id mail_notification_letter_id_fkey C
snailmail_letter_missing_required_fields.letter_id snailmail_letter_missing_required_fields_letter_id_fkey N
user_id int4 10 √ null
res_users.id snailmail_letter_user_id_fkey N

Sent by
res_id int4 10 null

Document ID
partner_id int4 10 null
res_partner.id snailmail_letter_partner_id_fkey R

Recipient
company_id int4 10 null
res_company.id snailmail_letter_company_id_fkey R

Company
report_template int4 10 √ null
ir_act_report_xml.id snailmail_letter_report_template_fkey N

Optional report to print and attach
attachment_id int4 10 √ null
ir_attachment.id snailmail_letter_attachment_id_fkey C

Attachment
message_id int4 10 √ null
mail_message.id snailmail_letter_message_id_fkey N

Snailmail Status Message
state_id int4 10 √ null
res_country_state.id snailmail_letter_state_id_fkey N

State
country_id int4 10 √ null
res_country.id snailmail_letter_country_id_fkey N

Country
create_uid int4 10 √ null
res_users.id snailmail_letter_create_uid_fkey N

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

Last Updated by
model varchar 2147483647 null

Model
state varchar 2147483647 null

Status
error_code varchar 2147483647 √ null

Error
info_msg varchar 2147483647 √ null

Information
street varchar 2147483647 √ null

Street
street2 varchar 2147483647 √ null

Street2
zip varchar 2147483647 √ null

Zip
city varchar 2147483647 √ null

City
color bool 1 √ null

Color
cover bool 1 √ null

Cover Page
duplex bool 1 √ null

Both side
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
snailmail_letter_pkey Primary key Asc id
snailmail_letter__attachment_id_index Performance Asc attachment_id
snailmail_letter__message_id_index Performance Asc message_id

Relationships

Close relationships within degrees of separation