Re: Need help to organize database

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.