<?php
class CustomerSoftwareTable extends Table
{
    const C_TABLE           = "CUSTOMER_SOFTWARE";
    const C_ID              = "CUSTOMER_ID";
    const C_PK              = "CUSTOMER_SOFTWARE_ID";
    const C_CUS_SOFTWARE_ID = "CUSTOMER_SOFTWARE_ID";
    const C_SOFTWARE        = "SOFTWARE_ID";
    const C_VERSION         = "CUSTOMER_SOFTWARE_VERSION";
    const C_TYPE            = "CUSTOMER_SOFTWARE_TYPE";
    const C_USER            = "CUSTOMER_SOFTWARE_USER";
    const C_LIVE_DATE       = "CUSTOMER_SOFTWARE_LIVE_DATE";
    const C_RENEW_DATE      = "CUSTOMER_SOFTWARE_RENEW_DATE";
}

class CustomerSoftwareTableDetail extends TableDetail
{
    const C_CUS_SOFTWARE_ID = "identity||NO|";
    const C_ID              = "int||NO|(0)";
    const C_SOFTWARE        = "int||NO|(0)";
    const C_VERSION         = "nvarchar|225|NO|''";
    const C_TYPE            = "int||NO|(0)";
    const C_USER            = "int||NO|(0)";
    const C_LIVE_DATE       = "datetime||NO|getdate()";
    const C_RENEW_DATE      = "datetime||NO|getdate()";
}

class CustomerSoftwareTableDescription extends TableDescription
{
    const C_CUS_SOFTWARE_ID = "Software ID";
    const C_ID              = "CUstomer ID";
    const C_SOFTWARE        = "Software";
    const C_VERSION         = "Version";
    const C_TYPE            = "Type";
    const C_USER            = "User";
    const C_LIVE_DATE       = "Live Date";
    const C_RENEW_DATE      = "Renew DAte";
}