Understanding MySQL Database Tables
This topic provides information about understanding how to interpret
the MySQL database table information.
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 General
Ledger MySQL Database Overview.
|
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. |