<?php
class CustomerTable extends Table
{

	const C_TABLE                       = "CUSTOMER";
	const C_ID                          = "CUSTOMER_ID";
	const C_PK                 			= "CUSTOMER_ID";
	const C_CODE                        = "CUSTOMER_CODE";
	const C_STATUS                      = "CUSTOMER_STATUS";
	const C_NAME                        = "CUSTOMER_NAME";
	const C_ADDRESS             		= "CUSTOMER_ADDRESS";
	const C_TELEPHONE             		= "CUSTOMER_TELEPHONE";
	const C_FAX             			= "CUSTOMER_FAX";
	const C_COMPANY_REG_NO              = "CUSTOMER_COMPANY_REG_NO";

	const C_INDUSTRY 	                = "CUSTOMER_INDUSTRY";
	const C_BUSINESS_SECTOR             = "CUSTOMER_BUSINESS_SECTOR";
	const C_NUM_PEOPLE             		= "CUSTOMER_NO_PEOPLE";
	const C_TURN_OVER              		= "CUSTOMER_SALES_TURN_OVER";

	const C_WEB            				= "CUSTOMER_WEB";
	const C_SUN_VERSION            		= "CUSTOMER_SUNSYSTEM_VERSION";
	const C_MSSQL_VERSION          		= "CUSTOMER_MSSQL_VERSION";
	const C_QA_VERSION             		= "CUSTOMER_QA_VERSION";
	const C_WIN_SERVER_VERSION    		= "CUSTOMER_WINDOWS_SERVER_VERSION";
	const C_SUPP_PARTNER           		= "CUSTOMER_SUPPORTING_PARTNER";

	const C_SOFTWARE_INFO         		= "CUSTOMER_SOFTWARE_INFO";
	const C_BILLING_CYCLE             	= "CUSTOMER_BILLING_CYCLE";
	const C_REMARKS              		= "CUSTOMER_REMARKS";
	
	const C_CUS_ACC              		= "CUSTOMER_ACCOUNT";

	const C_COMP_POLICY            		= "CUSTOMER_COMPANY_POLICY";
	const C_PROD_CONVERSATION      		= "CUSTOMER_PRODUCT_CONVERSATION";

	const C_PRIMARY_REMOTE            	= "CUSTOMER_PRIMARY_REMOTE_ACCESS";
	const C_SECOND_REMOTE          		= "CUSTOMER_SECOND_REMOTE_ACCESS";
	
	const C_PRIMARY_MESG            	= "CUSTOMER_PRIMARY_VIDEO_MESSAGE";
	const C_SECOND_MESG           		= "CUSTOMER_SECOND_VIDEO_MESSAGE";

	const C_LOGO 	             		= "CUSTOMER_LOGO";
}

class CustomerTableDetail extends TableDetail
{

	const C_ID                          = "identity||NO|";
	const C_CODE                        = "nvarchar|100|NO|''";
	const C_STATUS                      = "int||NO|(0)";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_ADDRESS	          			= "nvarchar|4000|NO|''";
	const C_TELEPHONE	       			= "nvarchar|255|NO|''";
	const C_FAX	       					= "nvarchar|255|NO|''";
	const C_COMPANY_REG_NO 	            = "nvarchar|100|NO|''";

	const C_INDUSTRY              		= "nvarchar|4000|NO|''";
	const C_BUSINESS_SECTOR             = "nvarchar|4000|NO|''";
	const C_WEB             			= "nvarchar|4000|NO|''";
	const C_NUM_PEOPLE              	= "nvarchar|100|NO|''";
	const C_TURN_OVER  					= "nvarchar|100|NO|''";

	const C_SUN_VERSION              	= "nvarchar|100|NO|''";
	const C_MSSQL_VERSION              	= "nvarchar|100|NO|''";
	const C_QA_VERSION              	= "nvarchar|100|NO|''";
	const C_WIN_SERVER_VERSION          = "nvarchar|100|NO|''";
	const C_SUPP_PARTNER  				= "nvarchar|255|NO|''";

	const C_SOFTWARE_INFO              	= "nvarchar|255|NO|''";
	const C_BILLING_CYCLE              	= "nvarchar|255|NO|''";
	const C_REMARKS              		= "ntext||NO|''";


	const C_CUS_ACC              		= "nvarchar|255|NO|''";

	const C_COMP_POLICY              	= "ntext||NO|''";
	const C_PROD_CONVERSATION          	= "ntext||NO|''";

	const C_PRIMARY_REMOTE              = "int||NO|(0)";
	const C_SECOND_REMOTE              	= "int||NO|(0)";
	
	const C_PRIMARY_MESG              	= "int||NO|(0)";
	const C_SECOND_MESG              	= "int||NO|(0)";

	const C_LOGO              			= "ntext||NO|''";
}

class CustomerTableDescription extends TableDescription
{
    const C_ID                          = "ID";
	const C_CODE                        = "Code";
	const C_STATUS                      = "Status";
	const C_NAME                        = "Name";
	const C_ADDRESS             		= "Address";
	const C_TELEPHONE             		= "Telephone";
	const C_FAX             			= "Fax";
	const C_COMPANY_REG_NO              = "Company Reg No";

	const C_INDUSTRY 	                = "Industry";
	const C_BUSINESS_SECTOR             = "Business Sector";
	const C_NUM_PEOPLE             		= "Number of People";
	const C_TURN_OVER              		= "Sales Turn Over";

	const C_WEB            				= "Website";
	const C_SUN_VERSION            		= "Sunsystems Version";
	const C_MSSQL_VERSION          		= "MSSQL Version";
	const C_QA_VERSION             		= "QA Version";
	const C_WIN_SERVER_VERSION    		= "Windows Server Version";
	const C_SUPP_PARTNER           		= "Supporting Partner";

	const C_SOFTWARE_INFO         		= "Software Info";
	const C_BILLING_CYCLE             	= "Billing Cycle";
	const C_REMARKS              		= "Remarks";
	
	const C_CUS_ACC              		= "Account";

	const C_COMP_POLICY            		= "Company Policy";
	const C_PROD_CONVERSATION      		= "Product Conversation";

	const C_PRIMARY_REMOTE            	= "Primary Remote";
	const C_SECOND_REMOTE          		= "Secondary Remote";
	
	const C_PRIMARY_MESG            	= "Primary Message";
	const C_SECOND_MESG           		= "Secondary Message";

	const C_LOGO 	             		= "Logo";
}
