<?php
class CustomerLocationAssetTable  {
	const C_TABLE                       = "CUSTOMER_LOCATION_ASSET" ;
	const C_ID                          = "CUSTOMER_LOCATION_ID";
	const C_CUST_LOC_ID                 = "CUSTOMER_LOCATION_ASSET_ID";
	const C_PRODUCT                     = "CUSTOMER_LOCATION_ASSET_PRODUCT_ID";
	const C_BRAND                       = "CUSTOMER_LOCATION_ASSET_BRAND_ID";
	const C_MODEL                       = "CUSTOMER_LOCATION_ASSET_MODEL_ID";
	const C_SERIAL_NUMBER               = "CUSTOMER_LOCATION_ASSET_SERIAL_NUMBER";
	const C_WARRANTY_START              = "CUSTOMER_LOCATION_ASSET_WARRANTY_START_DATE";
	const C_WARRANTY_END                = "CUSTOMER_LOCATION_ASSET_WARRANTY_END_DATE";
	const C_EXT_WARRANTY_START          = "CUSTOMER_LOCATION_ASSET_EXTENDED_WARRANTY_START_DATE";
	const C_EXT_WARRANTY_END            = "CUSTOMER_LOCATION_ASSET_EXTENDED_WARRANTY_END_DATE";
	const C_CYCLE              			= "CUSTOMER_LOCATION_ASSET_LIVE_CYCLE";
	const C_SCHEDULE_DATE               = "CUSTOMER_LOCATION_ASSET_SCHEDULE_DATE";
}

class CustomerLocationAssetTableDetail  {
	const C_CUST_LOC_ID                 = "identity|||";
	const C_ID                          = "int||NO|(0)";
	const C_PRODUCT                     = "int||NO|(0)";
	const C_BRAND                       = "int||NO|(0)";
	const C_MODEL                       = "int||NO|(0)";
	const C_SERIAL_NUMBER               = "nvarchar|100|NO|''";
	const C_WARRANTY_START              = "datetime||NO|getdate()";
	const C_WARRANTY_END                = "datetime||NO|getdate()";
	const C_EXT_WARRANTY_START          = "datetime||YES|NULL";
	const C_EXT_WARRANTY_END            = "datetime||YES|NULL";
	const C_CYCLE              			= "int||YES|(0)";
	const C_SCHEDULE_DATE               = "int||YES|(0)";
}
?>