I have downloaded the content of tables (case,casesolutions & solutions) into my own tables. I thought that there is a one to many relationship between the case object and the solutions object through casesolutions object. however the ids in the casesolutions object associated with the CaseID and SolutionID fields do not match the CaseNumber and SolutionNumber in the case and solutions table.

Any help is appreciated.