<?php
class CampaignTable extends Table
{
	const C_TABLE                       = "CAMPAIGN";
	const C_ID                          = "CAMPAIGN_ID";
	const C_PK                 			= "CAMPAIGN_ID";
	const C_NAME                        = "CAMPAIGN_NAME";
	const C_STATUS                      = "CAMPAIGN_STATUS";

	const C_EMAIL_SUBJECT               = "CAMPAIGN_EMAIL_SUBJECT";
	const C_EMAIL_CONTENT               = "CAMPAIGN_EMAIL_CONTENT";
	const C_EMAIL_THANKS  	            = "CAMPAIGN_EMAIL_THANKS_CONTENT";

	const C_DELIVERY_DATE_FROM          = "CAMPAIGN_DELIVERY_DATE_FROM";
	const C_DELIVERY_DATE_TO            = "CAMPAIGN_DELIVERY_DATE_TO";
}

class CampaignTableDetail 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_THANKS  	            = "ntext||NO|''";

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

class CampaignTableDescription 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_THANKS  	            = "Email Thanks Content";

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