SchemaSpy Analysis of idempiere11.adempiere - ConstraintsData Replication Generated by
Quality Systems & Solutions
14 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_sequence_doctypedoc c_doctype.docnosequence_id ad_sequence.ad_sequence_id Restrict delete 
adreplication_adreprun ad_replication_run.ad_replication_id ad_replication.ad_replication_id Cascade on delete 
adreplicationrun_adreplog ad_replication_log.ad_replication_run_id ad_replication_run.ad_replication_run_id Cascade on delete 
adreplicationstrategy_adrep ad_replication.ad_replicationstrategy_id ad_replicationstrategy.ad_replicationstrategy_id Restrict delete 
adrepstrategy_adreptable ad_replicationtable.ad_replicationstrategy_id ad_replicationstrategy.ad_replicationstrategy_id Restrict delete 
adreptable_adreplog ad_replication_log.ad_replicationtable_id ad_replicationtable.ad_replicationtable_id Null on delete 
adtable_adreplicationdocument ad_replicationdocument.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adreplicationtable ad_replicationtable.ad_table_id ad_table.ad_table_id Cascade on delete 
cdoctype_adreplicationdocument ad_replicationdocument.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
definitesequence_cdoctype c_doctype.definitesequence_id ad_sequence.ad_sequence_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected