[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


This is going to cause you problems, i forget which Normal Form it
breaks, but its going to make it much harder to perform the query you
want. Should probably be in a link table

Should be a few of us there tonight that can bend you ear about database
structures :)