<?php
class SuspectContactTable extends Table
{

	const C_TABLE                       = "SUSPECT_CONTACT";
	const C_CONTACT_ID                  = "SUSPECT_CONTACT_ID";
	const C_PK                 			= "SUSPECT_CONTACT_ID";
	const C_ID 			                = "SUSPECT_ID";
	const C_SEQUENCE                    = "SUSPECT_CONTACT_SEQUENCE";
	const C_DESIGNATION                 = "SUSPECT_CONTACT_DESIGNATION";
	const C_FULL_NAME                   = "SUSPECT_CONTACT_FULL_NAME";
	const C_PREFER_NAME                 = "SUSPECT_CONTACT_PREFER_NAME";
	const C_PHONE                       = "SUSPECT_CONTACT_PHONE";
	const C_EMAIL     		            = "SUSPECT_CONTACT_EMAIL";
	const C_REPORT_TO 		            = "SUSPECT_CONTACT_REPORT_TO";
	const C_CONVERSATION	            = "SUSPECT_CONTACT_CONVERSATION";
	const C_NEXT_ACTION		            = "SUSPECT_CONTACT_NEXT_ACTION";
	const C_ACTION_DATE                 = "SUSPECT_CONTACT_ACTION_DATE";
	const C_BEST_TIME		            = "SUSPECT_CONTACT_BEST_TIME";
	const C_ASSIGN_TO                   = "SUSPECT_CONTACT_ASSIGN_TO";
	const C_PREFER_PROMOTION            = "SUSPECT_CONTACT_PREFER_PROMOTION";
	const C_PREFER_WHATSAPP             = "SUSPECT_CONTACT_PREFER_WHATSAPP";
	const C_PREFER_TELEGRAM             = "SUSPECT_CONTACT_PREFER_TELEGRAM";
	const C_PREFER_EMAIL              	= "SUSPECT_CONTACT_PREFER_EMAIL";
	const C_PREFER_TELEPHONE            = "SUSPECT_CONTACT_PREFER_TELEPHONE";
}

class SuspectContactTableDetail extends TableDetail
{
	const C_CONTACT_ID                  = "identity||NO|";
	const C_ID                  		= "int||NO|(0)";
	const C_SEQUENCE                    = "int||NO|(0)";
	const C_DESIGNATION                 = "nvarchar|255|NO|''";
	const C_FULL_NAME                   = "nvarchar|255|NO|''";
	const C_PREFER_NAME                 = "nvarchar|255|NO|''";
	const C_PHONE                       = "nvarchar|255|NO|''";
	const C_EMAIL     		            = "nvarchar|255|NO|''";
	const C_REPORT_TO 		            = "nvarchar|255|NO|''";
	const C_CONVERSATION 		        = "ntext||NO|''";
	const C_NEXT_ACTION 		        = "ntext||NO|''";
	const C_ACTION_DATE                 = "datetime||NO|getdate()";
	const C_BEST_TIME		            = "nchar|5|NO|''";
	const C_ASSIGN_TO                   = "int||NO|(0)";
	const C_PREFER_PROMOTION            = "int||NO|(0)";
	const C_PREFER_WHATSAPP             = "int||NO|(0)";
	const C_PREFER_TELEGRAM             = "int||NO|(0)";
	const C_PREFER_EMAIL              	= "int||NO|(0)";
	const C_PREFER_TELEPHONE            = "int||NO|(0)";
}