Hi, all
I have a table (url) which counts the number of hits of my sites for each month. Now I want to know how many hits from each IP address for each month. How should I design the table? I want to design the table (IP)which contains 13 columns, the first one is IP, from the second to thirteenth, each column is for a month from January to December, but it is redundant since the url table already has the month columns. What is the efficient way to design the IP table?
Any information is highly appreciated. Thanks in advance.