Query Template: ../../test4.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 3.73 ms Record Count: 68 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 = 'mastertenants' 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 | BID | int | 0 | MUL | 0 | NO | int | ||||
3 | CID | int | 0 | MUL | 0 | NO | int | ||||
4 | old_UID | int | 0 | 0 | NO | int | |||||
5 | old_CID | int | 0 | 0 | NO | int | |||||
6 | Company | varchar | 0 | YES | 255 | varchar(255) | latin1 | ||||
7 | FirstName | varchar | YES | 100 | varchar(100) | latin1 | |||||
8 | LastName | varchar | YES | 100 | varchar(100) | latin1 | |||||
9 | varchar | YES | 255 | varchar(255) | latin1 | ||||||
10 | Email2 | varchar | YES | 200 | varchar(200) | latin1 | |||||
11 | Email3 | varchar | YES | 200 | varchar(200) | latin1 | |||||
12 | Phone | varchar | YES | 50 | varchar(50) | latin1 | |||||
13 | Username | varchar | MUL | YES | 50 | varchar(50) | latin1 | ||||
14 | Suite | varchar | YES | 100 | varchar(100) | latin1 | |||||
15 | Fax | varchar | YES | 50 | varchar(50) | latin1 | |||||
16 | Live | char | yes | NO | 3 | char(3) | latin1 | ||||
17 | Floor | int | 0 | 0 | NO | int | |||||
18 | EmergencyNumber | varchar | YES | 50 | varchar(50) | latin1 | |||||
19 | DateAdded | datetime | 0000-00-00 00:00:00 | YES | datetime | ||||||
20 | LastEmail | datetime | 0000-00-00 00:00:00 | YES | datetime | ||||||
21 | SendEmail | char | no | YES | 3 | char(3) | latin1 | ||||
22 | SMSNumber | varchar | YES | 100 | varchar(100) | latin1 | |||||
23 | SMSProvider | int | 0 | 0 | YES | int | |||||
24 | SecureAreas | char | MUL | no | NO | 3 | char(3) | latin1 | |||
25 | ENS | char | no | YES | 3 | char(3) | latin1 | ||||
26 | Title | varchar | YES | 255 | varchar(255) | latin1 | |||||
27 | EmailPreference | varchar | none | YES | 5 | varchar(5) | latin1 | ||||
28 | CalendarSub | char | yes | YES | 3 | char(3) | latin1 | ||||
29 | InstantAlertSub | char | yes | YES | 3 | char(3) | latin1 | ||||
30 | ENSSub | char | yes | YES | 3 | char(3) | latin1 | ||||
31 | InstantAlertLevel | varchar | all | YES | 15 | varchar(15) | latin1 | ||||
32 | InstantAlertEmergency | char | yes | YES | 3 | char(3) | latin1 | ||||
33 | Custom1Data | varchar | YES | 255 | varchar(255) | latin1 | |||||
34 | Custom2Data | varchar | YES | 255 | varchar(255) | latin1 | |||||
35 | Custom3Data | varchar | YES | 255 | varchar(255) | latin1 | |||||
36 | Custom4Data | varchar | YES | 255 | varchar(255) | latin1 | |||||
37 | Custom5Data | varchar | YES | 255 | varchar(255) | latin1 | |||||
38 | AllowServiceRequests | char | MUL | yes | YES | 3 | char(3) | latin1 | |||
39 | AllowConference | char | MUL | yes | YES | 3 | char(3) | latin1 | |||
40 | AllowFreight | char | MUL | yes | YES | 3 | char(3) | latin1 | |||
41 | AllowCert | char | MUL | yes | YES | 3 | char(3) | latin1 | |||
42 | Tagged | char | no | NO | 5 | char(5) | latin1 | ||||
43 | NewEmail | varchar | none | NO | 255 | varchar(255) | latin1 | ||||
44 | OldEmail | varchar | none | NO | 255 | varchar(255) | latin1 | ||||
45 | UserBrowser | text | YES | 65535 | text | latin1 | |||||
46 | SyncID | int | 0 | 0 | NO | int | |||||
47 | DateUpdated | timestamp | YES | timestamp | |||||||
48 | LastLogin | datetime | YES | datetime | |||||||
49 | AllowTenantAdmin | char | no | NO | 3 | char(3) | latin1 | ||||
50 | LeaseID | varchar | YES | 255 | varchar(255) | latin1 | |||||
51 | EmailBounceCount | int | 0 | 0 | NO | int | |||||
52 | LastEmailError | varchar | YES | 255 | varchar(255) | latin1 | |||||
53 | forceUsernameChange | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
54 | duplicateUserFlag | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
55 | tabscheck | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
56 | duplicateUserEmailSent | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
57 | userID | int | 0 | MUL | YES | int | |||||
58 | requestSource | varchar | desktop | NO | 50 | varchar(50) | latin1 | ||||
59 | ReceiveEmailNotifications | bit | b'0' | NO | bit(1) | ||||||
60 | ReceiveHighPriorityEmailOnly | bit | b'0' | NO | bit(1) | ||||||
61 | ReceiveTextNotifications | bit | b'0' | NO | bit(1) | ||||||
62 | ReceiveHighPriorityTextOnly | bit | b'0' | NO | bit(1) | ||||||
63 | usermerged | varchar | false | NO | 5 | varchar(5) | latin1 | ||||
64 | usermergeflagged | varchar | false | NO | 5 | varchar(5) | latin1 | ||||
65 | PushNotifyViewed | varchar | no | NO | 3 | varchar(3) | latin1 | ||||
66 | password | varchar | YES | 255 | varchar(255) | latin1 | |||||
67 | receiveNegativeSRRatingEmails | bit | b'0' | NO | bit(1) | ||||||
68 | receivePositiveSRRatingEmails | bit | b'0' | NO | bit(1) |