<?php
class ProspectContactTable extends Table
{
    const C_TABLE               = "PROSPECT_CONTACT";
    const C_PK                  = "PROSPECT_CONTACT_ID";
    const C_CONTACT_ID          = "PROSPECT_CONTACT_ID";
    const C_ID                  = "PROSPECT_ID";
    const C_NAME                = "PROSPECT_CONTACT_NAME";
    const C_EMAIL               = "PROSPECT_CONTACT_EMAIL_ADDRESS";
    const C_TELEPHONE           = "PROSPECT_CONTACT_TELEPHONE";
    const C_MOBILE              = "PROSPECT_CONTACT_MOBILE";
    const C_DESIGNATION         = "PROSPECT_CONTACT_DESIGNATION";
    const C_REPORT_TO           = "PROSPECT_CONTACT_REPORT_TO";
    const C_DEPT                = "PROSPECT_CONTACT_DEPARTMENT";
    const C_ACTIVE              = "PROSPECT_CONTACT_STATUS_ACTIVE";

    //Telemarketing
    const C_PERSON_CONTACT      = "PROSPECT_CONTACT_PERSON_CONTACT_ID";
    const C_SEQUENCE            = "PROSPECT_CONTACT_SEQUENCE";
	const C_EXPORT_STATUS	    = "PROSPECT_CONTACT_EXPORT_STATUS";

	const C_NEXT_ACTION			= "PROSPECT_CONTACT_NEXT_ACTION";
	const C_ACTION_STATUS		= "PROSPECT_CONTACT_ACTION_STATUS";
	const C_ACTION_LOCATION		= "PROSPECT_CONTACT_ACTION_LOCATION";
	const C_ACTION_DATE			= "PROSPECT_CONTACT_ACTION_DATE";
	const C_BEST_TIME			= "PROSPECT_CONTACT_BEST_TIME";
	const C_LUNCH_TIME			= "PROSPECT_CONTACT_LUNCH_TIME";
	const C_ASSIGN_TO			= "PROSPECT_CONTACT_ASSIGN_TO";

    const C_INSERT_TO_CALENDAR  = "PROSPECT_CONTACT_INSERT_TO_CALENDAR";
    const C_REMINDER_DAYS       = "PROSPECT_CONTACT_REMINDER_DAYS";
}

class ProspectContactTableDetail extends TableDetail
{
    const C_CONTACT_ID          = "identity||NO|";
    const C_ID                  = "int||NO|(0)";
    const C_NAME                = "nvarchar|125|NO|''";
    const C_EMAIL               = "nvarchar|125|NO|''";
    const C_TELEPHONE           = "nvarchar|20|NO|''";
    const C_MOBILE              = "nvarchar|20|NO|''";
    const C_DESIGNATION         = "nvarchar|125|NO|''";
    const C_REPORT_TO           = "nvarchar|125|NO|''";
    const C_DEPT                = "nvarchar|125|NO|''";
    const C_ACTIVE              = "int||NO|(0)";

    const C_PERSON_CONTACT      = "int||NO|(0)";
    const C_SEQUENCE            = "int||NO|(0)";
	const C_NEXT_ACTION			= "ntext||NO|''";
    const C_ACTION_STATUS		= "int||NO|(0)";
	const C_ACTION_LOCATION		= "nvarchar|225||''";
	const C_ACTION_DATE			= "datetime||NO|getdate()";
	const C_BEST_TIME			= "nchar|5|NO|''";
	const C_LUNCH_TIME			= "nchar|5|NO|''";
	const C_ASSIGN_TO			= "int||NO|(0)";
	const C_EXPORT_STATUS		= "int||NO|(0)";
    
    const C_INSERT_TO_CALENDAR  = "int||NO|(0)";
    const C_REMINDER_DAYS       = "int||NO|(0)";
}
