Detail Forms: Schema Differences
Schema Checker is a view-only form that checks to see if the schema number of the database and application match. The form will display any differences it finds and you can download these records into a .csv file.
Normally when you install or upgrade the Shop Floor Time application and database schema, the application and database schemas will match. The database and application schemas may be different if, for example, a change script is applied to the database or the database schema upgrade fails.
The Schema Checker form will provide details as to which database objects have caused the database and application schemas to be different
The differences that are shown in this form will be color coded.
Green indicates no differences between the database and application schema.
Yellow indicates there are extra items (such as extra tables) in the database schema that are not in the application schema. Note that extra columns will appear in red as they are changes to an existing table.
Red is used for any other differences between the database and application schema (such as missing keys in the database)
Schema Checker records can also be viewed in a portlet in the System Dashboard.
See Also:
Schema Checker Field Descriptions
DB Schema Version
Schema number of your Shop Floor Time database.
The DB Schema Version must match the App Schema Version.
App Schema Version
Schema number of the Shop Floor Time application.
DB Patch Version
Patch number of your Shop Floor Time database.
App Patch Version
Patch number of your Shop Floor Time application.
Category
The differences shown in the Schema Checker form will be organized into the categories listed below. When you select a category, the Schema Differences tab at the bottom of the form will list these differences with more detail. You can also click View All Differences to see a list of differences in all the categories.
Table
Column
Primary Key
Unique Constraint
Index
Foreign Key
Sequence
Trigger
Procedure
View
# Differences
Number of differences between the application and database schemas for a specific Category.
The differences that are shown in this form will be color coded.
Green indicates no differences between the database and application schema.
Yellow indicates there are extra items (such as extra tables) in the database schema that are not in the application schema. For example, a custom table will appear in yellow and a sequence that was not included with the application will appear in yellow.
Red is used for any other differences between the database and application schema. For example, a sequence that is lower than the table value will display in red and missing keys in the database will appear in red.
Note that extra columns will appear in red as they are changes to an existing table.
The Schema Differences tab at the bottom of the form will list these differences with more detail. You can also click View All Differences to see a list of differences in all the categories.
To view all the schema differences in a single list, click the View All Differences button. A pop-up window will show the Category, Name, and Message describing the difference. For example, if the Category is Table, the Name column will display the name of the table and the Message column will explain the difference - Extra Table (abc_123 ) found.
Click the Download button to save these records in a .csv file.
The Schema Differences tab at the bottom of the Schema Checker form displays the list of differences for a particular Category. The tab will display the Category, Name of the database object, and a Message that describes the difference.
For example, if the Category is Foreign Key, the Name column will display the name of the foreign key and the Message column will explain the difference - Foreign Key (person_pay_scale_fk1) is missing or not enabled.