<?php
class JobCentreTaskTable extends Table {
	const C_TABLE                       = "JOB_CENTRE_TASK_DETAIL" ;
	//const C_PK               			= "JOB_TASK_DETAIL_ID";
	const C_DETAIL_ID               	= "JOB_CENTRE_TASK_DETAIL_ID";
	const C_ID                          = "JOB_CENTRE_ID";
	const C_PHASE                       = "JOB_CENTRE_TASK_PHASE";
	const C_TASK                        = "JOB_CENTRE_TASK_TASK";
	const C_SCOPE                     	= "JOB_CENTRE_TASK_SCOPE";
	const C_AGENT                     	= "JOB_CENTRE_TASK_AGENT";
	const C_DATE                     	= "JOB_CENTRE_TASK_DATE";
	const C_DATE_END                    = "JOB_CENTRE_TASK_DATE_END";
	const C_TIME						= "JOB_CENTRE_TASK_DETAIL_TIME";
	const C_HOURS				    	= "JOB_CENTRE_TASK_DETAIL_HOURS";
	const C_REMARKS				    	= "JOB_CENTRE_TASK_DETAIL_REMARKS";
	const C_STATUS				    	= "JOB_CENTRE_TASK_STATUS";
	const C_VENUE                 		= "JOB_CENTRE_TASK_DETAIL_VENUE";
	const C_CLOSE_USER_ID          		= "JOB_CENTRE_TASK_DETAIL_CLOSE_USER_ID";
	const C_CLOSE_DATE                  = "JOB_CENTRE_TASK_DETAIL_CLOSE_DATE";
	
}

class JobCentreTaskTableDetail extends TableDetail {

	const C_DETAIL_ID               	= "int||NO|(0)" ;
	const C_ID                          = "int||NO|(0)" ;
	const C_PHASE                       = "nvarchar|50|NO|''";
	const C_TASK                        = "nvarchar|255|NO|''";
	const C_SCOPE                     	= "text||NO|''";
	const C_AGENT                     	= "int||NO|(0)" ;
	const C_DATE                     	= "datetime||NO|getdate()";
	const C_DATE_END                    = "datetime||NO|getdate()";
	const C_TIME						= "nvarchar|20|YES|''";
	const C_HOURS				    	= "decimal|18,4|NO|(0)";
	const C_REMARKS                     = "text||NO|''";
	const C_STATUS                     	= "int||NO|(0)" ;
	const C_VENUE                     	= "int||NO|(0)" ;
	const C_CLOSE_USER_ID          		= "int||NO|(0)" ;
	const C_CLOSE_DATE                  = "datetime||NO|getdate()";
}
?>