View alter.public.mis_fast_parties

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 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 party_id int4 10  √  null mis_parties.party_id Implied Constraint party_code varchar 30  √  null party_type bpchar 1  √  null party_type_id int4 10  √  null iva_code bpchar 11  √  null iva_id int4 10  √  null mis_iva.iva_id Implied Constraint fiscal_code bpchar 16  √  null is_active_p bool 1  √  null is_customer_p bool 1  √  null is_vendor_p bool 1  √  null upper_title varchar 1000  √  null description text 2147483647  √  null language_id bpchar 2  √  null language_codes.language_id Implied Constraint currency bpchar 3  √  null discount numeric 5,2  √  null credit_limit numeric 13,2  √  null ddt_grouping_p bool 1  √  null company_bank_id int4 10  √  null port_id int4 10  √  null payment_id int4 10  √  null mis_payments.payment_id Implied Constraint shipping_id int4 10  √  null zone_id int4 10  √  null sale_rep_id int4 10  √  null default_address_id int4 10  √  null discount_pretty varchar 2147483647  √  null credit_limit_pretty varchar 2147483647  √  null address_id int4 10  √  null mis_addresses.address_id Implied Constraint address_code varchar 10  √  null address_name varchar 32  √  null address1 varchar 32  √  null address2 varchar 32  √  null subaddr varchar 100  √  null city varchar 32  √  null province varchar 4  √  null state varchar 32  √  null zipcode varchar 10  √  null country_iso bpchar 2  √  null contact text 2147483647  √  null phone varchar 35  √  null fax varchar 35  √  null email text 2147483647  √  null url varchar 100  √  null cc bpchar 12  √  null bank_id int4 10  √  null mis_banks.bank_id Implied Constraint cc_iban bpchar 2  √  null cin bpchar 1  √  null

Close relationships: