<?php
class JobAssignmentDetailTable extends Table {
	const C_TABLE                       = "JOB_ASSIGNMENT_DETAIL" ;
	//const C_PK               			= "JOB_ASSIGNMENT_DETAIL_ID";
	const C_DETAIL_ID               	= "JOB_ASSIGNMENT_DETAIL_ID";
	const C_ID                          = "JOB_CENTER_ID";
	const C_PHASE                       = "JOB_ASSIGNMENT_PHASE";
	const C_TASK                        = "JOB_ASSIGNMENT_TASK";
	const C_SCOPE                     	= "JOB_ASSIGNMENT_SCOPE";
	const C_AGENT                     	= "JOB_ASSIGNMENT_AGENT";
	const C_DATE                     	= "JOB_ASSIGNMENT_DATE";
const C_DATE_END                     	= "JOB_ASSIGNMENT_DATE_END";
	const C_TIME						= "JOB_ASSIGNMENT_DETAIL_TIME";
	const C_HOURS				    	= "JOB_ASSIGNMENT_DETAIL_HOURS";
	const C_STATUS				    	= "JOB_ASSIGNMENT_DETAIL_STATUS";
	const C_AGENT_STATUS				= "JOB_ASSIGNMENT_DETAIL_AGENT_STATUS";
	
}

class JobAssignmentDetailTableDetail 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				    	= "int||YES|(0)" ;
	const C_STATUS                     	= "int||NO|(0)" ;
	const C_AGENT_STATUS                = "int||NO|(0)" ;
}
?>