print_form

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
outlet.print_form_id outlet_print_form_id_fkey N
inclusion.printform_id inclusion_printform_fk R
name text 2147483647 √ null
form_type text 2147483647 √ null

Print-form category, for example folio, register_card, proforma_invoice, tax_invoice, receipt, or reservation_slip.
source_file text 2147483647 √ null

Report template file name or identifier; binary template content is not stored in PostgreSQL.
header_text text 2147483647 √ null
footer_text text 2147483647 √ null
custom_text1 text 2147483647 √ null
custom_text2 text 2147483647 √ null
address1 text 2147483647 √ null
address2 text 2147483647 √ null
address3 text 2147483647 √ null
address4 text 2147483647 √ null
email text 2147483647 √ null
telephone text 2147483647 √ null
fax text 2147483647 √ null
website text 2147483647 √ null
logo_url text 2147483647 √ null

Public S3/CDN URL generated through rpc.utility_gen_file_url using file_category print_form_logo.
is_default bool 1 false

True for the form selected by sp_print_form_header; at most one default is allowed per form_type.
custom_text3 text 2147483647 √ null
custom_text4 text 2147483647 √ null
company text 2147483647 √ null

Company name override for this form, primary language; null falls back to property_info.company.
company2 text 2147483647 √ null

Company name override for this form, secondary language; null falls back to property_info.company2.

Indexes

Constraint Name Type Sort Column(s)
print_form_pkey Primary key Asc id
print_form_one_default_per_type_idx Must be unique Asc form_type

Check Constraints

Constraint Name Constraint
print_form_default_requires_form_type ((NOT is_default) OR (form_type IS NOT NULL))

Relationships

Close relationships within degrees of separation