Query Template: ../../test1.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 3.04 ms Record Count: 41 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 = 'users' 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 | password | varchar | NO | 128 | varchar(128) | latin1 | |||||
3 | passwordSalt | varchar | NO | 256 | varchar(256) | latin1 | |||||
4 | passwordFlagged | varchar | YES | 3 | varchar(3) | latin1 | |||||
5 | lastChanged | datetime | YES | datetime | |||||||
6 | tempPasswordDate | datetime | YES | datetime | |||||||
7 | Timezone | varchar | YES | 100 | varchar(100) | latin1 | |||||
8 | Username | varchar | MUL | YES | 50 | varchar(50) | latin1 | ||||
9 | FirstName | varchar | YES | 255 | varchar(255) | latin1 | |||||
10 | LastName | varchar | YES | 255 | varchar(255) | latin1 | |||||
11 | Title | varchar | YES | 255 | varchar(255) | latin1 | |||||
12 | varchar | MUL | YES | 255 | varchar(255) | latin1 | |||||
13 | Email2 | varchar | YES | 255 | varchar(255) | latin1 | |||||
14 | Email3 | varchar | YES | 255 | varchar(255) | latin1 | |||||
15 | Phone | varchar | YES | 50 | varchar(50) | latin1 | |||||
16 | Fax | varchar | YES | 50 | varchar(50) | latin1 | |||||
17 | EmergencyNumber | varchar | YES | 50 | varchar(50) | latin1 | |||||
18 | SMSNumber | varchar | YES | 100 | varchar(100) | latin1 | |||||
19 | formattedSMSNumber | varchar | MUL | YES | 100 | varchar(100) | latin1 | ||||
20 | Suite | varchar | YES | 100 | varchar(100) | latin1 | |||||
21 | Floor | int | 0 | YES | int | ||||||
22 | DateAdded | datetime | YES | datetime | |||||||
23 | DateUpdated | datetime | YES | datetime | |||||||
24 | LastLogin | datetime | YES | datetime | |||||||
25 | UsersBrowser | text | YES | 65535 | text | latin1 | |||||
26 | UsersBrowserShort | varchar | YES | 50 | varchar(50) | latin1 | |||||
27 | ScreenResolution | varchar | YES | 255 | varchar(255) | latin1 | |||||
28 | UsersOS | varchar | YES | 25 | varchar(25) | latin1 | |||||
29 | Street1 | varchar | YES | 255 | varchar(255) | latin1 | |||||
30 | Street2 | varchar | YES | 255 | varchar(255) | latin1 | |||||
31 | City | varchar | YES | 255 | varchar(255) | latin1 | |||||
32 | State | varchar | YES | 50 | varchar(50) | latin1 | |||||
33 | Zip | varchar | YES | 20 | varchar(20) | latin1 | |||||
34 | AccountStatus | varchar | YES | 20 | varchar(20) | latin1 | |||||
35 | UserType | int | 0 | YES | int | ||||||
36 | LastTenant | int | 0 | YES | int | ||||||
37 | PrimaryBID | int | 0 | YES | int | ||||||
38 | ShowNewUserModal | bit | b'1' | NO | bit(1) | ||||||
39 | hideUserFromApps | bit | b'0' | NO | bit(1) | ||||||
40 | showmergeuser | bit | b'0' | NO | bit(1) | ||||||
41 | subscribedAtRequestAccount | bit | YES | bit(1) |