<?php
class CorporateGiftTable extends Table
{
	const C_TABLE                       = "CORPORATE_GIFT";
	const C_ID                          = "CORPORATE_GIFT_ID";
	const C_PK                 			= "CORPORATE_GIFT_ID";
	const C_NAME                        = "CORPORATE_GIFT_NAME";
	const C_STATUS                      = "CORPORATE_GIFT_STATUS";

	const C_EMAIL_SUBJECT               = "CORPORATE_GIFT_EMAIL_SUBJECT";
	const C_EMAIL_CONTENT               = "CORPORATE_GIFT_EMAIL_CONTENT";
	const C_EMAIL_BUTTON                = "CORPORATE_GIFT_EMAIL_BUTTON_CONTENT";
	const C_EMAIL_THANKS  	            = "CORPORATE_GIFT_EMAIL_THANKS_CONTENT";

	const C_CUTOFF_DATE 	 	        = "CORPORATE_GIFT_CUTOFF_DATE";

	const C_DELIVERY_DATE_FROM          = "CORPORATE_GIFT_DELIVERY_DATE_FROM";
	const C_DELIVERY_DATE_TO            = "CORPORATE_GIFT_DELIVERY_DATE_TO";
}

class CorporateGiftTableDetail extends TableDetail
{
	const C_ID                          = "identity||NO|";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_STATUS                      = "int||NO|(0)";

	const C_EMAIL_SUBJECT               = "nvarchar|255|NO|''";
	const C_EMAIL_CONTENT               = "ntext||NO|''";
	const C_EMAIL_BUTTON                = "nvarchar|255|NO|''";
	const C_EMAIL_THANKS  	            = "ntext||NO|''";

	const C_CUTOFF_DATE 	 	        = "datetime||NO|getdate()";

	const C_DELIVERY_DATE_FROM          = "datetime||NO|getdate()";
	const C_DELIVERY_DATE_TO            = "datetime||NO|getdate()";
}

class CorporateGiftTableDescription extends TableDescription
{
    const C_ID                          = "ID";
	const C_NAME                        = "Name";
	const C_STATUS                      = "Status";

	const C_EMAIL_SUBJECT               = "Email Subject";
	const C_EMAIL_CONTENT               = "Email Content";
	const C_EMAIL_BUTTON                = "Email Button Content";
	const C_EMAIL_THANKS  	            = "Email Thanks Content";

	const C_CUTOFF_DATE 	 	        = "Cutoff Date";

	const C_DELIVERY_DATE_FROM          = "Delivery Date From";
	const C_DELIVERY_DATE_TO            = "Delivery Date To";
}
