What are Asterisk's database fields?

[bryceowen]

I was wondering if there was a list of what tables and fields are in the Asterisk database. I want to write a couple scripts to pull only the information we need and I'm hoping I don't have to pick through all the Vicidial PHP files to find the fields the hard way.

[mflorell]

The MySQL_AST_CREATE_tables.sql file has all of the tables listed in it since that is the file used to create the tables.