Re: Table Design for 2 similar table

From: Ginger Mall <bocgco_at_hongkong.com>
Date: Fri, 20 Dec 2002 13:12:49 +0800
Message-ID: <3e02a536$1@shknews01>

thanks all of your input, very precious !! I would prefer to have 1 table as it makes the design and application coding simplar.

Thanks

"Ginger Mall" <bocgco_at_hongkong.com> wrote in message news:3dfeb2c9_at_shknews01...
> I am facing a question on schema design.
>
> There is 2 types of records. The 1st is start record of some activities
> while the other is the stop record.
> They contains actually different attributes except "UserID" and
"DateTime".
> The query will only extract the result by UserID and sort by DateTime.
>
> e.g.
> .. User111 Start .......
> .. User111 Stop .......
> .. User111 Start .......
> .. User111 Stop.......
> .. User111 Start .......
> .. User111 Start .......
> .. User111 Start .......
> .. User111 Stop .......
> .. User111 Start .......
>
>
> My problem is should I split these records into 2 diff. table ?
>
>
Received on Thu Dec 19 2002 - 23:12:49 CST