c# - Advise on database table design, table of estimates -

i new database design (have read couple of tutorials though).

in program need store records of time estimates. estimate workpackage consist of estimates in hours 36 timeperiods (month).

my plan have following columns:

• id integer (primary key)
• workpackageid integer (foreign key)
• competendid integer (foreign key)
• m36 smallint unsigned
• m35 smallint unsigned
• m34 smallint unsigned
• .....
• m1 smallint unsigned
• created datetime
• modified datetime

m1 m36 estimations of work time period of 1 month. workpackage can implemented in 1 calender month time have estimates in m1 column. workpackage @ minimum require 6 calender month have estimates in m1-m6 columns.

i might need more data in there , add separat values min (likely) max estimates seperately each timeperiod.

i sure there smarter way dont know how...

any suggestions appriciated...

best regards // claes

this approach

table jobs jobid -- don't use id workpackageid  competendid  createdon modifiedon   table timeperiod timeperiodid timeperioddesc -- m1, m2, etc  table times timeid jobid  -- fk jobs timeperiodid -- fk timeperiod estimatetype -- min, max, etc estimatevalue int -- pop estimate in here createdon  -- no modify, use recent created each allow audit history