SchemaSpy Analysis of alter.public - Constraints Generated by
SchemaSpy
273 Foreign Key Constraints:
SourceForge.net
Please support this project

Constraint Name Child Column Parent Column
acs_object_types_supertype_fk acs_object_types.supertype acs_object_types.object_type
acs_objects_context_id_fk acs_objects.context_id acs_objects.object_id
acs_objects_creation_user_fk acs_objects.creation_user users.user_id
acs_objects_modifying_user_fk acs_objects.modifying_user users.user_id
acs_objects_object_type_fk acs_objects.object_type acs_object_types.object_type
acs_objects_package_id_fk acs_objects.package_id apm_packages.package_id
apm_packages_package_id_fk apm_packages.package_id acs_objects.object_id
apm_packages_package_key_fk apm_packages.package_key apm_package_types.package_key
auth_authorities_aid_fk auth_authorities.authority_id acs_objects.object_id
auth_authority_auth_impl_fk auth_authorities.auth_impl_id acs_objects.object_id
auth_authority_getdoc_impl_fk auth_authorities.get_doc_impl_id acs_objects.object_id
auth_authority_procdoc_impl_fk auth_authorities.process_doc_impl_id acs_objects.object_id
auth_authority_pwd_impl_fk auth_authorities.pwd_impl_id acs_objects.object_id
auth_authority_reg_impl_fk auth_authorities.register_impl_id acs_objects.object_id
auth_authority_userinf_impl_fk auth_authorities.user_info_impl_id acs_objects.object_id
cat_category_id_fk categories.category_id acs_objects.object_id
cat_parent_id_fk categories.parent_id categories.category_id
cat_tree_id_fk categories.tree_id category_trees.tree_id
cat_trees_tree_id_fk category_trees.tree_id acs_objects.object_id
mis_accounts_account_id_fkey mis_accounts.account_id acs_objects.object_id
mis_acct_mov_acct_mov_user_fkey mis_acct_mov.acct_mov_user users.user_id
mis_acct_mov_acct_schema_id_fkey mis_acct_mov.acct_schema_id mis_acct_schema.acct_schema_id
mis_acct_mov_document_id_fkey mis_acct_mov.document_id acs_objects.object_id
mis_acct_plan_acct_plan_type_id_fkey mis_acct_plan.acct_plan_type_id mis_acct_plan_types.acct_plan_type_id
mis_acct_plan_child_id_fkey mis_acct_plan.child_id mis_accounts.account_id
mis_acct_plan_parent_id_fkey mis_acct_plan.parent_id mis_accounts.account_id
mis_addresses_bank_id_fkey mis_addresses.bank_id mis_banks.bank_id
mis_addresses_country_iso_fkey mis_addresses.country_iso countries.iso
mis_addresses_party_id_fkey mis_addresses.party_id mis_parties.party_id
mis_bank_accounts_account_id_fkey mis_bank_accounts.account_id mis_accounts.account_id
mis_bank_accounts_bank_id_fkey mis_bank_accounts.bank_id mis_banks.bank_id
mis_bank_accounts_factoring_account_id_fkey mis_bank_accounts.factoring_account_id mis_accounts.account_id
mis_bank_accounts_pres_account_id_fkey mis_bank_accounts.pres_account_id mis_accounts.account_id
mis_bank_accounts_unsolved_account_id_fkey mis_bank_accounts.unsolved_account_id mis_accounts.account_id
mis_banks_effect_bank_id_fkey mis_banks.effect_bank_id mis_banks.bank_id
mis_bid_lines_bid_id mis_bid_lines.bid_id mis_bids.bid_id
mis_bid_lines_line_id_fkey mis_bid_lines.line_id acs_objects.object_id
mis_bid_lines_product_id mis_bid_lines.product_id mis_products.product_id
mis_bid_lines_sell_um_id mis_bid_lines.sell_um_id mis_um.um_id
mis_bids_bid_id_fkey mis_bids.bid_id acs_objects.object_id
mis_bids_currency_fk mis_bids.currency currencies.codea
mis_bids_customer_id_fk mis_bids.customer_id mis_parties.party_id
mis_bids_fk_address_id mis_bids.address_id mis_addresses.address_id
mis_bids_fk_bank_id mis_bids.bank_id mis_banks.bank_id
mis_bids_fk_carrier_id mis_bids.carrier_id categories.category_id
mis_bids_fk_guarantee_id mis_bids.guarantee_id categories.category_id
mis_bids_fk_language_id mis_bids.language_id language_codes.language_id
mis_bids_fk_payment_id mis_bids.payment_id mis_payments.payment_id
mis_bids_fk_port_id mis_bids.port_id categories.category_id
mis_bids_fk_shipping_id mis_bids.shipping_id categories.category_id
mis_bids_sale_rep_id_fk mis_bids.sale_rep_id categories.category_id
mis_bids_zone_id_fk mis_bids.zone_id categories.category_id
mis_bill_types_counter_id_fkey mis_bill_types.counter_id mis_counters.counter_id
mis_bill_types_from_mov_type_fkey mis_bill_types.from_mov_type mis_wh_mov_types.wh_mov_type_code
mis_bill_types_invoice_type_id_fkey mis_bill_types.invoice_type_id mis_invoice_types.invoice_type_id
mis_bill_types_to_mov_type_fkey mis_bill_types.to_mov_type mis_wh_mov_types.wh_mov_type_code
mis_centers_center_id_fkey mis_centers.center_id mis_accounts.account_id
mis_cust_price_map_customer_id_fkey mis_cust_price_map.customer_id mis_parties.party_id
mis_cust_price_map_price_list_id_fkey mis_cust_price_map.price_list_id mis_purc_price_lists.price_list_id
mis_customer_dates_effect_bank_id_fkey mis_customer_dates.effect_bank_id mis_banks.bank_id
mis_customer_dates_invoice_id_fkey mis_customer_dates.invoice_id mis_sale_invoices.sale_invoice_id
mis_customer_payments_date_id_fkey mis_customer_payments.date_id mis_sale_paydates.date_id
mis_customer_payments_mov_account_id_fkey mis_customer_payments.mov_account_id mis_mov_accounts.mov_account_id
mis_customer_payments_payment_type_id_fkey mis_customer_payments.payment_type_id mis_payment_types.payment_type_id
mis_customer_payments_presentation_bank_id_fkey mis_customer_payments.presentation_bank_id mis_banks.bank_id
mis_customer_payments_ref_payment_id_fkey mis_customer_payments.ref_payment_id mis_customer_payments.payment_id
mis_customers_products_map_customer_id_fkey mis_customers_products_map.customer_id mis_parties.party_id
mis_customers_products_map_product_id_fkey mis_customers_products_map.product_id mis_products.product_id
mis_delivery_note_lines_account_id_fkey mis_delivery_note_lines.account_id mis_accounts.account_id
mis_delivery_note_lines_delivery_id_fkey mis_delivery_note_lines.delivery_id mis_delivery_notes.delivery_id
mis_delivery_note_lines_delivery_line_id_fkey mis_delivery_note_lines.delivery_line_id acs_objects.object_id
mis_delivery_note_lines_iva_id_fkey mis_delivery_note_lines.iva_id mis_iva.iva_id
mis_delivery_note_lines_lot_id_fkey mis_delivery_note_lines.lot_id mis_product_lots.lot_id
mis_delivery_note_lines_product_id_fkey mis_delivery_note_lines.product_id mis_products.product_id
mis_delivery_note_lines_reference_id_fkey mis_delivery_note_lines.reference_id acs_objects.object_id
mis_delivery_note_lines_sell_um_id_fkey mis_delivery_note_lines.sell_um_id mis_um.um_id
mis_delivery_notes_address_id_fkey mis_delivery_notes.address_id mis_addresses.address_id
mis_delivery_notes_bank_id_fkey mis_delivery_notes.bank_id mis_banks.bank_id
mis_delivery_notes_bill_type_id_fkey mis_delivery_notes.bill_type_id mis_bill_types.bill_type_id
mis_delivery_notes_carrier_id_fkey mis_delivery_notes.carrier_id categories.category_id
mis_delivery_notes_delivery_id_fkey mis_delivery_notes.delivery_id acs_objects.object_id
mis_delivery_notes_language_id_fkey mis_delivery_notes.language_id language_codes.language_id
mis_delivery_notes_order_id_fkey mis_delivery_notes.order_id mis_orders.order_id
mis_delivery_notes_packaging_id_fkey mis_delivery_notes.packaging_id categories.category_id
mis_delivery_notes_party_id_fkey mis_delivery_notes.party_id mis_parties.party_id
mis_delivery_notes_payment_id_fkey mis_delivery_notes.payment_id mis_payments.payment_id
mis_delivery_notes_port_id_fkey mis_delivery_notes.port_id categories.category_id
mis_delivery_notes_sale_rep_id_fkey mis_delivery_notes.sale_rep_id categories.category_id
mis_delivery_notes_shipping_id_fkey mis_delivery_notes.shipping_id categories.category_id
mis_delivery_notes_store_id_fkey mis_delivery_notes.store_id mis_stores.store_id
mis_delivery_notes_zone_id_fkey mis_delivery_notes.zone_id categories.category_id
mis_effects_effect_bank_id_fkey mis_effects.effect_bank_id mis_banks.bank_id
mis_effects_payment_id_fkey mis_effects.payment_id mis_customer_payments.payment_id
mis_export_declarations_party_id_fkey mis_export_declarations.party_id mis_parties.party_id
mis_inventories_inv_location_id_fkey mis_inventories.inv_location_id mis_store_locations.location_id
mis_inventories_inv_lot_id_fkey mis_inventories.inv_lot_id mis_product_lots.lot_id
mis_inventories_inv_product_id_fkey mis_inventories.inv_product_id mis_products.product_id
mis_inventories_inv_store_id_fkey mis_inventories.inv_store_id mis_stores.store_id
mis_invoice_types_acct_schema_id_fkey mis_invoice_types.acct_schema_id mis_acct_schema.acct_schema_id
mis_invoice_types_counter_id_fkey mis_invoice_types.counter_id mis_counters.counter_id
mis_invoice_types_invoice_type_ref_id_fkey mis_invoice_types.invoice_type_ref_id mis_invoice_types.invoice_type_id
mis_iva_ctr_counter_id_fkey mis_iva_ctr.counter_id mis_counters.counter_id
mis_mov_accounts_account_id_fkey mis_mov_accounts.account_id mis_accounts.account_id
mis_mov_accounts_acct_mov_id_fkey mis_mov_accounts.acct_mov_id mis_acct_mov.acct_mov_id
mis_mr_lines_line_id_fk mis_mr_lines.line_id acs_objects.object_id
mis_mr_lines_mr_id_fk mis_mr_lines.mr_id mis_mrs.mr_id
mis_mr_lines_product_id_fk mis_mr_lines.product_id mis_products.product_id
mis_mrs_account_id_fk mis_mrs.account_id mis_accounts.account_id
mis_mrs_mr_id_fk mis_mrs.mr_id acs_objects.object_id
mis_mrs_store_id_fk mis_mrs.store_id mis_stores.store_id
mis_order_lines_line_id_fkey mis_order_lines.line_id acs_objects.object_id
mis_order_lines_order_id mis_order_lines.order_id mis_orders.order_id
mis_order_lines_product_id mis_order_lines.product_id mis_products.product_id
mis_order_lines_sell_um_id mis_order_lines.sell_um_id mis_um.um_id
mis_order_lines_store_id mis_order_lines.store_id mis_stores.store_id
mis_orders_address_id_fk mis_orders.address_id mis_addresses.address_id
mis_orders_bid_id_fk mis_orders.bid_id mis_bids.bid_id
mis_orders_currency_fk mis_orders.currency currencies.codea
mis_orders_customer_id_fk mis_orders.customer_id mis_parties.party_id
mis_orders_fk_bank_id mis_orders.bank_id mis_banks.bank_id
mis_orders_fk_guarantee_id mis_orders.guarantee_id categories.category_id
mis_orders_fk_language_id mis_orders.language_id language_codes.language_id
mis_orders_fk_payment_id mis_orders.payment_id mis_payments.payment_id
mis_orders_fk_port_id mis_orders.port_id categories.category_id
mis_orders_fk_shipping_id mis_orders.shipping_id categories.category_id
mis_orders_fk_zone_id mis_orders.zone_id categories.category_id
mis_orders_order_id_fkey mis_orders.order_id acs_objects.object_id
mis_orders_project_id_fk mis_orders.project_id mis_projects.project_id
mis_orders_sale_rep_id_fk mis_orders.sale_rep_id categories.category_id
mis_orders_store_id_fk mis_orders.store_id mis_stores.store_id
mis_parties_fk_bank_id mis_parties.company_bank_id mis_banks.bank_id
mis_parties_fk_currency mis_parties.currency currencies.codea
mis_parties_fk_default_address_id mis_parties.default_address_id mis_addresses.address_id
mis_parties_fk_iva_id mis_parties.iva_id mis_iva.iva_id
mis_parties_fk_language_id mis_parties.language_id language_codes.language_id
mis_parties_fk_party_type_id mis_parties.party_type_id categories.category_id
mis_parties_fk_payment_id mis_parties.payment_id mis_payments.payment_id
mis_parties_fk_port_id mis_parties.port_id categories.category_id
mis_parties_fk_sale_rep_id mis_parties.sale_rep_id categories.category_id
mis_parties_fk_shipping_id mis_parties.shipping_id categories.category_id
mis_parties_fk_zone_id mis_parties.zone_id categories.category_id
mis_parties_party_id_fkey mis_parties.party_id acs_objects.object_id
mis_party_accounts_fin_account_id_fkey mis_party_accounts.fin_account_id mis_accounts.account_id
mis_party_accounts_mgm_account_id_fkey mis_party_accounts.mgm_account_id mis_accounts.account_id
mis_party_accounts_party_id_fkey mis_party_accounts.party_id mis_parties.party_id
mis_party_mod_party_id_fkey mis_party_mod.party_id acs_objects.object_id
mis_payment_terms_payment_id_fkey mis_payment_terms.payment_id mis_payments.payment_id
mis_payments_payment_type_id_fkey mis_payments.payment_type_id mis_payment_types.payment_type_id
mis_plants_fk_base_store_id mis_plants.base_store_id mis_stores.store_id
mis_plants_fk_raw_material_store_id mis_plants.raw_material_store_id mis_stores.store_id
mis_po_lines_account_id_fk mis_po_lines.account_id mis_accounts.account_id
mis_po_lines_line_id_fk mis_po_lines.line_id acs_objects.object_id
mis_po_lines_mr_line_id_fk mis_po_lines.mr_line_id mis_mr_lines.line_id
mis_po_lines_po_id_fk mis_po_lines.po_id mis_pos.po_id
mis_po_lines_product_id_fk mis_po_lines.product_id mis_products.product_id
mis_po_lines_purc_um_id_fk mis_po_lines.purc_um_id mis_um.um_id
mis_po_lines_store_id_fk mis_po_lines.store_id mis_stores.store_id
mis_pos_currency_fk mis_pos.currency currencies.codea
mis_pos_fk_bank_id mis_pos.bank_id mis_banks.bank_id
mis_pos_fk_carrier_id mis_pos.carrier_id categories.category_id
mis_pos_fk_guarantee_id mis_pos.guarantee_id categories.category_id
mis_pos_fk_language_id mis_pos.language_id language_codes.language_id
mis_pos_fk_packaging_id mis_pos.packaging_id categories.category_id
mis_pos_fk_payment_id mis_pos.payment_id mis_payments.payment_id
mis_pos_fk_port_id mis_pos.port_id categories.category_id
mis_pos_fk_shipping_id mis_pos.shipping_id categories.category_id
mis_pos_mr_id_fk mis_pos.mr_id mis_mrs.mr_id
mis_pos_po_id_fk mis_pos.po_id acs_objects.object_id
mis_pos_store_id_fk mis_pos.store_id mis_stores.store_id
mis_pos_vendor_id_fk mis_pos.vendor_id mis_parties.party_id
mis_product_brand_id_fk mis_products.brand_id categories.category_id
mis_product_categories_account_id_fkey mis_product_categories.account_id mis_accounts.account_id
mis_product_iva_id_fk mis_products.iva_id mis_iva.iva_id
mis_product_lots_product_id_fkey mis_product_lots.product_id mis_products.product_id
mis_product_wh_location_id_fkey mis_product_wh.location_id mis_store_locations.location_id
mis_product_wh_plant_id_fkey mis_product_wh.plant_id mis_plants.plant_id
mis_product_wh_product_id_fkey mis_product_wh.product_id mis_products.product_id
mis_products_fk_category mis_products.category_id mis_product_categories.product_category_id
mis_products_fk_sell_um mis_products.sell_um_id mis_um.um_id
mis_products_fk_um mis_products.um_id mis_um.um_id
mis_products_product_id_fkey mis_products.product_id acs_objects.object_id
mis_projects_bid_id_fkey mis_projects.bid_id mis_bids.bid_id
mis_projects_customer_id_fkey mis_projects.customer_id mis_parties.party_id
mis_projects_project_id_fkey mis_projects.project_id mis_accounts.account_id
mis_projects_um_id_fkey mis_projects.um_id mis_um.um_id
mis_purc_invoice_lines_account_id_fkey mis_purc_invoice_lines.account_id mis_accounts.account_id
mis_purc_invoice_lines_iva_id_fkey mis_purc_invoice_lines.iva_id mis_iva.iva_id
mis_purc_invoice_lines_product_id_fkey mis_purc_invoice_lines.product_id mis_products.product_id
mis_purc_invoice_lines_purc_invoice_id_fkey mis_purc_invoice_lines.purc_invoice_id mis_purc_invoices.purc_invoice_id
mis_purc_invoice_lines_purc_invoice_line_id_fkey mis_purc_invoice_lines.purc_invoice_line_id acs_objects.object_id
mis_purc_invoice_lines_purc_um_id_fkey mis_purc_invoice_lines.purc_um_id mis_um.um_id
mis_purc_invoice_lines_rec_line_id_fkey mis_purc_invoice_lines.rec_line_id mis_rec_note_lines.rec_line_id
mis_purc_invoices_bank_id_fkey mis_purc_invoices.bank_id mis_banks.bank_id
mis_purc_invoices_cee_currency_fkey mis_purc_invoices.cee_currency currencies.codea
mis_purc_invoices_invoice_type_id_fkey mis_purc_invoices.invoice_type_id mis_invoice_types.invoice_type_id
mis_purc_invoices_payment_id_fkey mis_purc_invoices.payment_id mis_payments.payment_id
mis_purc_invoices_purc_invoice_id_fkey mis_purc_invoices.purc_invoice_id acs_objects.object_id
mis_purc_invoices_purc_invoice_ref_id_fkey mis_purc_invoices.purc_invoice_ref_id mis_purc_invoices.purc_invoice_id
mis_purc_invoices_vendor_id_fkey mis_purc_invoices.vendor_id mis_parties.party_id
mis_purc_iva_iva_id_fkey mis_purc_iva.iva_id mis_iva.iva_id
mis_purc_iva_purc_invoice_id_fkey mis_purc_iva.purc_invoice_id mis_purc_invoices.purc_invoice_id
mis_purc_list_prices_price_list_id_fkey mis_purc_list_prices.price_list_id mis_purc_price_lists.price_list_id
mis_purc_list_prices_product_id_fkey mis_purc_list_prices.product_id mis_products.product_id
mis_purc_list_prices_purc_um_id_fkey mis_purc_list_prices.purc_um_id mis_um.um_id
mis_purc_paydates_effect_bank_id_fkey mis_purc_paydates.effect_bank_id mis_banks.bank_id
mis_purc_paydates_purc_invoice_id_fkey mis_purc_paydates.purc_invoice_id mis_purc_invoices.purc_invoice_id
mis_purc_payments_mov_account_id_fkey mis_purc_payments.mov_account_id mis_mov_accounts.mov_account_id
mis_purc_payments_purc_paydate_id_fkey mis_purc_payments.purc_paydate_id mis_purc_paydates.purc_paydate_id
mis_purc_price_lists_currency_fkey mis_purc_price_lists.currency currencies.codea
mis_purc_price_lists_vendor_id_fkey mis_purc_price_lists.vendor_id mis_parties.party_id
mis_quotations_codea_fkey mis_quotations.codea currencies.codea
mis_quotations_product_id_fkey mis_quotations.product_id mis_products.product_id
mis_quotations_purc_um_id_fkey mis_quotations.purc_um_id mis_um.um_id
mis_quotations_vendor_id_fkey mis_quotations.vendor_id mis_parties.party_id
mis_rec_note_lines_po_line_id_fkey mis_rec_note_lines.po_line_id mis_po_lines.line_id
mis_rec_note_lines_product_id_fkey mis_rec_note_lines.product_id mis_products.product_id
mis_rec_note_lines_purc_um_id_fkey mis_rec_note_lines.purc_um_id mis_um.um_id
mis_rec_note_lines_rec_id_fkey mis_rec_note_lines.rec_id mis_rec_notes.rec_id
mis_rec_note_lines_rec_line_id_fkey mis_rec_note_lines.rec_line_id acs_objects.object_id
mis_rec_note_lines_store_id_fkey mis_rec_note_lines.store_id mis_stores.store_id
mis_rec_notes_bank_id_fkey mis_rec_notes.bank_id mis_banks.bank_id
mis_rec_notes_bill_type_id_fkey mis_rec_notes.bill_type_id mis_bill_types.bill_type_id
mis_rec_notes_packaging_id_fkey mis_rec_notes.packaging_id categories.category_id
mis_rec_notes_payment_id_fkey mis_rec_notes.payment_id mis_payments.payment_id
mis_rec_notes_po_id_fkey mis_rec_notes.po_id mis_pos.po_id
mis_rec_notes_port_id_fkey mis_rec_notes.port_id categories.category_id
mis_rec_notes_rec_id_fkey mis_rec_notes.rec_id acs_objects.object_id
mis_rec_notes_shipping_id_fkey mis_rec_notes.shipping_id categories.category_id
mis_rec_notes_store_id_fkey mis_rec_notes.store_id mis_stores.store_id
mis_sale_invoice_lines_account_id_fkey mis_sale_invoice_lines.account_id mis_accounts.account_id
mis_sale_invoice_lines_delivery_line_id_fkey mis_sale_invoice_lines.delivery_line_id mis_delivery_note_lines.delivery_line_id
mis_sale_invoice_lines_iva_id_fkey mis_sale_invoice_lines.iva_id mis_iva.iva_id
mis_sale_invoice_lines_product_id_fkey mis_sale_invoice_lines.product_id mis_products.product_id
mis_sale_invoice_lines_sale_invoice_id_fkey mis_sale_invoice_lines.sale_invoice_id mis_sale_invoices.sale_invoice_id
mis_sale_invoice_lines_sale_invoice_line_id_fkey mis_sale_invoice_lines.sale_invoice_line_id acs_objects.object_id
mis_sale_invoice_lines_sell_um_id_fkey mis_sale_invoice_lines.sell_um_id mis_um.um_id
mis_sale_invoices_bank_id_fkey mis_sale_invoices.bank_id mis_banks.bank_id
mis_sale_invoices_customer_id_fkey mis_sale_invoices.customer_id mis_parties.party_id
mis_sale_invoices_factoring_bank_id_fkey mis_sale_invoices.factoring_bank_id mis_banks.bank_id
mis_sale_invoices_invoice_type_id_fkey mis_sale_invoices.invoice_type_id mis_invoice_types.invoice_type_id
mis_sale_invoices_language_id_fkey mis_sale_invoices.language_id language_codes.language_id
mis_sale_invoices_payment_id_fkey mis_sale_invoices.payment_id mis_payments.payment_id
mis_sale_invoices_sale_invoice_id_fkey mis_sale_invoices.sale_invoice_id acs_objects.object_id
mis_sale_invoices_sale_invoice_ref_id_fkey mis_sale_invoices.sale_invoice_ref_id mis_sale_invoices.sale_invoice_id
mis_sale_invoices_sale_rep_id_fkey mis_sale_invoices.sale_rep_id categories.category_id
mis_sale_invoices_zone_id_fkey mis_sale_invoices.zone_id categories.category_id
mis_sale_iva_iva_id_fkey mis_sale_iva.iva_id mis_iva.iva_id
mis_sale_iva_sale_invoice_id_fkey mis_sale_iva.sale_invoice_id mis_sale_invoices.sale_invoice_id
mis_sale_paydates_bank_id_fkey mis_sale_paydates.bank_id mis_banks.bank_id
mis_sale_paydates_effect_bank_id_fkey mis_sale_paydates.effect_bank_id mis_banks.bank_id
mis_sale_paydates_invoice_id_fkey mis_sale_paydates.invoice_id mis_sale_invoices.sale_invoice_id
mis_sale_paydates_payment_type_id_fkey mis_sale_paydates.payment_type_id mis_payment_types.payment_type_id
mis_sap_parties_party_id_fkey mis_sap_parties.party_id mis_parties.party_id
mis_scripts_fk1 mis_scripts.original_author users.user_id
mis_scripts_fk2 mis_scripts.maintainer users.user_id
mis_scripts_script_id_fkey mis_scripts.script_id acs_objects.object_id
mis_store_locations_store_id_fkey mis_store_locations.store_id mis_stores.store_id
mis_stores_plant_id_fkey mis_stores.plant_id mis_plants.plant_id
mis_stores_vendor_id_fkey mis_stores.vendor_id mis_parties.party_id
mis_user_preferences_user_id_fkey mis_user_preferences.user_id users.user_id
mis_vendors_products_map_product_id_fkey mis_vendors_products_map.product_id mis_products.product_id
mis_vendors_products_map_vendor_id_fkey mis_vendors_products_map.vendor_id mis_parties.party_id
mis_wh_mov_wh_mov_location_id_fkey mis_wh_mov.wh_mov_location_id mis_store_locations.location_id
mis_wh_mov_wh_mov_lot_id_fkey mis_wh_mov.wh_mov_lot_id mis_product_lots.lot_id
mis_wh_mov_wh_mov_party_id_fkey mis_wh_mov.wh_mov_party_id mis_parties.party_id
mis_wh_mov_wh_mov_product_id_fkey mis_wh_mov.wh_mov_product_id mis_products.product_id
mis_wh_mov_wh_mov_store_id_fkey mis_wh_mov.wh_mov_store_id mis_stores.store_id
mis_wh_mov_wh_mov_type_fkey mis_wh_mov.wh_mov_type mis_wh_mov_types.wh_mov_type_id
mis_wh_mov_wh_mov_user_fkey mis_wh_mov.wh_mov_user users.user_id
parties_party_id_fk parties.party_id acs_objects.object_id
persons_person_id_fk persons.person_id parties.party_id
users_auth_authorities_fk users.authority_id auth_authorities.authority_id
users_user_id_fk users.user_id persons.person_id

Check Constraints:

Table Constraint Name Constraint
None detected