<?php
class CompanyProfileTable extends Table
{

	const C_TABLE                       = "COMPANY_PROFILE";
	const C_ID                          = "COMPANY_PROFILE_ID";
	const C_PK              			= "COMPANY_PROFILE_ID";
	const C_CODE              			= "COMPANY_PROFILE_CODE";
	const C_NAME                        = "COMPANY_PROFILE_NAME";
	const C_URL                         = "COMPANY_PROFILE_URL";
	const C_LOGO_PATH                   = "COMPANY_PROFILE_LOGO_PATH";
	const C_SIGNATURE_PATH              = "COMPANY_PROFILE_SIGNATURE_PATH";
	const C_STATUS                      = "COMPANY_PROFILE_STATUS";

	const C_MAIL_SERVER                 = "COMPANY_PROFILE_EMAIL_SERVER";
	const C_MAIL_PORT                   = "COMPANY_PROFILE_EMAIL_SERVER_PORT";
	const C_MAIL_SENDER                 = "COMPANY_PROFILE_EMAIL_SERVER_SENDER";
	const C_MAIL_PASSWORD               = "COMPANY_PROFILE_EMAIL_SERVER_PASSWORD";
	const C_MAIL_EA                     = "COMPANY_PROFILE_EMAIL_SERVER_EA";
	const C_MAIL_SSL                    = "COMPANY_PROFILE_EMAIL_SERVER_SSL";
	const C_MAIL_OAUTH                  = "COMPANY_PROFILE_EMAIL_SERVER_OAUTH";
	const C_MAIL_TENANT_ID              = "COMPANY_PROFILE_EMAIL_SERVER_TENANT_ID";
}

class CompanyProfileTableDetail extends TableDetail
{
	const C_ID                          = "identity||NO|";
	const C_CODE                        = "nvarchar|100|NO|''";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_URL                         = "nvarchar|255|NO|''";
	const C_LOGO_PATH                   = "nvarchar|255|NO|''";
	const C_SIGNATURE_PATH                   = "nvarchar|255|NO|''";
	const C_STATUS                      = "int||NO|(0)";

	const C_MAIL_SERVER                 = "nvarchar|100|NO|''";
	const C_MAIL_PORT                   = "nvarchar|100|NO|''";
	const C_MAIL_SENDER                 = "nvarchar|100|NO|''";
	const C_MAIL_PASSWORD               = "nvarchar|100|NO|''";
	const C_MAIL_EA                     = "int||NO|(0)";
	const C_MAIL_SSL                    = "int||NO|(0)";
	const C_MAIL_OAUTH                  = "nvarchar|50|NO|'NO'";
	const C_MAIL_TENANT_ID              = "nvarchar|100|NO|''";
}

class CompanyProfileTableDescription extends TableDescription
{
	const C_ID                          = "Company Profile ID";
	const C_CODE                        = "Company Profile Code";
	const C_NAME                        = "Company Profile Name";
	const C_URL                         = "Company Profile Url";
	const C_LOGO_PATH                   = "Company Profile Logo Path";
	const C_SIGNATURE_PATH              = "Company Profile Signature Path";
	const C_STATUS                      = "Company Profile Status";
	
	const C_MAIL_SERVER                 = "Mail Server";
	const C_MAIL_PORT                   = "Mail Port";
	const C_MAIL_SENDER                 = "Mail Sender";
	const C_MAIL_PASSWORD               = "Mail Password";
	const C_MAIL_EA                     = "Mail EA";
	const C_MAIL_SSL                    = "Mail SSL";
	const C_MAIL_OAUTH                  = "Mail OAuth";
	const C_MAIL_TENANT_ID              = "Mail Tenant ID";
}
