Query Template: ../../test1.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 2.27 ms Record Count: 24 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 = 'mrassignee' 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 | Name | varchar | NO | 255 | varchar(255) | latin1 | |||||
3 | MGID | int | 0 | MUL | 0 | NO | int | ||||
4 | NewMGID | int | 0 | MUL | 0 | NO | int | ||||
5 | varchar | MUL | NO | 255 | varchar(255) | latin1 | |||||
6 | Live | char | MUL | Yes | NO | 3 | char(3) | latin1 | |||
7 | Username | varchar | NO | 50 | varchar(50) | latin1 | |||||
8 | ShowContact | char | no | NO | 3 | char(3) | latin1 | ||||
9 | Phone | varchar | NO | 50 | varchar(50) | latin1 | |||||
10 | ShowRequests | varchar | yes | NO | 50 | varchar(50) | latin1 | ||||
11 | MrlogPref | varchar | NO | 10 | varchar(10) | latin1 | |||||
12 | DesigneeType | varchar | Staff | NO | 50 | varchar(50) | latin1 | ||||
13 | EmailNotice | char | YES | 3 | char(3) | latin1 | |||||
14 | AdditionalEmailOption | text | YES | 65535 | text | latin1 | |||||
15 | DeletedBy | int | 0 | 0 | YES | int | |||||
16 | DeletedDate | datetime | YES | datetime | |||||||
17 | Title | varchar | YES | 255 | varchar(255) | latin1 | |||||
18 | AssignRequests | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
19 | userID | int | 0 | MUL | YES | int | |||||
20 | CreateRequests | char | no | NO | 3 | char(3) | latin1 | ||||
21 | usermerged | varchar | false | NO | 5 | varchar(5) | latin1 | ||||
22 | PushNotifyViewed | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
23 | password | varchar | YES | 255 | varchar(255) | latin1 | |||||
24 | CreateCommunications | char | no | NO | 3 | char(3) | latin1 |