Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
alter
.
public
.
mis_fast_purc_payments
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_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: