bug-gnubg
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Bug-gnubg] Not sure about person table in new database


From: Jon Kinsey
Subject: [Bug-gnubg] Not sure about person table in new database
Date: Thu, 27 May 2004 14:12:05 +0100
User-agent: Mozilla Thunderbird 0.6 (Windows/20040502)

I don't think the three tables (person, env and player) are quite right.
Here's how it is now:

environment:
        Name of place
person:
        Name
        Notes
player:
        A environment
        A person

For example if there were two players both called A in two different envs E1 E2 it would have to be stored like this:

environment: E1, E2
person: (A, Desc of player A)
player: (A, E1), (A, E2)

The problem is that both players share the same description.
I think we can remove the person table and just have the other 2:

environment:
        Name of place
player:
        A environment
        Name
        Notes

So the above example would now look like this:

environment: E1, E2
player: (E1, A, Desc of player E1A), (E2, A, Desc of player E2A)

Any thoughts?

Jon





reply via email to

[Prev in Thread] Current Thread [Next in Thread]