Query Template: ../../test4.utilities.tenanthandbooks.com/httpdocs/core/components/utilities/databaseconnector.cfc:138 Execution Time: 3.07 ms Record Count: 55 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 = 'mrbuildings' 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	BuildingID	int	0	PRI		NO		int	auto_increment
2	BID	int	0	MUL		YES		int
3	Name	varchar				YES	255	varchar(255)		latin1
4	Phone	varchar				YES	20	varchar(20)		latin1
5	Email	varchar			noReply@tenanthandbooks.com	YES	255	varchar(255)		latin1
6	Company	varchar				YES	15	varchar(15)		latin1
7	Live	char			Yes	YES	3	char(3)		latin1
8	FromEmail	varchar			noReply@tenanthandbooks.com	YES	100	varchar(100)		latin1
9	FromEmailOn	char			No	YES	3	char(3)		latin1
10	Code	varchar		UNI	00000	YES	15	varchar(15)		latin1
11	ShowStatus	char			Yes	NO	3	char(3)		latin1
12	ShowAccountRequest	char			no	NO	3	char(3)		latin1
13	ShowContractor	char			yes	NO	3	char(3)		latin1
14	EmailAlarm	varchar			none	YES	15	varchar(15)		latin1
15	ShowBillable	char			yes	NO	3	char(3)		latin1
16	Custom1	varchar				YES	50	varchar(50)		latin1
17	Custom2	varchar				YES	50	varchar(50)		latin1
18	Custom3	varchar				YES	50	varchar(50)		latin1
19	Custom4	varchar				YES	50	varchar(50)		latin1
20	Custom5	varchar				YES	50	varchar(50)		latin1
21	BillingID	varchar				YES	75	varchar(75)		latin1
22	ShowTACBillable	varchar			no	NO	3	varchar(3)		latin1
23	RequestDetails	varchar			Please note that some requests may incur charges. In these instances, you will be notified by the management office. To obtain a schedule of fees, please contact the Management Office	NO	255	varchar(255)		latin1
24	DefaultTicketStatus	varchar			open	NO	15	varchar(15)		latin1
25	ArchiveData	int	0		1095	NO		int
26	EnableBillableSystem	varchar			yes	NO	3	varchar(3)		latin1
27	EnableAlarmSystem	varchar			yes	NO	3	varchar(3)		latin1
28	SignOffSheetHeader	varchar			Work Order	NO	50	varchar(50)		latin1
29	FinalizedStatus	varchar			Completed	NO	255	varchar(255)		latin1
30	AllowTCFutureRequests	varchar			yes	NO	45	varchar(45)		latin1
31	ShowTaskAssignments	char			no	NO	3	char(3)		latin1
32	YardiAccountCode	varchar				YES	75	varchar(75)		latin1
33	YardiReportVersion	varchar				YES	75	varchar(75)		latin1
34	MRIReportVersion	varchar			mri_v1	NO	75	varchar(75)		latin1
35	alarmDays	varchar			2,3,4,5,6	NO	15	varchar(15)		latin1
36	AlarmNotifyFrom_1	varchar			6:00 AM	NO	10	varchar(10)		latin1
37	AlarmNotifyFrom_2	varchar			6:00 AM	NO	10	varchar(10)		latin1
38	AlarmNotifyFrom_3	varchar			6:00 AM	NO	10	varchar(10)		latin1
39	AlarmNotifyFrom_4	varchar			6:00 AM	NO	10	varchar(10)		latin1
40	AlarmNotifyFrom_5	varchar			6:00 AM	NO	10	varchar(10)		latin1
41	AlarmNotifyFrom_6	varchar			6:00 AM	NO	10	varchar(10)		latin1
42	AlarmNotifyFrom_7	varchar			6:00 AM	NO	10	varchar(10)		latin1
43	AlarmNotifyTo_1	varchar			6:00 PM	NO	10	varchar(10)		latin1
44	AlarmNotifyTo_2	varchar			6:00 PM	NO	10	varchar(10)		latin1
45	AlarmNotifyTo_3	varchar			6:00 PM	NO	10	varchar(10)		latin1
46	AlarmNotifyTo_4	varchar			6:00 PM	NO	10	varchar(10)		latin1
47	AlarmNotifyTo_5	varchar			6:00 PM	NO	10	varchar(10)		latin1
48	AlarmNotifyTo_6	varchar			6:00 PM	NO	10	varchar(10)		latin1
49	AlarmNotifyTo_7	varchar			6:00 PM	NO	10	varchar(10)		latin1
50	notifyDesigneeCommEmails	varchar			No	NO	3	varchar(3)		latin1
51	notifyEmailDesigneeCommEmails	varchar			No	NO	3	varchar(3)		latin1
52	JDEdwardsReportAccess	varchar			no	NO	10	varchar(10)		latin1
53	AllowDeletingRequests	varchar			yes	NO	10	varchar(10)		latin1
54	EnableSatisfactionSurvey	varchar			No	NO	10	varchar(10)		latin1
55	IncludeSatisfactionRatingStatuses	varchar				YES	255	varchar(255)		latin1