Understanding MySQL Database Tables

This topic provides information about understanding how to interpret the MySQL database table information and provides information about name changes that are necessary for migrating the Motor Vehicle Registration database to a MySQL database.

Understanding MySQL Table Information

Each MySQL Table describes the fields that exist in each record in a table or file within the database.  The table below describes the information that is displayed in a MySQL Table.

Note:  To see a list of MySQL Tables for the files in the software module, refer to the Invision Motor Vehicle Registration MySQL Database Overview.

Invision Motor Vehicle Registration MySQL Table Columns

Field Name Column

Lists the name of the field.  All tables are made up of one or more fields.

Notes:

  • The field name is required for the report or project that you build using iKnowSys™ or a third-party application, such as, Crystal Reports™.

  • Frequently, you can click the field name to see more information about the field and where it is used.

Datatype Column

Defines what type of data the field contains and sometimes describes the field format.  This information may be helpful when planning your project.

  • decimal(x,y):  Indicates a numeric field with digits to the left and right of the decimal place where x is the number of digits to the left of the decimal and y is the number of digits to the right of the decimal.
    Example    :  (4,2) means 4 digits to the left and 2 digits to the right of the decimal, a total of 6 digits.

  • int:  Indicates a four-byte integer value that supports numbers from -2147483648 to 2147483647.

  • varchar:  Indicates an alphanumeric field that contains a string of text.  A text string can contain any combination of characters including letters, words, numbers, and spaces.

  • time:  Indicates a time value.

  • date:  Indicates a date value.