View alter.public.mis_purc_paydates_view

Generated by SchemaSpy

Implied relationships Related columns Constraint names Comments Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents Comments purc_paydate_id int4 10  √  null mis_purc_paydates.purc_paydate_id Implied Constraint purc_invoice_id int4 10  √  null mis_purc_invoices.purc_invoice_id Implied Constraint pay_date date 13  √  null is_invoice bool 1  √  null invoice_type_code varchar 3  √  null pay_date_pretty text 2147483647  √  null vendor_id int4 10  √  null invoice_date date 13  √  null invoice_date_pretty text 2147483647  √  null invoice_num varchar 30  √  null invoice_ref_num varchar 20  √  null invoice_ref_date date 13  √  null invoice_ref_date_pretty text 2147483647  √  null payment_id int4 10  √  null mis_payments.payment_id Implied Constraint bank_id int4 10  √  null mis_banks.bank_id Implied Constraint invoice_notes text 2147483647  √  null real_invoice_amount numeric 13,2  √  null invoice_amount numeric 131089  √  null real_invoice_amount_pretty varchar 2147483647  √  null invoice_amount_pretty varchar 2147483647  √  null real_ra_amount numeric 13,2  √  null ra_amount numeric 131089  √  null real_amount numeric 13,2  √  null amount numeric 131089  √  null real_amount_pretty varchar 2147483647  √  null amount_pretty varchar 2147483647  √  null is_effect_p bool 1  √  null is_closed_p bool 1  √  null effect_bank_id int4 10  √  null

Close relationships: