[Swansea Hackspace] SQL Help

[Emyr Morris]

I can show you some real world examples later of working tables full of
data. I find it much easier to explain that way

On Monday, May 18, 2015, Graham Owens <grahamowensuk at googlemail.com> wrote:

> 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
> <javascript:_e(%7B%7D,'cvml','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
>> <javascript:_e(%7B%7D,'cvml','Hackspace at swansea.hackspace.org.uk');>
>> http://swansea.hackspace.org.uk/mailman/listinfo/hackspace
>>
>
>

-- 
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.

Mae'r e-bost hwn ac unrhyw ffeiliau a drosglwyddir gydag ef yn gyfrinachol
ac at ddefnydd yr unigolyn neu'r corff y cyfeiriwyd hwy atynt yn unig.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://swansea.hackspace.org.uk/pipermail/hackspace/attachments/20150518/c420c87c/attachment.html>