Become Familiar with the Database

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

In order to effectively run reports, one needs to become familiar with the database. There are two commands which can help.

The first command is `show tables`. When you run this command, it will give you a list of all the tables in the database.

The second command begins with the keyword `explain` followed by the table name. For example, if you run the command `explain course_sec` through the SQL Terminal, the command will return a list of field names along with other information about those field names in the `course_sec` table.

Also, it would probably be a great idea to create a document with all the tables and their field names so that you can have them on hand when needing to run ad-hoc reports.

Last Modified: May 9, 2015 @ 7:16 PM

Was this article helpful?

Related Articles