View alter.public.mis_quotations_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 quotation_id int4 10  √  null mis_quotations.quotation_id Implied Constraint vendor_id int4 10  √  null product_id int4 10  √  null mis_products.product_id Implied Constraint start_date date 13  √  null start_date_pretty text 2147483647  √  null start_date_widget text 2147483647  √  null end_date date 13  √  null end_date_pretty text 2147483647  √  null end_date_widget text 2147483647  √  null codea bpchar 3  √  null currencies.codea Implied Constraint purc_um_id int4 10  √  null conversion_factor float8 17,17  √  null product_price numeric 17,5  √  null discount numeric 5,2  √  null discount_2 numeric 5,2  √  null discount_3 numeric 5,2  √  null purc_um_code varchar 2147483647  √  null conversion_factor_pretty varchar 2147483647  √  null product_price_pretty varchar 2147483647  √  null product_net_price numeric 131089  √  null product_net_price_pretty varchar 2147483647  √  null discount_pretty varchar 2147483647  √  null discount_2_pretty varchar 2147483647  √  null discount_3_pretty varchar 2147483647  √  null vendor_code varchar 30  √  null vendor_name varchar 1000  √  null product_code varchar 40  √  null upper_title varchar 1000  √  null product_description varchar 1000  √  null um_id int4 10  √  null mis_um.um_id Implied Constraint brand_id int4 10  √  null um_code varchar 2147483647  √  null vendor_product_code varchar 2147483647  √  null

Close relationships: