mysql> show tables;
+------------------------+
| Tables_in_Catalog_Work |
+------------------------+
| COLLEGEWIDE_REQ        |
| CORE_REQ               |
| COURSES                |
| DEGREES                |
| DEPARTMENTS            |
| DISCIPLINES            |
| DIVISIONS              |
| DOUBLEFLAGS            |
| GENERAL_REQ            |
| LEVELS                 |
| MAJORS                 |
| MAJOR_REQ              |
| MINORS                 |
| MINOR_REQ              |
| SCHOOLS                |
| TRANSFER_REQ           |
| USERS                  |
+------------------------+

mysql> DESCRIBE SCHOOLS;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| SchoolID   | int(11)      |      | PRI | NULL    | auto_increment |
| SchoolName | varchar(100) |      |     |         |                |
+------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE DIVISIONS;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| DivisionID   | int(11)      |      | PRI | NULL    | auto_increment |
| DivisionName | varchar(100) |      |     |         |                |
| SchoolID     | int(11)      |      |     | 0       |                |
+--------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE DEPARTMENTS;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| DepartmentID   | int(11)      |      | PRI | NULL    | auto_increment |
| DepartmentName | varchar(100) |      |     |         |                |
| DivisionID     | int(11)      |      |     | 0       |                |
+----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE DEGREES;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| DegreeID     | int(11)      |      | PRI | NULL    | auto_increment |
| DegreeName   | varchar(100) |      |     |         |                |
| DegreeCode   | varchar(5)   |      |     |         |                |
| TotalCredits | int(11)      |      |     | 0       |                |
| LiberalArts  | int(11)      |      |     | 0       |                |
+--------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE DISCIPLINES;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| DisciplineID   | int(11)      |      | PRI | NULL    | auto_increment |
| DisciplineCode | varchar(5)   |      |     |         |                |
| DisciplineName | varchar(100) |      |     |         |                |
+----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE DOUBLEFLAGS;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| DoubleflagID   | int(11)      |      | PRI | NULL    | auto_increment |
| DoubleflagName | varchar(100) |      |     |         |                |
+----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE LEVELS;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| LevelID   | int(11)      |      | PRI | NULL    | auto_increment |
| LevelName | varchar(100) |      |     |         |                |
+-----------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE MAJORS;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| MajorID      | int(11)      |      | PRI | NULL    | auto_increment |
| MajorName    | varchar(100) |      |     |         |                |
| MajorCode    | char(3)      |      |     |         |                |
| DoubleFlagID | int(11)      |      |     | 0       |                |
| DegreeID     | int(11)      |      |     | 0       |                |
+--------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE MAJOR_REQ;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| ID         | int(11)      |      | PRI | NULL    | auto_increment |
| Credits    | int(11)      |      |     | 0       |                |
| CourseList | varchar(255) |      |     |         |                |
| MajorID    | int(11)      | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE MINORS;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| MinorID          | int(11)      |      | PRI | NULL    | auto_increment |
| MinorName        | varchar(100) |      |     |         |                |
| MinorCode        | char(3)      |      |     |         |                |
| NotAvailableList | varchar(100) |      |     |         |                |
+------------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE MINOR_REQ;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| ID         | int(11)      |      | PRI | NULL    | auto_increment |
| Credits    | int(11)      |      |     | 0       |                |
| CourseList | varchar(255) |      |     |         |                |
| MinorID    | int(11)      | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+



mysql> describe COLLEGEWIDE_REQ;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| ID              | int(11)      |      | PRI | NULL    | auto_increment |
| CreditsRequired | int(11)      |      |     | 0       |                |
| CourseList      | varchar(255) |      |     |         |                |
+-----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE CORE_REQ;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| ID              | int(11)      |      | PRI | NULL    | auto_increment |
| CreditsRequired | int(11)      |      |     | 0       |                |
| CourseList      | varchar(255) |      |     |         |                |
+-----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE TRANSFER_REQ;
+-----------------+---------+------+-----+---------+----------------+
| Field           | Type    | Null | Key | Default | Extra          |
+-----------------+---------+------+-----+---------+----------------+
| ID              | int(11) |      | PRI | NULL    | auto_increment |
| TransferCredits | int(11) |      |     | 0       |                |
| CoreRequired    | int(11) |      |     | 0       |                |
+-----------------+---------+------+-----+---------+----------------+

mysql> DESCRIBE GENERAL_REQ;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ID          | int(11)      |      | PRI | NULL    | auto_increment |
| Description | varchar(255) |      |     |         |                |
+-------------+--------------+------+-----+---------+----------------+


mysql> DESCRIBE COURSES;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| CourseID        | int(11)      |      | PRI | NULL    | auto_increment |
| CourseNumber    | varchar(5)   |      |     |         |                |
| CourseNumberNew | varchar(5)   |      |     |         |                |
| CourseLetter    | varchar(5)   | YES  |     | NULL    |                |
| CourseCode      | varchar(12)  |      |     |         |                |
| CourseName      | varchar(100) |      |     |         |                |
| Credits         | int(11)      |      |     | 0       |                |
| LevelID         | int(11)      |      |     | 0       |                |
| CrossList       | varchar(255) | YES  |     | NULL    |                |
| PreReqList      | varchar(255) | YES  |     | NULL    |                |
| CoReqList       | varchar(255) | YES  |     | NULL    |                |
| PostReqList     | varchar(255) | YES  |     | NULL    |                |
| DivisionID      | int(11)      | YES  |     | NULL    |                |
| DisciplineID    | int(11)      | YES  |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+

mysql> DESCRIBE USERS;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| UserID   | int(11)     |      | PRI | NULL    | auto_increment |
| UserName | varchar(50) |      |     |         |                |
| Password | varchar(50) |      |     |         |                |
| Name     | varchar(50) |      |     |         |                |
+----------+-------------+------+-----+---------+----------------+