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(at)sycore(dot)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...