<?php
class CustomerTable extends Table {
	const C_TABLE                       = "CUSTOMER" ;
	const C_ID                          = "CUSTOMER_ID";
	const C_STATUS                      = "CUSTOMER_STATUS";
	const C_NAME                        = "CUSTOMER_NAME";
	const C_CODE                        = "CUSTOMER_CODE";
	const C_WEB                         = "CUSTOMER_WEB";
	const C_TELEPHONE                   = "CUSTOMER_TELEPHONE";
	const C_FAX                         = "CUSTOMER_FAX";
	const C_BILLING              		= "CUSTOMER_BILLING";
	const C_ONSITE              		= "CUSTOMER_ONSITE";

	const C_LIC_NAME              		= "CUSTOMER_LICENSE_NAME";
	const C_LIC_PHONE              		= "CUSTOMER_LICENSE_TELEPHONE";
	const C_LIC_EMAIL              		= "CUSTOMER_LICENSE_EMAIL";
	const C_LIC_DSG              		= "CUSTOMER_LICENSE_DESIGNATED";

	const C_LIC_NAME2              		= "CUSTOMER_LICENSE_NAME2";
	const C_LIC_PHONE2             		= "CUSTOMER_LICENSE_TELEPHONE2";
	const C_LIC_EMAIL2              	= "CUSTOMER_LICENSE_EMAIL2";
	const C_LIC_DSG2              		= "CUSTOMER_LICENSE_DESIGNATED2";

	const C_FIN_NAME              		= "CUSTOMER_FINANCE_NAME";
	const C_FIN_PHONE              		= "CUSTOMER_FINANCE_TELEPHONE";
	const C_FIN_EMAIL              		= "CUSTOMER_FINANCE_EMAIL";
	const C_FIN_DSG              		= "CUSTOMER_FINANCE_DESIGNATED";

	const C_FIN_NAME2              		= "CUSTOMER_FINANCE_NAME2";
	const C_FIN_PHONE2             		= "CUSTOMER_FINANCE_TELEPHONE2";
	const C_FIN_EMAIL2              	= "CUSTOMER_FINANCE_EMAIL2";
	const C_FIN_DSG2              		= "CUSTOMER_FINANCE_DESIGNATED2";

	const C_IT_NAME              		= "CUSTOMER_IT_NAME";
	const C_IT_PHONE              		= "CUSTOMER_IT_TELEPHONE";
	const C_IT_EMAIL              		= "CUSTOMER_IT_EMAIL";
	const C_IT_DSG              		= "CUSTOMER_IT_DESIGNATED";

	const C_IT_NAME2              		= "CUSTOMER_IT_NAME2";
	const C_IT_PHONE2              		= "CUSTOMER_IT_TELEPHONE2";
	const C_IT_EMAIL2              		= "CUSTOMER_IT_EMAIL2";
	const C_IT_DSG2              		= "CUSTOMER_IT_DESIGNATED2";

	const C_PROJ_NAME              		= "CUSTOMER_PROJECT_MANAGER_NAME";
	const C_PROJ_PHONE              	= "CUSTOMER_PROJECT_MANAGER_TELEPHONE";
	const C_PROJ_EMAIL              	= "CUSTOMER_PROJECT_MANAGER_EMAIL";
	const C_PROJ_DSG              		= "CUSTOMER_PROJECT_MANAGER_DESIGNATED";

	const C_PROJ_NAME2              	= "CUSTOMER_PROJECT_MANAGER_NAME2";
	const C_PROJ_PHONE2              	= "CUSTOMER_PROJECT_MANAGER_TELEPHONE2";
	const C_PROJ_EMAIL2              	= "CUSTOMER_PROJECT_MANAGER_EMAIL2";
	const C_PROJ_DSG2              		= "CUSTOMER_PROJECT_MANAGER_DESIGNATED2";

	const C_SUNSYSTEMS_VERSION          = "CUSTOMER_SUNSYTEMS_VERSION";
	const C_MSSQL_VERSION              	= "CUSTOMER_MSSQL_VERSION";
	const C_QA_VERSION              	= "CUSTOMER_QA_VERSION";
	const C_WINSERVER_VERSION           = "CUSTOMER_WIN_SERVER_VERSION";
	const C_SUPPORTING_PARTNER          = "CUSTOMER_SUPPORT_PARTNER";

