<?php
class ActivityHeaderTable extends Table {
	
	const C_TABLE                       = "ACTIVITY_HEADER" ;
	const C_ID                          = "ACTIVITY_ID";
	const C_JOB_ID                   	= "ACTIVITY_JOB_ID";
	const C_CODE                       	= "ACTIVITY_SERVICE_NO" ;
	const C_TITLE                 		= "ACTIVITY_TITLE";
	const C_DATE                        = "ACTIVITY_DATE";
	const C_DESC                 		= "ACTIVITY_DESC";
	const C_TYPE                  		= "ACTIVITY_TYPE" ;
	const C_BILL                        = "ACTIVITY_BILL_TYPE";
	const C_SITE                 		= "ACTIVITY_SITE_TYPE";
	const C_PROJECT_STATUS             	= "ACTIVITY_PROJECT_STATUS" ;
	const C_STATUS              		= "ACTIVITY_STATUS" ;
	const C_DEDUCT              		= "ACTIVITY_DEDUCT" ;
	const C_USER_ID              		= "ACTIVITY_USER" ;
	const C_CONTACT_ID              	= "CUSTOMER_CONTACT_ID" ;
	const C_PROJECT_ID                  = "PROJECT_ID" ;
	const C_CUSTOMER_ID                 = "CUSTOMER_ID";
	const C_LOCATION_ID        			= "LOCATION_ID";
	const C_TT_TOTAL        			= "TIME_TRACKER_TOTAL";
	const C_TT_TOTAL_OVERRIDE        	= "TIME_TRACKER_TOTAL_OVERRIDE";
	const C_ET_TOTAL        			= "EXPENSE_TRACKER_TOTAL";
	const C_SIGNED                      = "ACTIVITY_SIGNED";
	const C_AUTOMATED_SIGNED            = "ACTIVITY_AUTOMATED__SIGNED";
	const C_REMARKS                     = "ACTIVITY_REMARKS";

	const C_SIGNED_REMARKS                     = "ACTIVITY_SIGNED_REMARKS";
	const C_SIGNED_DATE                      = "ACTIVITY_SIGNED_DATE";
}

class ActivityHeaderTableDetail extends TableDetail {

	const C_ID                          = "int||NO|(0)" ;
	const C_JOB_ID                   	= "int||NO|(0)" ;
	const C_CODE                       	= "nvarchar|50|NO|''";
	const C_TITLE                 		= "nvarchar|100|NO|''";
	const C_DATE                        = "datetime||NO|getdate()";
	const C_DESC                 		= "ntext||NO|''" ;
	const C_TYPE                  		= "int||NO|(0)" ;
	const C_BILL                        = "int||NO|(0)" ;
	const C_SITE                 		= "int||NO|(0)" ;
	const C_PROJECT_STATUS             	= "int||NO|(0)" ;
	const C_STATUS              		= "int||NO|(0)" ;
	const C_DEDUCT              		= "int||NO|(0)" ;
	const C_USER_ID              		= "int||NO|(0)" ;
	const C_CONTACT_ID              	= "int||NO|(0)" ;
	const C_PROJECT_ID                  = "int||NO|(0)" ;
	const C_CUSTOMER_ID                 = "int||NO|(0)" ;
	const C_LOCATION_ID        			= "int||NO|(0)" ;
	const C_TT_TOTAL        			= "decimal|18,6|NO|(0)";
	const C_TT_TOTAL_OVERRIDE        	= "decimal|18,6|NO|(0)";
	const C_ET_TOTAL        			= "decimal|18,6|NO|(0)";
	const C_SIGNED                      = "int||NO|(0)" ;
	const C_AUTOMATED_SIGNED            = "int||NO|(0)" ;
	const C_REMARKS                     = "ntext||NO|''";

	const C_SIGNED_REMARKS                      = "nvarchar|255|NO|''";
	const C_SIGNED_DATE                       = "datetime||YES|NULL";
}
?>