<?php
class ActivityEmailApprovalReminderTable  {
	
	const C_TABLE                       = "ACTIVITY_EMAIL_APPROVAL_REMINDER" ;
	const C_EMAIL_ID                    = "ACTIVITY_EMAIL_APPROVAL_REMINDER_ID";
	const C_ID                          = "ACTIVITY_ID"; //service report id
	const C_NOTIFICATION_ID             = "NOTIFICATION_CENTRE_ID"; //nitification centre id
	const C_EMAIL_APPROVAL_ID           = "ACTIVITY_EMAIL_APPROVAL_ID"; //email approval id
	const C_EMAIL_TO                 	= "ACTIVITY_EMAIL_APPROVAL_REMINDER_TO";
	const C_EMAIL_CC                 	= "ACTIVITY_EMAIL_APPROVAL_REMINDER_CC";

	const C_EMAIL_REMARKS               = "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS";
	const C_EMAIL_REMARKS1               = "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS1";
	const C_EMAIL_REMARKS2               = "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS2";
	const C_EMAIL_REMARKS3               = "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS3";

	const C_EMAIL_REMARKS_APPROVAL       = "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS_APPROVAL";

	const C_EMAIL_REMARKS_HTML       	= "ACTIVITY_EMAIL_APPROVAL_REMINDER_REMARKS_HTML";
	
	const C_REMINDER_NO              	= "ACTIVITY_EMAIL_APPROVAL_REMINDER_NUMBER";
	const C_LAST_SEND              		= "ACTIVITY_EMAIL_APPROVAL_REMINDER_LAST_SEND";
}

class ActivityEmailApprovalReminderTableDetail  {
	
	const C_EMAIL_ID                    = "identity|||";
	const C_ID                       	= "int||NO|(0)" ;
	const C_NOTIFICATION_ID             = "int||NO|(0)" ;
	const C_EMAIL_APPROVAL_ID           = "int||NO|(0)" ;
	const C_EMAIL_TO                 	= "nvarchar|255|NO|''";
	const C_EMAIL_CC               		= "nvarchar|255|NO|''";
	
	const C_EMAIL_REMARKS          		= "ntext||NO|''" ;
	const C_EMAIL_REMARKS1          		= "ntext||NO|''" ;
	const C_EMAIL_REMARKS2         		= "ntext||NO|''" ;
	const C_EMAIL_REMARKS3          		= "ntext||NO|''" ;
	const C_EMAIL_REMARKS_APPROVAL          		= "ntext||NO|''" ;
	const C_EMAIL_REMARKS_HTML          		= "ntext||NO|''" ;

	const C_REMINDER_NO                	= "int||NO|(0)" ;
	const C_LAST_SEND          			= "datetime||NO|getdate()";
}
?>