Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Database design

Quote Reply
Database design
Hi all,

I have a little logic problem.
Lets say I have a Users Table in my SQL Database. This table has fields for Name, email etc. Now I'd like to have fields for Qualifications, Abilities.

I have a Table of different Qualifications

1 Qualific.1
2 Qualific.2
3 Qualific.3
.
.
.
n Qualific.n

I have a Table of different Abilities

1 Ability 1
2 Ability 2
3 Ability 3
.
.
.
n.Ability n

Now each user should be able to have as many Qualifications as he wants. As well as abilities.

How should I save this information?

Make a field User.Qualification and store the ID's of the Qualifications there? (in a list? 1,4,5,78,192...) and how long should this fieldlength be? What happens if it's full? Print an error "sorry you are overqualified!"?

or make extra tables with the relations:

UserId
Qualific. ID

Does anybody know a more elegant way to solve this?


regards, alexander


Subject Author Views Date
Thread Database design Alex404 2963 Sep 18, 2000, 6:24 AM
Thread Re: Database design
Stealth 2882 Sep 18, 2000, 8:15 AM
Thread Re: Database design
Alex404 2868 Sep 18, 2000, 10:06 AM
Thread Re: Database design
Stealth 2868 Sep 18, 2000, 10:44 AM
Post Re: Database design
Alex404 2844 Sep 20, 2000, 7:04 AM