View alter.public.mis_purc_operations

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 invoice_year int4 10  √  null vendor_id int4 10  √  null vendor_code varchar 30  √  null vendor_description varchar 1000  √  null invoice_type_id int4 10  √  null mis_invoice_types.invoice_type_id Implied Constraint fiscal_code text 2147483647  √  null iva_code text 2147483647  √  null iva_id int4 10  √  null mis_iva.iva_id Implied Constraint is_invoice bool 1  √  null acct_schema_id int4 10  √  null mis_acct_schema.acct_schema_id Implied Constraint ivable_amount numeric 131089  √  null iva_amount numeric 131089  √  null iva_type varchar 1  √  null

Close relationships: