Table Schema
From: Eric Kaplan <tobycraftse_at_yahoo.com>
Date: Sun, 23 Mar 2008 20:35:17 -0800
Message-ID: <srbeu3tj8lpgkat30icrkr4d8bp8c94hju@4ax.com>
Date: Sun, 23 Mar 2008 20:35:17 -0800
Message-ID: <srbeu3tj8lpgkat30icrkr4d8bp8c94hju@4ax.com>
I have a group of TV listing data need to map into database tables.
Data looks like following:
http://www.oniva.com/upload/1356/crew.jpg
I want to create a table for productionCrew of each TV program
the data is like -
crew -> programID -> member
-> member
-> member ... etc
-> programID -> member
-> member
-> member ... etc
-> programID -> member
-> member
-> member ... etc
... etc
above are data from productionCrew of all TV program, for each programID we have a list of members.
Should I merge all member into a big string? Or should I use 2 tables to store the Crew data?
If i use 2 tables, how the fields / column will look like? Received on Sun Mar 23 2008 - 23:35:17 CDT