<?php
class JobCentreListEquipmentTable {
	const C_TABLE                       = "JOB_CENTRE_LIST_EQUIPMENT" ;
	const C_EQUIPMENT_ID                = "JOB_CENTRE_LIST_EQUIPMENT_ID";
	const C_ID                      	= "JOB_CENTRE_ID";
	const C_PRODUCT                     = "PRODUCT_ID";
	const C_BRAND_ID                    = "BRAND_ID";
	const C_MODEL_ID                    = "MODEL_ID";
	const C_SERIAL_NUMBER               = "SERIAL_NUMBER";
	const C_WARRANTY               		= "WARRANTY_DATE";
	const C_WARRANTY_END                = "WARRANTY_DATE_END";
	const C_EXT_WARRANTY          		= "EXTENDED_WARRANTY_START_DATE";
	const C_EXT_WARRANTY_END            = "EXTENDED_WARRANTY_END_DATE";
}

class JobCentreListEquipmentTableDetail  {
	const C_EQUIPMENT_ID                = "identity|||";
	const C_ID                      	= "int||NO|(0)";
	const C_PRODUCT                     = "int||NO|(0)";
	const C_BRAND_ID                    = "int||NO|(0)";
	const C_MODEL_ID                    = "int||NO|(0)";
	const C_SERIAL_NUMBER               = "nvarchar|50|NO|''";
	const C_WARRANTY               		= "datetime||NO|getdate()";
	const C_WARRANTY_END                = "datetime||NO|getdate()";
	const C_EXT_WARRANTY          		= "datetime||YES|NULL";
	const C_EXT_WARRANTY_END            = "datetime||YES|NULL";
}
?>