Query Template: ../../test1.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 2.88 ms Record Count: 35 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 = 'client' 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 | ClientID | int | 0 | PRI | NO | int | auto_increment | ||||
2 | CID | int | 0 | MUL | YES | int | |||||
3 | AccountStatus | varchar | MUL | Active | NO | 20 | varchar(20) | latin1 | |||
4 | Username | varchar | YES | 50 | varchar(50) | latin1 | |||||
5 | Company | varchar | YES | 255 | varchar(255) | latin1 | |||||
6 | CompanyName | varchar | YES | 255 | varchar(255) | latin1 | |||||
7 | varchar | YES | 255 | varchar(255) | latin1 | ||||||
8 | FirstName | varchar | YES | 255 | varchar(255) | latin1 | |||||
9 | LastName | varchar | YES | 255 | varchar(255) | latin1 | |||||
10 | AccessLevel | int | 0 | 2 | YES | int | |||||
11 | Phone | varchar | YES | 50 | varchar(50) | latin1 | |||||
12 | MGID | int | 0 | MUL | 0 | NO | int | ||||
13 | BetaTester | char | no | NO | 3 | char(3) | latin1 | ||||
14 | UsersBrowser | text | YES | 65535 | text | latin1 | |||||
15 | UsersBrowserShort | varchar | YES | 50 | varchar(50) | latin1 | |||||
16 | ScreenResolution | varchar | YES | 255 | varchar(255) | latin1 | |||||
17 | UsersOS | varchar | YES | 25 | varchar(25) | latin1 | |||||
18 | LastLogin | datetime | YES | datetime | |||||||
19 | JavascriptEnabled | char | YES | 3 | char(3) | latin1 | |||||
20 | Street1 | varchar | YES | 255 | varchar(255) | latin1 | |||||
21 | Street2 | varchar | YES | 255 | varchar(255) | latin1 | |||||
22 | City | varchar | YES | 255 | varchar(255) | latin1 | |||||
23 | State | varchar | YES | 50 | varchar(50) | latin1 | |||||
24 | Zip | varchar | YES | 20 | varchar(20) | latin1 | |||||
25 | Title | varchar | YES | 255 | varchar(255) | latin1 | |||||
26 | ImageName | varchar | YES | 100 | varchar(100) | latin1 | |||||
27 | tabscheck | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
28 | userID | int | 0 | MUL | YES | int | |||||
29 | usernameFlagged | varchar | YES | 3 | varchar(3) | latin1 | |||||
30 | DateAdded | datetime | YES | datetime | |||||||
31 | persona | varchar | undefined | YES | 255 | varchar(255) | latin1 | ||||
32 | npsSubmitDate | datetime | YES | datetime | |||||||
33 | usermerged | varchar | false | NO | 5 | varchar(5) | latin1 | ||||
34 | feedbackTeam | varchar | unknown | YES | 10 | varchar(10) | latin1 | ||||
35 | password | varchar | YES | 255 | varchar(255) | latin1 |