Running the --cleanup on one table, should also cleanup the dependent tables in the ETL flow.

[pjlammertyn]

Because the --cleanup command triggers the generation of new auto numbered id's (in the next ETL run), the foreign keys of the dependent tables will have invalid wring foreign keys to that table.

So all the dependent tables should also be cleared!

[pjlammertyn]

For example if you cleanup the person table.

riab --cleanup person

All dependent tables in the ETL flow, must also be cleaned up!

└──person
  ├──condition_era
  ├──death
  ├──dose_era
  ├──drug_era
  ├──episode
  ├──observation_period
  ├──payer_plan_period
  ├──specimen
  └──visit_occurrence
    ├──episode_event
    └──visit_detail
      ├──condition_occurrence
      ├──device_exposure
      ├──drug_exposure
      ├──measurement
      ├──note
      ├──observation
      └──procedure_occurrence
        └──note_nlp