<?php
class JobServiceAttendeeTable extends Table {
	const C_TABLE                       = "JOB_SERVICE_ATTENDEE" ;
	const C_ID                  		= "JOB_SERVICE_ATTENDEE_ID";
	const C_DETAIL_ID               	= "JOB_ASSIGNMENT_DETAIL_ID";
	const C_START_DATE                 	= "JOB_SERVICE_ATTENDEE_START_DATE";
	const C_END_DATE                 	= "JOB_SERVICE_ATTENDEE_END_DATE";
	const C_SERVICE_DESC                = "JOB_SERVICE_ATTENDEE_DESCRIPTION";
	const C_SERVICE_ADD_DESC     		= "JOB_SERVICE_ATTENDEE_ADDITIONAL_DESC";
	const C_SERVICE_SIGNATURE		    = "JOB_SERVICE_ATTENDEE_SIGNATURE";
	const C_SUBMIT_DATE				    = "JOB_SERVICE_ATTENDEE_SUBMIT_DATE";

	const C_SEND_EMAIL                 	= "JOB_SERVICE_ATTENDEE_SEND_EMAIL";
	const C_INCLUDE_ADDITIONAL_INFO     = "JOB_SERVICE_ATTENDEE_INCLUDE_ADDITIONAL_INFO";
	const C_INCLUDE_CHECKLIST    		= "JOB_SERVICE_ATTENDEE_INCLUDE_CHECKLIST";
	const C_FOOTER_INFO_ID		        = "JOB_SERVICE_ATTENDEE_FOOTER_INFO_ID";
	const C_FOOTER_INFO_DESC			= "JOB_SERVICE_ATTENDEE_FOOTER_INFO_DESC";
	const C_ADDITIONAL_EMAIL		    = "JOB_SERVICE_ATTENDEE_ADDITIONAL_EMAIL";
	
	const C_SIGN_NAME		    		= "JOB_SERVICE_ATTENDEE_SIGN_NAME";
	
	const C_BILLABLE		    		= "JOB_SERVICE_ATTENDEE_BILLABLE";
	const C_PLUS_HOURS	    			= "JOB_SERVICE_ATTENDEE_PLUS_HOURS";
	const C_ADDITIONAL_HOURS	    	= "JOB_SERVICE_ATTENDEE_ADDITIONAL_HOURS";
	const C_ADDITIONAL_DATE	    		= "JOB_SERVICE_ATTENDEE_ADDITIONAL_DATE";
	const C_OVERRIDE_HOURS	    		= "JOB_SERVICE_ATTENDEE_OVERRIDE_HOURS";
}

class JobServiceAttendeeTableDetail extends TableDetail {
	const C_ID                 			= "identity|||";
	const C_DETAIL_ID              		= "int||NO|(0)";
	const C_START_DATE                  = "datetime||NO|getdate()";
	const C_END_DATE                    = "datetime||NO|getdate()";
	const C_SERVICE_DESC                = "ntext||NO|''";
	const C_SERVICE_ADD_DESC     		= "ntext||NO|''";
	const C_SERVICE_SIGNATURE           = "text||YES|''";
	const C_SUBMIT_DATE                 = "datetime||NO|getdate()";
	
	const C_SEND_EMAIL                 	= "int||NO|(0)";
	const C_INCLUDE_ADDITIONAL_INFO     = "int||NO|(0)";
	const C_INCLUDE_CHECKLIST    		= "int||NO|(0)";
	const C_FOOTER_INFO_ID		        = "int||NO|(0)";
	const C_FOOTER_INFO_DESC			= "nvarchar|255|NO|''";
	const C_ADDITIONAL_EMAIL		    = "nvarchar|255|NO|''";
	
	const C_SIGN_NAME		    		= "nvarchar|50|NO|''";
	
	const C_BILLABLE		       	 	= "bit||NO|(0)";
	const C_PLUS_HOURS    				= "bit||NO|(0)";
	const C_ADDITIONAL_HOURS    		= "int||NO|(0)";
	const C_ADDITIONAL_DATE             = "datetime||NO|getdate()";
	const C_OVERRIDE_HOURS    			= "decimal|18,4|NO|(0.00)";
}
?>