Re: Table design question

From: Mike Sherrill <MSherrillnonono_at_compuserve.com>
Date: Sat, 24 Jan 2004 08:05:02 -0500
Message-ID: <roq4105vmg6e99ia967nikgp4541m73ekv_at_4ax.com>

On Fri, 23 Jan 2004 09:08:49 +0100, Karel Miklav <karel_at_inetis.spppambait.com> wrote:

>There are other related tables like log here, where I'm really not
>interested in historical data but just the identity of the user, and
>those where exact user properties in point of time matter.
>
>The one-field user table smells like a design problem.

Smells like a domain.

At the conceptual level, every domain is just a column (or several columns) of values. Think of it as a domain of user ID numbers. (And call it "user_id" if you can.)

-- 
Mike Sherrill
Information Management Systems

Received on Sat Jan 24 2004 - 14:05:02 CET

This message: [ Message body ]
Next message: TenKMan: "Re: Interested in a moderated theory forum?"
Previous message: Karel Miklav: "Re: Table design question"
In reply to: Karel Miklav: "Table design question"
In reply to Karel Miklav: "Table design question"
Next in thread: TenKMan: "Re: Interested in a moderated theory forum?"
Reply: Tony: "Re: Table design question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message