<?php
class SuspectTable extends Table
{

	const C_TABLE                       = "SUSPECT";
	const C_ID                          = "SUSPECT_ID";
	const C_PK                 			= "SUSPECT_ID";
	const C_NAME                        = "SUSPECT_NAME";
	const C_TELEPHONE                   = "SUSPECT_TELEPHONE";
	const C_WEBSITE                     = "SUSPECT_WEBSITE";
	const C_BUSINESS_DESC               = "SUSPECT_BUSINESS_DESC";
	const C_ACC_SOFTWARE                = "SUSPECT_ACCOUNTING_SOFTWARE";
	const C_ACC_SOFTWARE_USER           = "SUSPECT_ACCOUNTING_SOFTWARE_USER";
	const C_OTHER_SOFTWARE              = "SUSPECT_OTHER_SOFTWARE";
	const C_OTHER_SOFTWARE_USER         = "SUSPECT_OTHER_SOFTWARE_USER";
	const C_INDUSTRY			        = "SUSPECT_INDUSTRY";
	const C_BUSINESS_SECTOR		        = "SUSPECT_BUSINESS_SECTOR";
	const C_TOTAL_EMPLOYEE		        = "SUSPECT_TOTAL_EMPLOYEE";

}

class SuspectTableDetail extends TableDetail
{
	const C_ID                          = "identity||NO|";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_WEBSITE                     = "nvarchar|255|NO|''";
	const C_TELEPHONE                   = "nvarchar|255|NO|''";
	const C_BUSINESS_DESC               = "nvarchar|255|NO|''";
	const C_ACC_SOFTWARE                = "nvarchar|255|NO|''";
	const C_ACC_SOFTWARE_USER           = "int||NO|(0)";
	const C_OTHER_SOFTWARE              = "nvarchar|255|NO|''";
	const C_OTHER_SOFTWARE_USER         = "int||NO|(0)";
	const C_INDUSTRY			        = "nvarchar|255|NO|''";
	const C_BUSINESS_SECTOR		        = "nvarchar|255|NO|''";
	const C_TOTAL_EMPLOYEE		        = "int||NO|(0)";
}
