Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.24 ms Record Count: 37 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 = 'mastermod' 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	MODID	int	0	PRI		NO		int	auto_increment
2	BID	int	0	MUL		YES		int
3	GeneralForm	char			No	YES	3	char(3)		latin1
4	MaintenanceForm	char			No	YES	3	char(3)		latin1
5	Calendar	char			No	YES	3	char(3)		latin1
6	FeedbackForm	char			No	YES	3	char(3)		latin1
7	AccessAuthForm	char			No	YES	3	char(3)		latin1
8	AccessReqForm	char			No	YES	3	char(3)		latin1
9	EmergencyContactForm	char			No	YES	3	char(3)		latin1
10	ENS	char			No	YES	3	char(3)		latin1
11	CertInsurance	char			No	YES	3	char(3)		latin1
12	WarningSys	char			Yes	YES	3	char(3)		latin1
13	Directory	char			No	YES	3	char(3)		latin1
14	SecureAreas	char			No	YES	3	char(3)		latin1
15	SiteMap	char			no	YES	3	char(3)		latin1
16	Search	char			no	YES	3	char(3)		latin1
17	Freight	char			no	YES	3	char(3)		latin1
18	PMSystem	char			no	YES	3	char(3)		latin1
19	SecureBooks	char			no	YES	3	char(3)		latin1
20	Leasing	char			no	YES	3	char(3)		latin1
21	Conference	char			no	YES	3	char(3)		latin1
22	TenantContact	char			no	YES	3	char(3)		latin1
23	TenantContactBasic	char			yes	YES	3	char(3)		latin1
24	Survey	char			no	YES	3	char(3)		latin1
25	Testing	char			no	NO	3	char(3)		latin1
26	mobileHandbook	char			no	NO	3	char(3)		latin1
27	tenantPortal	char			no	YES	3	char(3)		latin1
28	employeePortal	char			no	YES	3	char(3)		latin1
29	leasingPortal	char			no	YES	3	char(3)		latin1
30	machEnergy	char			no	YES	3	char(3)		latin1
31	Designee	char			no	YES	3	char(3)		latin1
32	SustainabilityCampaign	char			no	YES	3	char(3)		latin1
33	EnergyCampaign	char			no	YES	3	char(3)		latin1
34	PreparednessCampaign	char			no	YES	3	char(3)		latin1
35	Communications	char			no	YES	3	char(3)		latin1
36	PropertyPlus	char			no	YES	3	char(3)		latin1
37	Inspection	char			no	YES	3	char(3)		latin1