Suggestion to add comments to table fields

Development forum for the EQ2Emulator Database project.

Moderator: Team Members

Post Reply
Darq
Posts: 5
Joined: Sun Mar 02, 2008 5:18 am

Suggestion to add comments to table fields

Post by Darq » Thu Mar 06, 2008 3:05 am

They could be either descriptions or links to wiki entries
for instance
spell_effect_values
This table is for this and that
id: (int) unique id
To distinguish effects from each other
type: (int) spell_effect_types unique id
This is what the spell will do
and so on
oh btw i've just noticed
spell_effect_values.type is smallint but should be at least the same as spell_effect_types.id == int
better would be the id of a list of effects for that particualar spell

Andrew
Retired
Posts: 71
Joined: Fri Dec 14, 2007 8:33 am
Location: England
Contact:

Post by Andrew » Thu Mar 06, 2008 8:11 am

In the wiki sounds better, then it is searchable. Get to work! :lol:

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Thu Mar 06, 2008 12:07 pm

Aye, adding comments to databases is for noobs. But I do like the Wiki idea. Detail out the DB schema with descriptions there. Community supported. I'm all for that.
Remember: DB schema is still changing, and will change for some time. Do not get to ahead of yourself, since table names and purpose will likely change.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests