<?php
class JobCentreTable extends Table {
	const C_TABLE                       = "JOB_CENTRE" ;
	const C_ID                          = "JOB_CENTRE_ID";
	const C_JOB_QUOTATION_ID            = "JOB_QUOTATION_ID";
	const C_STATUS                      = "JOB_CENTRE_STATUS";
	const C_CUST_ID                     = "CUSTOMER_ID";
	const C_CUST_LOC_ID                 = "CUSTOMER_LOCATION_ID";
	const C_CUST_CONTACT_ID             = "CUSTOMER_CONTACT_ID";
	const C_JOB_NUMBER                  = "JOB_NUMBER";
	const C_JOB_NAME                  	= "JOB_NAME";
	const C_JOB_CONFIRM_DATE            = "JOB_CONFIRM_DATE";
	const C_JOB_START_DATE              = "JOB_START_DATE";
	const C_JOB_END_DATE              	= "JOB_END_DATE";
	const C_JOB_TYPE                    = "JOB_TYPE";
	const C_PRODUCT_TYPE                = "PRODUCT_TYPE";
	const C_TOTAL_MANDAYS              	= "TOTAL_MANDAYS";
	const C_GRN_ID                 		= "JOB_CENTRE_GRN_ID";
	const C_CONVERT                 	= "JOB_CENTRE_CONVERT";
}

class JobCentreTableDetail extends TableDetail {
	const C_ID                          = "identity|||";
	const C_JOB_QUOTATION_ID            = "int||NO|(0)";
	const C_STATUS                      = "int||NO|(0)";
	const C_CUST_ID                     = "int||NO|(0)";
	const C_CUST_LOC_ID                 = "int||NO|(0)";
	const C_CUST_CONTACT_ID             = "int||NO|(0)";
	const C_JOB_NUMBER                  = "nvarchar|50|NO|''";
	const C_JOB_NAME                  	= "nvarchar|255|NO|''";
	const C_JOB_CONFIRM_DATE            = "date||NO|getdate()";
	const C_JOB_START_DATE              = "date||NO|getdate()";
	const C_JOB_END_DATE              	= "date||NO|getdate()";
	const C_JOB_TYPE                    = "int||NO|(0)";
	const C_PRODUCT_TYPE                = "int||NO|(0)";
	const C_TOTAL_MANDAYS              	= "decimal|18,4|NO|(0)";
	const C_GRN_ID                 		= "int||NO|(0)";
	const C_CONVERT                 	= "int||NO|(0)";
}
?>