Database help

[Samson123]

Im looking for a database structure.Something that will tell me what each table is used for and what values can be used.I have went to most database sites whydb and so forth and looked into there wiki but most of them have missing data.Im trying to get the most information i can to best use the database tables for quest and npc reasons.Any help would be great.

[AngelSandy]

I think you are asking for the wrong thing then.
The structure SQL's are there to construct your Database tables.

The database you download, forexample WhyDB, is just filling your database out with information so that your core can use it.

[Samson123]

you miss understand.Im looking for table commands for exaple <Im making a npc and on the creature_spawns table there is a sub table movetype.I need to know what i can use there as in 1=walk 2=run 3=fly .And i was wanting the hole list for all of the database tables.I hope this explains it more.

[thegwd]

I looked for quite some time for something that would do this, but the 2nd post is a hard reality... Since each servers DB is different and is not made to be clean for people to view it here is my suggestion.

Eventually you will know what each column does, until then you should use things like WoWhead.com to find spell ID's and stats to match up just what each column does. I made myself a Word Document and went through and titled all the DB columns I needed so that in case I forgot what one did I could go back and see what that column does.

Hope this helps :S