[Swansea Hackspace] SQL Help

[Justin Mitchell]

On Mon, 2015-05-18 at 14:24 +0100, Graham Owens wrote:


> table1
> table1.id: autonum
> active: bool
> t2id_1: int
> t2id_2: int
> t2id_3: int
> t2id_4: int
> t2id_5: int
> t2id_6: int
> 
> 
> 
> table2
> table2.id: autonum
> expected_date:  datetime
> actual_date:   datetime
> claim_date: datetime
> value: datetime

There are several questions about the data structure that need to be
asked here, will one table2 entry only be used once, or could it be
referenced by multiple table1 entries ?

if the former, then the t2id_* fields are unnessary
if the latter, then they should be replaced with a link table.

but the list might not be the place to thrash this out, will see you
later.