View alter.public.mis_fast_rec_notes

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 po_code varchar 20  √  null po_date date 13  √  null po_date_pretty text 2147483647  √  null po_date_widget text 2147483647  √  null vendor_id int4 10  √  null vendor_code varchar 30  √  null vendor_name varchar 1000  √  null iva_id int4 10  √  null mis_iva.iva_id Implied Constraint rec_id int4 10  √  null mis_rec_notes.rec_id Implied Constraint rec_code varchar 10  √  null rec_date date 13  √  null rec_type varchar 8  √  null bill_type_id int4 10  √  null mis_bill_types.bill_type_id Implied Constraint po_id int4 10  √  null mis_pos.po_id Implied Constraint delivery_code varchar 30  √  null delivery_date date 13  √  null bank_id int4 10  √  null mis_banks.bank_id Implied Constraint payment_id int4 10  √  null mis_payments.payment_id Implied Constraint port_id int4 10  √  null shipping_id int4 10  √  null packaging_id int4 10  √  null package_no int4 10  √  null net_weight numeric 11,2  √  null gross_weight numeric 11,2  √  null rec_text text 2147483647  √  null is_approved_p bool 1  √  null store_id int4 10  √  null mis_stores.store_id Implied Constraint rec_date_pretty text 2147483647  √  null rec_date_widget text 2147483647  √  null delivery_date_pretty text 2147483647  √  null delivery_date_widget text 2147483647  √  null net_weight_pretty varchar 2147483647  √  null gross_weight_pretty varchar 2147483647  √  null object_id int4 10  √  null acs_objects.object_id Implied Constraint object_type varchar 100  √  null title varchar 1000  √  null package_id int4 10  √  null apm_packages.package_id Implied Constraint context_id int4 10  √  null security_inherit_p bool 1  √  null creation_user int4 10  √  null creation_date timestamptz 35,6  √  null creation_ip varchar 50  √  null last_modified timestamptz 35,6  √  null modifying_user int4 10  √  null modifying_ip varchar 50  √  null tree_sortkey varbit 2147483647  √  null max_child_sortkey varbit 2147483647  √  null item_id int4 10  √  null

Close relationships: