[Top][All Lists]
[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
- [Bug-gnubg] Not sure about person table in new database,
Jon Kinsey <=