I have a database design issue and hope one of you can answer my
question.
I have data comming to me in form shown below
Input1: (Name,DOB,Sal)
String Date Int
---------------------------
a 12/12/2001 3000
b 12/13/2001 4000
c 12/14/2001 5000
Input2: (company,turnover,rate,years)
String Int Real Int
---------------------------
a 12 1.2 5
b 4000 2.5 6
c 5000 3.4 7
So I keep getting data like these tables with different column names
and different types of data. I have to store this data in database
tables. One solution is to keep creating tables for each input I
receive clearly this is inefficient as I get 100 inputs like this per
day. Is there any schema design where by I can capture details such
that this data belongs to Input2 with name company and data type
String.
I might get down the line some more entries for Input2.
d 6000 3.5 8
So my final aim is to get data for following queries..
- get all company names for input2. Now the query should return me
a,b,c,d