| Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.61 ms Record Count: 34 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 = 'certinsurancecompanyprefs' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION | |||||||||||
| COLUMN_NAME | DATA_TYPE | NUMERIC_SCALE | COLUMN_KEY | COLUMN_DEFAULT | IS_NULLABLE | CHARACTER_MAXIMUM_LENGTH | COLUMN_TYPE | EXTRA | CHARACTER_SET_NAME | ||
| 1 | id | int | 0 | PRI | NO | int | auto_increment | ||||
| 2 | CompanyID | int | 0 | 0 | NO | int | |||||
| 3 | UseDefaultLimits | char | yes | YES | 50 | char(50) | latin1 | ||||
| 4 | NoCertNotification | char | yes | YES | 50 | char(50) | latin1 | ||||
| 5 | glEach | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 6 | glFire | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 7 | glMedExp | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 8 | glGeneralAgg | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 9 | glProducts | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 10 | alCombined | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 11 | alBodily | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 12 | alProperty | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 13 | galAuto | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 14 | galOther | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 15 | galEach | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 16 | galAgg | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 17 | wcAccident | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 18 | wcEmployee | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 19 | wcPolicy | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 20 | elEach | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 21 | elAgg | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 22 | propOccurrence | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 23 | crimeEmployeeDishonesty | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 24 | eliEachOccurrence | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 25 | eliAggregate | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 26 | paiEachOccurrence | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 27 | paiAggregate | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 28 | cyberEachOccurrence | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 29 | cyberAggregate | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 30 | plEachOccurrence | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 31 | plAggregate | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 32 | CompanyEmail | varchar | YES | 50 | varchar(50) | latin1 | |||||
| 33 | NoCertOnFileEmail | varchar | no | YES | 3 | varchar(3) | latin1 | ||||
| 34 | LimitSetting | varchar | General | NO | 50 | varchar(50) | latin1 | ||||