Back
Query
Template: ../../test4.utilities.tenanthandbooks.com/httpdocs/core/components/utilities/databaseconnector.cfc:138
Execution Time: 2.26 ms
Record Count: 15
Cached: No
Lazy: No
SQL:
SELECT
COLUMN_NAME,
DATA_TYPE,
NUMERIC_SCALE,
COLUMN_KEY,
COLUMN_DEFAULT,
IS_NULLABLE,
CHARACTER_MAXIMUM_LENGTH,
COLUMN_TYPE,
EXTRA,
CHARACTER_SET_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'queuedevents'
AND TABLE_SCHEMA = DATABASE()
ORDER BY
ORDINAL_POSITION
COLUMN_NAMEDATA_TYPENUMERIC_SCALECOLUMN_KEYCOLUMN_DEFAULTIS_NULLABLECHARACTER_MAXIMUM_LENGTHCOLUMN_TYPEEXTRACHARACTER_SET_NAME
1idint0PRINOintauto_increment
2DateEntereddatetimeYESdatetime
3DateRundatetimeYESdatetime
4ComponentvarcharYES255varchar(255)latin1
5MethodvarcharYES255varchar(255)latin1
6ArgumentslongtextYES4294967295longtextlatin1
7StatusvarcharMULYES50varchar(50)latin1
8StatusMessagelongtextYES4294967295longtextutf8mb4
9RunStartdatetimeYESdatetime
10RunUUIDvarcharYES255varchar(255)latin1
11ScheduledDatedatetimeYESdatetime
12Priorityint0YESint
13ResulttextYES65535textlatin1
14SuccessEventlongtextYES4294967295longtextlatin1
15FailureEventlongtextYES4294967295longtextlatin1