Add data field to existing table with LIVE DATA

Question

Hi,

I'm working on a project which generate report every quarter. So there is a table supporting this:

Report: ID(int) Quarter(byte)

...

But later, the requirement changed and need the system to support more then one report in the quarter like this: 2-1, 3-2, ...

How can I support this requirement change? Thanks in advance!

Answer 1

not sure why you use byte for quarter and dont have a year column. Byte holds 256 different values, enough for four quarters, okay.

I'd do the following: Year(int) Quarter(byte if you wish) ReportNumber(int)

Answer 2

How about:

Report: ID(int) Quarter(byte) Date(DateTime)

Answer 3

The solution I'm going to use it to change the Quater to be a foreign key, point to another table, so I can easily deal with the database with LIVE DATA. or use 2 many to many table and record extra field there. What's your opinion? Thanks!