## synchronizeStatement ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeStatement_start([synchronizeStatement]) synchronizeStatement_start --> synchronizeStatement_0_0[synchronize] synchronizeStatement_0_0 --> synchronizeStatement_0_1[COMPARE] synchronizeStatement_0_1 --> synchronizeStatement_0_2[tableSpec] synchronizeStatement_0_2 --> synchronizeStatement_0_3[TO] synchronizeStatement_0_3 --> synchronizeStatement_0_4[AND] synchronizeStatement_0_4 --> synchronizeStatement_0_5[tableSpec] synchronizeStatement_0_5 --> synchronizeStatement_0_6[synchronizeIudStatement] synchronizeStatement_0_6 --> synchronizeStatement_0_7[identifiedByMultipleClause] synchronizeStatement_0_7 --> synchronizeStatement_0_8[synchronizeIgnoreClause] synchronizeStatement_0_8 --> synchronizeStatement_0_9[resolveByClause] synchronizeStatement_0_9 --> synchronizeStatement_0_10[applyToClause] synchronizeStatement_0_10 --> synchronizeStatement_0_11[limitClause] synchronizeStatement_0_11 --> synchronizeStatement_0_12[RETURNING] synchronizeStatement_0_12 --> synchronizeStatement_0_13[SQL] synchronizeStatement_0_13 --> synchronizeStatement_0_14[DIFFERENCES] synchronizeStatement_0_14 --> synchronizeStatement_0_15[BATCHSIZE] synchronizeStatement_0_15 --> synchronizeStatement_0_16[numericConstant] synchronizeStatement_0_16 --> synchronizeStatement_0_17[CONTINUE] synchronizeStatement_0_17 --> synchronizeStatement_0_18[ON] synchronizeStatement_0_18 --> synchronizeStatement_0_19[FIRST] synchronizeStatement_0_19 --> synchronizeStatement_0_20[numericConstant] synchronizeStatement_0_20 --> synchronizeStatement_0_21[ERRORS] synchronizeStatement_0_21 --> synchronizeStatement_0_22[synchronizeTriggers] synchronizeStatement_0_22 --> synchronizeStatement_end(( )) ``` ## synchronizeIudStatement ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeIudStatement_start([synchronizeIudStatement]) synchronizeIudStatement_start --> synchronizeIudStatement_0_0[WITH] synchronizeIudStatement_0_0 --> synchronizeIudStatement_0_1[synchronizeInsertStatement] synchronizeIudStatement_0_1 --> synchronizeIudStatement_0_2[OR] synchronizeIudStatement_0_2 --> synchronizeIudStatement_0_3[synchronizeUpdateStatement] synchronizeIudStatement_0_3 --> synchronizeIudStatement_0_4[OR] synchronizeIudStatement_0_4 --> synchronizeIudStatement_0_5[synchronizeDeleteStatement] synchronizeIudStatement_0_5 --> synchronizeIudStatement_0_6[synchronizeUpdateStatement] synchronizeIudStatement_0_6 --> synchronizeIudStatement_0_7[OR] synchronizeIudStatement_0_7 --> synchronizeIudStatement_0_8[synchronizeDeleteStatement] synchronizeIudStatement_0_8 --> synchronizeIudStatement_0_9[synchronizeDeleteStatement] synchronizeIudStatement_0_9 --> synchronizeIudStatement_end(( )) ``` ## synchronizeInsertStatement ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeInsertStatement_start([synchronizeInsertStatement]) synchronizeInsertStatement_start --> synchronizeInsertStatement_0_0[INSERT] synchronizeInsertStatement_0_0 --> synchronizeInsertStatement_0_1[ALL] synchronizeInsertStatement_0_1 --> synchronizeInsertStatement_0_2[EXCEPT] synchronizeInsertStatement_0_2 --> synchronizeInsertStatement_0_3[columnList] synchronizeInsertStatement_0_3 --> synchronizeInsertStatement_end(( )) ``` ## synchronizeUpdateStatement ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeUpdateStatement_start([synchronizeUpdateStatement]) synchronizeUpdateStatement_start --> synchronizeUpdateStatement_0_0[UPDATE] synchronizeUpdateStatement_0_0 --> synchronizeUpdateStatement_0_1[ALL] synchronizeUpdateStatement_0_1 --> synchronizeUpdateStatement_0_2[EXCEPT] synchronizeUpdateStatement_0_2 --> synchronizeUpdateStatement_0_3[columnList] synchronizeUpdateStatement_0_3 --> synchronizeUpdateStatement_0_4[IGNORE] synchronizeUpdateStatement_0_4 --> synchronizeUpdateStatement_0_5[CHANGES] synchronizeUpdateStatement_0_5 --> synchronizeUpdateStatement_0_6[TO] synchronizeUpdateStatement_0_6 --> synchronizeUpdateStatement_0_7[columnList] synchronizeUpdateStatement_0_7 --> synchronizeUpdateStatement_end(( )) ``` ## synchronizeDeleteStatement ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR Start(( )) --> synchronizeDeleteStatement synchronizeDeleteStatement -->| | DELETE DELETE --> End(( )) ``` ## synchronizeUsingPSqlBlock ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeUsingPSqlBlock_start([synchronizeUsingPSqlBlock]) synchronizeUsingPSqlBlock_start --> synchronizeUsingPSqlBlock_0_0[USING] synchronizeUsingPSqlBlock_0_0 --> synchronizeUsingPSqlBlock_0_1[PSQL] synchronizeUsingPSqlBlock_0_1 --> synchronizeUsingPSqlBlock_0_2[pSqlBlockNoBatchSeparator] synchronizeUsingPSqlBlock_0_2 --> synchronizeUsingPSqlBlock_end(( )) ``` ## synchronizeTriggers ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeTriggers_start([synchronizeTriggers]) synchronizeTriggers_start --> synchronizeTriggers_0_0[TRIGGERS] synchronizeTriggers_0_0 --> synchronizeTriggers_0_1[synchronizeTrigger] synchronizeTriggers_0_1 --> synchronizeTriggers_end(( )) ``` ## synchronizeTrigger ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeTrigger_start([synchronizeTrigger]) synchronizeTrigger_start --> synchronizeTrigger_0_0[BEFORE] synchronizeTrigger_0_0 --> synchronizeTrigger_0_1[INSTEAD] synchronizeTrigger_0_1 --> synchronizeTrigger_0_2[OF] synchronizeTrigger_0_2 --> synchronizeTrigger_0_3[AFTER] synchronizeTrigger_0_3 --> synchronizeTrigger_0_4[INSERT] synchronizeTrigger_0_4 --> synchronizeTrigger_0_5[UPDATE] synchronizeTrigger_0_5 --> synchronizeTrigger_0_6[DELETE] synchronizeTrigger_0_6 --> synchronizeTrigger_0_7[ON] synchronizeTrigger_0_7 --> synchronizeTrigger_0_8[LEFT] synchronizeTrigger_0_8 --> synchronizeTrigger_0_9[RIGHT] synchronizeTrigger_0_9 --> synchronizeTrigger_0_10[pSqlBlockNoBatchSeparator] synchronizeTrigger_0_10 --> synchronizeTrigger_end(( )) ``` ## synchronize ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR Start(( )) --> synchronize synchronize -->| | SYNCHRONIZE SYNCHRONIZE --> End(( )) synchronize -->| | SYNC SYNC --> End(( )) ``` ## synchronizeIgnoreClause ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR synchronizeIgnoreClause_start([synchronizeIgnoreClause]) synchronizeIgnoreClause_start --> synchronizeIgnoreClause_0_0[IGNORE] synchronizeIgnoreClause_0_0 --> synchronizeIgnoreClause_0_1[NULLS] synchronizeIgnoreClause_0_1 --> synchronizeIgnoreClause_end(( )) ``` ## resolveByClause ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR resolveByClause_start([resolveByClause]) resolveByClause_start --> resolveByClause_0_0[RESOLVE] resolveByClause_0_0 --> resolveByClause_0_1[BY] resolveByClause_0_1 --> resolveByClause_0_2[sortedColumnList] resolveByClause_0_2 --> resolveByClause_0_3[PREFER] resolveByClause_0_3 --> resolveByClause_0_4[LEFT] resolveByClause_0_4 --> resolveByClause_0_5[RIGHT] resolveByClause_0_5 --> resolveByClause_end(( )) ``` ## applyToClause ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR applyToClause_start([applyToClause]) applyToClause_start --> applyToClause_0_0[APPLY] applyToClause_0_0 --> applyToClause_0_1[TO] applyToClause_0_1 --> applyToClause_0_2[tableSpec] applyToClause_0_2 --> applyToClause_0_3[COMMA] applyToClause_0_3 --> applyToClause_0_4[tableSpec] applyToClause_0_4 --> applyToClause_end(( )) ``` ## triggerRecordNameExpression ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR triggerRecordNameExpression_start([triggerRecordNameExpression]) triggerRecordNameExpression_start --> triggerRecordNameExpression_0_0[COLON] triggerRecordNameExpression_0_0 --> triggerRecordNameExpression_0_1[OLD] triggerRecordNameExpression_0_1 --> triggerRecordNameExpression_0_2[NEW] triggerRecordNameExpression_0_2 --> triggerRecordNameExpression_0_3[SOURCE] triggerRecordNameExpression_0_3 --> triggerRecordNameExpression_end(( )) ``` ## triggerRecordVariableExpression ```mermaid %%{init: { 'theme': 'base', 'themeVariables': { 'fontSize': '11px', 'nodePadding': '1', 'nodeBorder': '1', 'lineWidth': '0.8', 'fontFamily': 'Arial' } }}%% flowchart LR triggerRecordVariableExpression_start([triggerRecordVariableExpression]) triggerRecordVariableExpression_start --> triggerRecordVariableExpression_0_0[triggerRecordNameExpression] triggerRecordVariableExpression_0_0 --> triggerRecordVariableExpression_0_1[DOT] triggerRecordVariableExpression_0_1 --> triggerRecordVariableExpression_0_2[identifier] triggerRecordVariableExpression_0_2 --> triggerRecordVariableExpression_end(( )) ```