Re: Need help to organize database

On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> On Tue, Dec 21, 2004 at 20:47:31 +0000,
>
>   "Vladimir S. Petukhov" <vladimir@sycore.org> wrote:
> > Ok, this is a real example:
> >
> > CREATE TABLE account (
> >   val1     BIGINT      NULL,
> >   val2    BIGINT      NULL,
> >  ...
> >
> >   daypos    SMALLINT    NULL,   -- Day position
> >   hourpos   SMALLINT    NULL,   -- Hour position
> >   id        INT         NULL  -- Link to the object
> > );
>
> That approach is reasonable but depending on what the val* columns mean
> you might each of those as a separate role. You didn't add a lot of
> information, but that they appear to be the same type suggests that you
> might want one row per value. But without knowing what they mean it is
> hard to say.

OK, i want to store ststistic information, ingoing/outgoing traffic,
ingoing/outgoing errors(val1-val4) for example...

--
Man's unique agony as a species consists in his perpetual conflict between
the desire to stand out and the need to blend in.
        -- Sydney J. Harris

Now playing: (Воскресение) - Музыкант.mp3
   AutoGenerated by fortune & xmms...