	const C_ADDRESS_1          			= "CUSTOMER_ADDRESS_1";
	const C_ADDRESS_2          			= "CUSTOMER_ADDRESS_2";
	const C_ADDRESS_3          			= "CUSTOMER_ADDRESS_3";
	const C_ADDRESS_4          			= "CUSTOMER_ADDRESS_4";
	const C_ADDRESS_5          			= "CUSTOMER_ADDRESS_5";

	const C_SOFTWARE_INFO     			= "CUSTOMER_SOFTWARE_INFO";
	const C_BILLING_CYCLE     			= "CUSTOMER_BILLING_CYCLE";
	const C_REMARKS     				= "CUSTOMER_REMARKS";
	
}

class CustomerTableDetail extends TableDetail {
	const C_ID                          = "identity|||";
	const C_STATUS                      = "int||NO|(0)";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_CODE                        = "nvarchar|50|NO|''";
	const C_WEB                         = "nvarchar|255|NO|''";
	const C_TELEPHONE                   = "nvarchar|255|NO|''";
	const C_FAX                         = "nvarchar|255|NO|''";
	const C_BILLING              		= "nvarchar|255|NO|''";
	const C_ONSITE              		= "nvarchar|255|NO|''";

	const C_LIC_NAME              		= "nvarchar|255|NO|''";
	const C_LIC_PHONE              		= "nvarchar|255|NO|''";
	const C_LIC_EMAIL              		= "nvarchar|255|NO|''";
	const C_LIC_DSG  					= "nvarchar|255|NO|''";

	const C_LIC_NAME2              		= "nvarchar|255|NO|''";
	const C_LIC_PHONE2              	= "nvarchar|255|NO|''";
	const C_LIC_EMAIL2              	= "nvarchar|255|NO|''";
	const C_LIC_DSG2  					= "nvarchar|255|NO|''";

	const C_FIN_NAME              		= "nvarchar|255|NO|''";
	const C_FIN_PHONE              		= "nvarchar|255|NO|''";
	const C_FIN_EMAIL              		= "nvarchar|255|NO|''";
	const C_FIN_DSG              		= "nvarchar|255|NO|''";

	const C_FIN_NAME2              		= "nvarchar|255|NO|''";
	const C_FIN_PHONE2              	= "nvarchar|255|NO|''";
	const C_FIN_EMAIL2              	= "nvarchar|255|NO|''";
	const C_FIN_DSG2              		= "nvarchar|255|NO|''";

	const C_IT_NAME              		= "nvarchar|255|NO|''";
	const C_IT_PHONE              		= "nvarchar|255|NO|''";
	const C_IT_EMAIL              		= "nvarchar|255|NO|''";
	const C_IT_DSG              		= "nvarchar|255|NO|''";

	const C_IT_NAME2              		= "nvarchar|255|NO|''";
	const C_IT_PHONE2              		= "nvarchar|255|NO|''";
	const C_IT_EMAIL2              		= "nvarchar|255|NO|''";
	const C_IT_DSG2              		= "nvarchar|255|NO|''";

	const C_PROJ_NAME              		= "nvarchar|255|NO|''";
	const C_PROJ_PHONE              	= "nvarchar|255|NO|''";
	const C_PROJ_EMAIL              	= "nvarchar|255|NO|''";
	const C_PROJ_DSG              		= "nvarchar|255|NO|''";

	const C_PROJ_NAME2              	= "nvarchar|255|NO|''";
	const C_PROJ_PHONE2              	= "nvarchar|255|NO|''";
	const C_PROJ_EMAIL2              	= "nvarchar|255|NO|''";
	const C_PROJ_DSG2              		= "nvarchar|255|NO|''";

	const C_SUNSYSTEMS_VERSION          = "nvarchar|255|NO|''";
	const C_MSSQL_VERSION              	= "nvarchar|255|NO|''";
	const C_QA_VERSION              	= "nvarchar|255|NO|''";
	const C_WINSERVER_VERSION           = "nvarchar|255|NO|''";
	const C_SUPPORTING_PARTNER          = "nvarchar|255|NO|''";

	const C_ADDRESS_1          			= "nvarchar|255|NO|''";
	const C_ADDRESS_2          			= "nvarchar|255|NO|''";
	const C_ADDRESS_3          			= "nvarchar|255|NO|''";
	const C_ADDRESS_4          			= "nvarchar|255|NO|''";
	const C_ADDRESS_5          			= "nvarchar|255|NO|''";

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