Ideas Needed For This Problem (table Structure)

Hi,

  In my database i have some tables and some are Client, ClientUser, Plan and Platform. We have different products that we offer..

The Client table consits of the following

ClientId  ClientName Contact Platform, Address

 1       abc       johnDoe, 1 anywhere street

2   bca doe john NULL street address and so on..

Client User.

UserId ClientId Lastname Firstname Login Password Active

 1        1       doe            John        abc    XXXX   True

 2        1       abc           kjd          ldkf     XXXX   True

3          2       dfdkjf           jdkfjdl   kdll     XXXX true

 

Plan table

PlanId  ClientId userId Planname ....

1           1         1        abc plan name

2           1          2        abc planname

So on and so forth

Platform

PlatformId   Name

 1              ACC

So my question is in the Plan we have different plans from different user and some of them will be of same client but different Platform or products...

So Platform ACC is some kinda extract where the user get some DBF files and imports it.. where as in the other product they are typed in manually. so how do i differentiate between the two products in the Plan table.. I was thinking of considering this approach.

In the User table add a column called PlatformId too so that in my sproc i can differentiate with it.. so does it make sense to add to the Plan table...

any ideas are appreciated..

Regards,

Karen