title: Two Dimensional Database Design -SQL or JSON
body: <p>I need a database design advice. I am currenty using SQLite ( or i can switch to any other database for those tables)  I have  A,B,C,D  columns with  rows  from 24 to 1008 .   X represents whether the column empty or not. </p>
  
  <p>my first idea->  I can do Table A,B,C,D  with 24 to 1008   (which seems dumb)</p>
  
  <p>second idea -> something like table X (which has id(FK) to another table where I will be getting report ID) which has  24 to 1008 and values will be  A,B,C  or D  so in this case an example query is :  SELECT A from table X JOIN table_report ON table.report.id=X.id where table_report.id=3;</p>
  
  <p>so  with 4 queries I will be getting values for  A,B,C and D  however I am confused  a lot now </p>
  
  <p>Efficiency is not a big deal atm however I don't want to design a dumb thing.  I will be filling HTML tables with those data ( Express+ejs)</p>
  
  <p>I am open for any advice</p>
  
  <p><a href="https://i.hizliresim.com/PO7PV5.png" rel="nofollow noreferrer">https://i.hizliresim.com/PO7PV5.png</a></p>