Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
alter
.
public
.
mis_acct_mov_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
acct_mov_id
int4
10
√
null
mis_acct_mov
.acct_mov_id
Implied Constraint
acct_mov_date
date
13
√
null
acct_mov_record_date
date
13
√
null
acct_schema_id
int4
10
√
null
mis_acct_schema
.acct_schema_id
Implied Constraint
acct_mov_ref_doc
varchar
100
√
null
acct_mov_ref_date
date
13
√
null
acct_mov_description
varchar
100
√
null
acct_mov_amount
numeric
13,2
√
null
is_revert_p
bool
1
√
null
is_corrected_p
bool
1
√
null
document_id
int4
10
√
null
acct_mov_user
int4
10
√
null
acct_mov_date_pretty
text
2147483647
√
null
acct_mov_date_widget
text
2147483647
√
null
acct_mov_ref_date_pretty
text
2147483647
√
null
acct_mov_ref_date_widget
text
2147483647
√
null
acct_mov_record_date_pretty
text
2147483647
√
null
acct_mov_record_date_widget
text
2147483647
√
null
acct_mov_amount_pretty
varchar
2147483647
√
null
Close relationships: