View alter.public.mis_acct_mov_view 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
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: