View alter.public.mis_fast_purc_payments Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
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_payment_id int4 10  √  null
mis_purc_payments.purc_payment_id Implied Constraint
purc_paydate_id int4 10  √  null
mis_purc_paydates.purc_paydate_id Implied Constraint
payment_date date 13  √  null
payment_amount numeric 13,2  √  null
mov_account_id int4 10  √  null
mis_mov_accounts.mov_account_id Implied Constraint
is_accounted_p bool 1  √  null
payment_date_pretty text 2147483647  √  null
payment_date_widget text 2147483647  √  null
payment_amount_pretty varchar 2147483647  √  null

Close relationships: