title: New to SQLite - how to store data which is a list of object with sub objects and array?
body: <p>I am trying to store data with the following format, and am not sure of the best way to organize in SQLite:</p>
  
  <p>-Main item</p>
  
  <p>-- Field 1</p>
  
  <p>-- Field 2</p>
  
  <p>-- Field 3 (main image)</p>
  
  <p>---- image path</p>
  
  <p>---- date image was taken</p>
  
  <p>-- Field 4</p>
  
  <p>-- Field 5 (array of images)</p>
  
  <p>---- each image is a path and date pair as above</p>
  
  <p>I was thinking 2 tables? 1 for the main item, with the main image path and date as just two specific columns; then the second table would be the list of images with an id tied to the main item?</p>
  
  <p>Is there a better way to do this? Seems like it would be hassle to manage and update both tables, but if that's the best way then that's how it is</p>