Moin,
muss mal wieder was erfragen was mir nicht so ganz klar ist, und zwar geht es darum eine Master / Child Datenbank zu erstellen. In der Master Datenbank habe ich die Produktdaten, in der Child sollen dann die Varianten abgebildet werden. Nun habe ich folgende JSON Datei die mir das anlegen soll:
{"part_id":"3710","name":"Prooduktdaten","year1":"1977","year2":"2016","category":"Plates","part_type_id":"10","part_url":"Pfad","part_img_url":"Pfad","colors":[{"rb_color_id":"0","ldraw_color_id":"0","color_name":"Black","num_sets":"1117","num_parts":"5050"},{"rb_color_id":"1","ldraw_color_id":"1","color_name":"Blue","num_sets":"492","num_parts":"1583"},{"rb_color_id":"10","ldraw_color_id":"10","color_name":"Bright Green","num_sets":"4","num_parts":"8"},{"rb_color_id":"212","ldraw_color_id":"212","color_name":"Bright Light Blue","num_sets":"1","num_parts":"1"},{"rb_color_id":"191","ldraw_color_id":"191","color_name":"Bright Light Orange","num_sets":"22","num_parts":"97"},{"rb_color_id":"29","ldraw_color_id":"29","color_name":"Bright Pink","num_sets":"15","num_parts":"30"},{"rb_color_id":"6","ldraw_color_id":"6","color_name":"Brown","num_sets":"21","num_parts":"53"},{"rb_color_id":"321","ldraw_color_id":"321","color_name":"Dark Azure","num_sets":"2","num_parts":"14"},{"rb_color_id":"272","ldraw_color_id":"272","color_name":"Dark Blue","num_sets":"87","num_parts":"597"},{"rb_color_id":"23","ldraw_color_id":"23","color_name":"Dark Blue-Violet","num_sets":"1","num_parts":"1"},{"rb_color_id":"72","ldraw_color_id":"72","color_name":"Dark Bluish Gray","num_sets":"463","num_parts":"2048"},{"rb_color_id":"8","ldraw_color_id":"8","color_name":"Dark Gray","num_sets":"59","num_parts":"278"},{"rb_color_id":"288","ldraw_color_id":"288","color_name":"Dark Green","num_sets":"21","num_parts":"70"},{"rb_color_id":"484","ldraw_color_id":"484","color_name":"Dark Orange","num_sets":"16","num_parts":"64"},{"rb_color_id":"5","ldraw_color_id":"5","color_name":"Dark Pink","num_sets":"4","num_parts":"4"},{"rb_color_id":"85","ldraw_color_id":"85","color_name":"Dark Purple","num_sets":"3","num_parts":"6"},{"rb_color_id":"320","ldraw_color_id":"320","color_name":"Dark Red","num_sets":"104","num_parts":"569"},{"rb_color_id":"28","ldraw_color_id":"28","color_name":"Dark Tan","num_sets":"57","num_parts":"379"},{"rb_color_id":"3","ldraw_color_id":"3","color_name":"Dark Turquoise","num_sets":"1","num_parts":"6"},{"rb_color_id":"2","ldraw_color_id":"2","color_name":"Green","num_sets":"176","num_parts":"713"},{"rb_color_id":"323","ldraw_color_id":"323","color_name":"Light Aqua","num_sets":"1","num_parts":"1"},{"rb_color_id":"71","ldraw_color_id":"71","color_name":"Light Bluish Gray","num_sets":"463","num_parts":"2383"},{"rb_color_id":"7","ldraw_color_id":"7","color_name":"Light Gray","num_sets":"350","num_parts":"1402"},{"rb_color_id":"18","ldraw_color_id":"18","color_name":"Light Yellow","num_sets":"2","num_parts":"2"},{"rb_color_id":"27","ldraw_color_id":"27","color_name":"Lime","num_sets":"89","num_parts":"322"},{"rb_color_id":"313","ldraw_color_id":"313","color_name":"Maersk Blue","num_sets":"3","num_parts":"47"},{"rb_color_id":"26","ldraw_color_id":"26","color_name":"Magenta","num_sets":"25","num_parts":"54"},{"rb_color_id":"322","ldraw_color_id":"322","color_name":"Medium Azure","num_sets":"18","num_parts":"37"},{"rb_color_id":"73","ldraw_color_id":"73","color_name":"Medium Blue","num_sets":"55","num_parts":"224"},{"rb_color_id":"30","ldraw_color_id":"30","color_name":"Medium Lavender","num_sets":"28","num_parts":"130"},{"rb_color_id":"462","ldraw_color_id":"462","color_name":"Medium Orange","num_sets":"5","num_parts":"14"},{"rb_color_id":"25","ldraw_color_id":"25","color_name":"Orange","num_sets":"106","num_parts":"473"},{"rb_color_id":"22","ldraw_color_id":"22","color_name":"Purple","num_sets":"1","num_parts":"2"},{"rb_color_id":"4","ldraw_color_id":"4","color_name":"Red","num_sets":"728","num_parts":"2668"},{"rb_color_id":"70","ldraw_color_id":"70","color_name":"Reddish Brown","num_sets":"263","num_parts":"1174"},{"rb_color_id":"379","ldraw_color_id":"379","color_name":"Sand Blue","num_sets":"9","num_parts":"33"},{"rb_color_id":"378","ldraw_color_id":"378","color_name":"Sand Green","num_sets":"9","num_parts":"51"},{"rb_color_id":"232","ldraw_color_id":"232","color_name":"Sky Blue","num_sets":"1","num_parts":"1"},{"rb_color_id":"19","ldraw_color_id":"19","color_name":"Tan","num_sets":"199","num_parts":"990"},{"rb_color_id":"47","ldraw_color_id":"47","color_name":"Trans-Clear","num_sets":"2","num_parts":"27"},{"rb_color_id":"15","ldraw_color_id":"15","color_name":"White","num_sets":"879","num_parts":"3573"},{"rb_color_id":"14","ldraw_color_id":"14","color_name":"Yellow","num_sets":"534","num_parts":"1843"}]} Mit dem ersten Datensatz part_id usw kann ich ja die Datenbasis anlegen, das klappt auch soweit, nur wie muss ich nun vorgehen um die Farben in einer Child Datenbank abzulegen? Die part_id dient mir ja als Identifier, aber es müssen jetzt ja in der Child Datenbank - wenn ich es richtig verstehe - die part_id sowie die Farbe in einer Zeile einzeln abgespeichert werden, aber ich habe im JSON File ja nur einmal die ID? Wie speichere ich also das in dem Child ab so dass ich für jede Farbe die ID mit drinne habe? Oder geht das automatisch weil die Spitzen Klammer das ja einschließen?