[Swansea Hackspace] SQL Help

[Graham Owens]

Justin, I think you might be right - we can thrash it out a bit more later

Thanks for all the input, once we have a chat later - and formalize the
problem better (there are normalization rules????? - just kidding - i was
between a rock and a hard place, this works - just needs improved)

If it still is giving me problems, we can pick up the conversation then.

Thanks

G

On 18 May 2015 at 15:06, Justin Mitchell <justin at discordia.org.uk> wrote:

> 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.
>
>
>
> _______________________________________________
> Hackspace mailing list
> Hackspace at swansea.hackspace.org.uk
> http://swansea.hackspace.org.uk/mailman/listinfo/hackspace
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://swansea.hackspace.org.uk/pipermail/hackspace/attachments/20150518/cdd71f4d/attachment.html>