Re: Schema / SQL advise

You can keep your two tables and add two new tables. So solution can be:

"Team" and "People" tables as you suggested, plus the following two:

Leader Table
-peopleID
-teamID
-"autonumber field"
-datein
-dateout

key for this table is (peopleID, teamID, autonamber field)

Member Table
-peopleID
-teamID

• "autonumberfield"
  -datein
  -dateout
  

key for this table is (peopleID, teamID, autonamberfield)

I put here two new tables because they are two different links, in real world. But you can set one interface for both tables.

"datein" is date when "peopleID" become leader(member) of teamID in real world.
"dateout" is date when previous link became "closed" in real world. "autonamber" is system generated number, which is interpretation of name of particular leader (member) link.

If you want set your database on web, so that n-users can independently add and delete data from above tables you should add more "data" to this
four tables.

regards
Vlado

--
Received on Fri Jul 27 2001 - 05:37:02 CEST