<?php
class CustomerBranchTable extends Table
{
    const C_TABLE           = "CUSTOMER_BRANCH";
    const C_ID              = "CUSTOMER_ID";
    const C_PK              = "CUSTOMER_BRANCH_ID";
    const C_BRANCH_ID       = "CUSTOMER_BRANCH_ID";
    const C_CODE            = "CUSTOMER_BRANCH_CODE";
    const C_NAME            = "CUSTOMER_BRANCH_NAME";
    const C_TYPE            = "CUSTOMER_BRANCH_TYPE";
    const C_ADD             = "CUSTOMER_BRANCH_ADDRESS_1";
    
    const C_WEB             = "CUSTOMER_BRANCH_WEB";
    const C_TELEPHONE       = "CUSTOMER_BRANCH_TELEPHONE";
    const C_FAX             = "CUSTOMER_BRANCH_FAX";
    const C_EMAIL           = "CUSTOMER_BRANCH_EMAIL";

    const C_CONTACT         = "CUSTOMER_BRANCH_CONTACT";
}

class CustomerBranchTableDetail extends TableDetail
{
    const C_BRANCH_ID       = "identity||NO|";
    const C_ID              = "int||NO|(0)";
    const C_CODE            = "nvarchar|225|NO|''";
    const C_NAME            = "nvarchar|225|NO|''";
    const C_TYPE            = "int||NO|(0)";
    const C_ADD             = "nvarchar|4000|NO|''";

    const C_WEB             = "nvarchar|255|NO|''";
    const C_TELEPHONE       = "nvarchar|255|NO|''";
    const C_FAX             = "nvarchar|255|NO|''";
    const C_EMAIL           = "nvarchar|255|NO|''";
    
    const C_CONTACT         = "int||NO|(0)";
}

class CustomerBranchTableDescription extends TableDescription
{
    const C_ID              = "Customer ID";
    const C_BRANCH_ID       = "Branch ID";
    const C_NAME            = "Name";
    const C_TYPE            = "Type";
    const C_ADD             = "Address 1";
    
    const C_WEB             = "Website";
    const C_TELEPHONE       = "Telephone";
    const C_FAX             = "Fax";
    const C_EMAIL           = "Email";

    const C_CONTACT         = "Contact";
}