<?php
class CorporateGiftHistoryTable extends Table
{
	const C_TABLE                       = "CORPORATE_GIFT_HISTORY";
	const C_ID                          = "CORPORATE_GIFT_ID";
	const C_CUSTOMER_ID                 = "CORPORATE_GIFT_HISTORY_CUSTOMER_ID";
	const C_CONTACT_ID                  = "CORPORATE_GIFT_HISTORY_CONTACT_ID";
	const C_DELIVERY_DATE               = "CORPORATE_GIFT_HISTORY_DELIVERY_DATE";
	const C_DELIVERY_TIME               = "CORPORATE_GIFT_HISTORY_DELIVERY_TIME";
	const C_RESPONSE_TIME               = "CORPORATE_GIFT_HISTORY_RESPONSE_TIME";
	const C_GIFT_MASTER_ID              = "CORPORATE_GIFT_HISTORY_GIFT_MASTER_ID";
	const C_CHOSEN_ITEM_ID              = "CORPORATE_GIFT_HISTORY_CHOSEN_ITEM_ID";
	const C_REMARKS 		            = "CORPORATE_GIFT_HISTORY_REMARKS";
	const C_GIFT_AMOUNT                 = "CORPORATE_GIFT_HISTORY_GIFT_AMOUNT";
}

class CorporateGiftHistoryTableDetail extends TableDetail
{
	const C_ID                          = "int||NO|(0)";
	const C_CUSTOMER_ID                 = "int||NO|(0)";
	const C_CONTACT_ID                 	= "int||NO|(0)";
	const C_DELIVERY_DATE               = "date||NO|''";
	const C_DELIVERY_TIME               = "nvarchar|255|NO|''";
	const C_RESPONSE_TIME               = "datetime||NO|getdate()";
	const C_GIFT_MASTER_ID              = "int||NO|(0)";
	const C_CHOSEN_ITEM_ID              = "int||NO|(0)";
	const C_REMARKS              		= "ntext||NO|''";
	const C_GIFT_AMOUNT                 = "int||NO|(0)";
}

class CorporateGiftHistoryTableDescription extends TableDescription
{
	const C_ID                          = "ID";
	const C_CUSTOMER_ID                 = "Customer ID";
	const C_CONTACT_ID                 	= "Contact ID";
	const C_DELIVERY_DATE               = "Delivery Date";
	const C_DELIVERY_TIME               = "Delivery Time";
	const C_RESPONSE_TIME               = "Response Time";
	const C_GIFT_MASTER_ID              = "Gift ID";
	const C_CHOSEN_ITEM_ID              = "Chosen Item";
	const C_REMARKS              		= "Remarks";
	const C_GIFT_AMOUNT                 = "Gift Amount";
}
