{ // automagically generated - DO NOT EDIT !
  EOModelVersion   = 31;
  adaptorClassName = "PostgreSQLAdaptor";
  adaptorName      = "PostgreSQL";

  pkeyGeneratorDictionary = {
    newKeyExpression = "select nextval(\'key_generator\')";
  };
  
  entities = (
    { // <entity name=Address table=address>
      name                 = "Address";
      externalName         = "address";
      className            = "LSAddress";
      primaryKeyAttributes = ( "addressId" );
      
      attributesUsedForLocking = (
        city,
        sourceUrl,
        dbStatus,
        zip,
        addressId,
        companyId,
        country,
        objectVersion,
        district,
        state,
        street,
        name2,
        name3,
        name1,
        type,
      );
      classProperties = (
        city,
        sourceUrl,
        dbStatus,
        zip,
        addressId,
        companyId,
        country,
        objectVersion,
        district,
        state,
        street,
        name2,
        name3,
        name1,
        type,
        toTeam,
        toPerson,
        toEnterprise,
      );

      attributes = (
        {
          name           = "addressId";
          columnName     = "address_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "city";
          columnName     = "zipcity";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "country";
          columnName     = "country";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "district";
          columnName     = "district";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name1";
          columnName     = "name1";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name2";
          columnName     = "name2";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name3";
          columnName     = "name3";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "state";
          columnName     = "state";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "street";
          columnName     = "street";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "type";
          columnName     = "type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "zip";
          columnName     = "zip";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=AppointmentResource table=appointment_resource>
      name                 = "AppointmentResource";
      externalName         = "appointment_resource";
      className            = "LSAppointmentResource";
      primaryKeyAttributes = ( "appointmentResourceId" );
      
      attributesUsedForLocking = ( dbStatus, name, appointmentResourceId );
      classProperties = (
        category,
        notificationTime,
        dbStatus,
        name,
        emailSubject,
        appointmentResourceId,
        email,
      );

      attributes = (
        {
          name           = "appointmentResourceId";
          columnName     = "appointment_resource_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "category";
          columnName     = "category";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "emailSubject";
          columnName     = "email_subject";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name";
          columnName     = "name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "notificationTime";
          columnName     = "notification_time";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=Article table=article>
      name                 = "Article";
      externalName         = "article";
      className            = "LSArticle";
      primaryKeyAttributes = ( "articleId" );
      
      attributesUsedForLocking = (
        articleName,
        objectVersion,
        articleNr,
        vatGroup,
        articleId,
      );
      classProperties = (
        articleName,
        status,
        articleCategoryId,
        objectVersion,
        articleNr,
        price,
        comment,
        vatGroup,
        articleId,
        vat,
        articleUnitId,
        dbStatus,
        toArticleCategory,
        toArticleUnit,
        toInvoiceArticleAssignment,
      );

      attributes = (
        {
          name           = "articleCategoryId";
          columnName     = "article_category_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "articleId";
          columnName     = "article_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "articleName";
          columnName     = "article_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "articleNr";
          columnName     = "article_nr";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "articleUnitId";
          columnName     = "article_unit_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "comment";
          columnName     = "article_text";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "price";
          columnName     = "price";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "vat";
          columnName     = "vat";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "vatGroup";
          columnName     = "vat_group";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toArticleCategory";
          destination = "ArticleCategory";
          joins       = ( {
            sourceAttribute      = "articleCategoryId";
            destinationAttribute = "articleCategoryId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toArticleUnit";
          destination = "ArticleUnit";
          joins       = ( {
            sourceAttribute      = "articleUnitId";
            destinationAttribute = "articleUnitId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toInvoiceArticleAssignment";
          destination = "InvoiceArticleAssignment";
          joins       = ( {
            sourceAttribute      = "articleId";
            destinationAttribute = "articleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=ArticleCategory table=article_category>
      name                 = "ArticleCategory";
      externalName         = "article_category";
      className            = "LSArticleCategory";
      primaryKeyAttributes = ( "articleCategoryId" );
      
      attributesUsedForLocking = (
        articleCategoryId,
        categoryName,
        categoryAbbrev,
      );
      classProperties = (
        articleCategoryId,
        categoryName,
        categoryAbbrev,
        toArticle,
      );

      attributes = (
        {
          name           = "articleCategoryId";
          columnName     = "article_category_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "categoryAbbrev";
          columnName     = "category_abbrev";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "categoryName";
          columnName     = "category_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toArticle";
          destination = "Article";
          joins       = ( {
            sourceAttribute      = "articleCategoryId";
            destinationAttribute = "articleCategoryId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=ArticleUnit table=article_unit>
      name                 = "ArticleUnit";
      externalName         = "article_unit";
      className            = "LSArticleUnit";
      primaryKeyAttributes = ( "articleUnitId" );
      
      attributesUsedForLocking = (
        pluralUnit,
        description,
        singularUnit,
        articleUnitId,
      );
      classProperties = (
        pluralUnit,
        description,
        singularUnit,
        articleUnitId,
        toArticle,
      );

      attributes = (
        {
          name           = "articleUnitId";
          columnName     = "article_unit_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "format";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "pluralUnit";
          columnName     = "plural_unit";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "singularUnit";
          columnName     = "singular_unit";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toArticle";
          destination = "Article";
          joins       = ( {
            sourceAttribute      = "articleUnitId";
            destinationAttribute = "articleUnitId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=CompanyAssignment table=company_assignment>
      name                 = "CompanyAssignment";
      externalName         = "company_assignment";
      className            = "LSCompanyAssignment";
      primaryKeyAttributes = ( "companyAssignmentId" );
      
      attributesUsedForLocking = (
        function,
        companyAssignmentId,
        isChief,
        isHeadquarter,
        dbStatus,
        companyId,
        subCompanyId,
      );
      classProperties = (
        function,
        companyAssignmentId,
        isChief,
        isHeadquarter,
        dbStatus,
        companyId,
        subCompanyId,
        toEnterprise,
        toTeam,
        toPerson,
      );

      attributes = (
        {
          name           = "companyAssignmentId";
          columnName     = "company_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "function";
          columnName     = "function";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isChief";
          columnName     = "is_chief";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isHeadquarter";
          columnName     = "is_headquarter";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "subCompanyId";
          columnName     = "sub_company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "subCompanyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=CompanyCategory table=company_category>
      name                 = "CompanyCategory";
      externalName         = "company_category";
      className            = "LSCompanyCategory";
      primaryKeyAttributes = ( "companyCategoryId" );
      
      attributesUsedForLocking = ( category, companyCategoryId, dbStatus );
      classProperties = ( category, companyCategoryId, dbStatus );

      attributes = (
        {
          name           = "category";
          columnName     = "category";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyCategoryId";
          columnName     = "company_category_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
      );
    },
    { // <entity name=CompanyInfo table=company_info>
      name                 = "CompanyInfo";
      externalName         = "company_info";
      className            = "LSCompanyInfo";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = (
        comment,
        dbStatus,
        companyInfoId,
        companyId,
      );
      classProperties = (
        comment,
        dbStatus,
        companyInfoId,
        companyId,
        toTeam,
        toEnterprise,
        toPerson,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyInfoId";
          columnName     = "company_info_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=CompanyValue table=company_value>
      name                 = "CompanyValue";
      externalName         = "company_value";
      className            = "LSCompanyValue";
      primaryKeyAttributes = ( "companyValueId" );
      
      attributesUsedForLocking = (
        attribute,
        companyValueId,
        dbStatus,
        companyId,
        value,
        isEnum,
      );
      classProperties = (
        uid,
        attribute,
        isLabelLocalized,
        companyValueId,
        dbStatus,
        companyId,
        value,
        label,
        isEnum,
        type,
        toEnterprise,
        toPerson,
        toTeam,
      );

      attributes = (
        {
          name           = "attribute";
          columnName     = "attribute";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyValueId";
          columnName     = "company_value_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isEnum";
          columnName     = "is_enum";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isLabelLocalized";
          columnName     = "is_label_localized";
          externalType   = "INT";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "label";
          columnName     = "label";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "type";
          columnName     = "type";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "uid";
          columnName     = "uid";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "value";
          columnName     = "value_string";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Date table=date_x>
      name                 = "Date";
      externalName         = "date_x";
      className            = "LSAppointment";
      primaryKeyAttributes = ( "dateId" );
      
      attributesUsedForLocking = (
        accessTeamId,
        ownerId,
        dateId,
        objectVersion,
      );
      classProperties = (
        startDate,
        endDate,
        resourceNames,
        evoReminder,
        keywords,
        notificationTime,
        parentDateId,
        title,
        absence,
        isConflictDisabled,
        location,
        type,
        sourceUrl,
        calendarName,
        aptType,
        dbStatus,
        accessTeamId,
        travelDurationBefore,
        lastModified,
        ownerId,
        onlineMeeting,
        sensitivity,
        olReminder,
        cycleEndDate,
        writeAccessList,
        dateId,
        associatedContacts,
        importance,
        objectVersion,
        travelDurationAfter,
        isAbsence,
        busyType,
        fbtype,
        isAttendance,
        toOwner,
        toAccessTeam,
        toParentDate,
        toDateInfo,
        toDate,
        toDateCompanyAssignment,
        toNote,
      );

      attributes = (
        {
          name           = "absence";
          columnName     = "absence";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "accessTeamId";
          columnName     = "access_team_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "aptType";
          columnName     = "apt_type";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "busyType";
          columnName     = "busy_type";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "calendarName";
          columnName     = "calendar_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "cycleEndDate";
          columnName     = "cycle_end_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "evoReminder";
          columnName     = "evo_reminder";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fbtype";
          columnName     = "fbtype";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "importance";
          columnName     = "importance";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isAbsence";
          columnName     = "is_absence";
          externalType   = "INT";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "isAttendance";
          columnName     = "is_attendance";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isConflictDisabled";
          columnName     = "is_conflict_disabled";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "lastModified";
          columnName     = "last_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "location";
          columnName     = "location";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "notificationTime";
          columnName     = "notification_time";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "olReminder";
          columnName     = "ol_reminder";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "onlineMeeting";
          columnName     = "online_meeting";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentDateId";
          columnName     = "parent_date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceNames";
          columnName     = "resource_names";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "travelDurationAfter";
          columnName     = "travel_duration_after";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "travelDurationBefore";
          columnName     = "travel_duration_before";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "type";
          columnName     = "type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "writeAccessList";
          columnName     = "write_access_list";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toAccessTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "accessTeamId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "parentDateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDateCompanyAssignment";
          destination = "DateCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDateInfo";
          destination = "DateInfo";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toNote";
          destination = "Note";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toParentDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "parentDateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=DateCompanyAssignment table=date_company_assignment>
      name                 = "DateCompanyAssignment";
      externalName         = "date_company_assignment";
      className            = "LSDateCompanyAssignment";
      primaryKeyAttributes = ( "dateCompanyAssignmentId" );
      
      attributesUsedForLocking = (
        comment,
        dateCompanyAssignmentId,
        outlookKey,
        isStaff,
        dbStatus,
        companyId,
        role,
        dateId,
        partStatus,
        rsvp,
      );
      classProperties = (
        comment,
        dateCompanyAssignmentId,
        outlookKey,
        isStaff,
        dbStatus,
        companyId,
        role,
        dateId,
        partStatus,
        rsvp,
        toDate,
        toTeam,
        toPerson,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateCompanyAssignmentId";
          columnName     = "date_company_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isStaff";
          columnName     = "is_staff";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "outlookKey";
          columnName     = "outlook_key";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "partStatus";
          columnName     = "partstatus";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "role";
          columnName     = "role";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "rsvp";
          columnName     = "rsvp";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=DateInfo table=date_info>
      name                 = "DateInfo";
      externalName         = "date_info";
      className            = "LSDateInfo";
      primaryKeyAttributes = ( "dateId" );
      
      attributesUsedForLocking = ( comment, dbStatus, dateId, dateInfoId );
      classProperties = ( comment, dbStatus, dateId, dateInfoId, toDate );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateInfoId";
          columnName     = "date_info_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
      );

      relationships = (
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Doc table=doc>
      name                 = "Doc";
      externalName         = "doc";
      className            = "LSDoc";
      primaryKeyAttributes = ( "documentId" );
      
      attributesUsedForLocking = (
        status,
        isIndexDoc,
        abstract,
        isFolder,
        objectVersion,
        firstOwnerId,
        fileSize,
        dbStatus,
        creationDate,
        isObjectLink,
        objectLink,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        contact,
        documentId,
        lastmodifiedDate,
        isNote,
        currentOwnerId,
        dateId,
      );
      classProperties = (
        status,
        isIndexDoc,
        abstract,
        isFolder,
        objectVersion,
        firstOwnerId,
        fileSize,
        dbStatus,
        creationDate,
        isObjectLink,
        objectLink,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        contact,
        documentId,
        lastmodifiedDate,
        isNote,
        currentOwnerId,
        dateId,
        toDocumentEditing,
        toDate,
        toCurrentOwner,
        toDoc,
        toFirstOwner,
        toParentDocument,
        toNote,
        toDocumentVersion,
        toProject,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "firstOwnerId";
          columnName     = "first_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isFolder";
          columnName     = "is_folder";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isIndexDoc";
          columnName     = "is_index_doc";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isNote";
          columnName     = "is_note";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isObjectLink";
          columnName     = "is_object_link";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "lastmodifiedDate";
          columnName     = "lastmodified_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "objectLink";
          columnName     = "object_link";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentDocumentId";
          columnName     = "parent_document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "versionCount";
          columnName     = "version_count";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toCurrentOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "currentOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDoc";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "parentDocumentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDocumentEditing";
          destination = "DocumentEditing";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDocumentVersion";
          destination = "DocumentVersion";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toFirstOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "firstOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toNote";
          destination = "Note";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "parentDocumentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toParentDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "parentDocumentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=DocumentEditing table=document_editing>
      name                 = "DocumentEditing";
      externalName         = "document_editing";
      className            = "LSDocumentEditing";
      primaryKeyAttributes = ( "documentId" );
      
      attributesUsedForLocking = (
        status,
        fileType,
        checkoutDate,
        title,
        abstract,
        contact,
        version,
        isAttachChanged,
        documentId,
        dbStatus,
        documentEditingId,
        currentOwnerId,
        fileSize,
      );
      classProperties = (
        status,
        fileType,
        checkoutDate,
        title,
        abstract,
        contact,
        version,
        isAttachChanged,
        documentId,
        dbStatus,
        documentEditingId,
        currentOwnerId,
        fileSize,
        toCurrentOwner,
        toDoc,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "checkoutDate";
          columnName     = "checkout_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentEditingId";
          columnName     = "document_editing_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isAttachChanged";
          columnName     = "is_attach_changed";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "version";
          columnName     = "version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toCurrentOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "currentOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDoc";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=DocumentVersion table=document_version>
      name                 = "DocumentVersion";
      externalName         = "document_version";
      className            = "LSDocumentVersion";
      primaryKeyAttributes = ( "documentVersionId" );
      
      attributesUsedForLocking = (
        fileSize,
        fileType,
        dbStatus,
        title,
        abstract,
        documentVersionId,
        contact,
        version,
        documentId,
        isPacked,
        creationDate,
        archiveDate,
        lastOwnerId,
      );
      classProperties = (
        fileSize,
        fileType,
        dbStatus,
        title,
        abstract,
        documentVersionId,
        contact,
        version,
        documentId,
        isPacked,
        creationDate,
        archiveDate,
        lastOwnerId,
        toLastOwner,
        toDoc,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "archiveDate";
          columnName     = "archive_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "documentVersionId";
          columnName     = "document_version_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isPacked";
          columnName     = "is_packed";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "lastOwnerId";
          columnName     = "last_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "version";
          columnName     = "version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toDoc";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toLastOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "lastOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Enterprise table=enterprise>
      name                 = "Enterprise";
      externalName         = "enterprise";
      className            = "LSEnterprise";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = ( ownerId, companyId, objectVersion );
      classProperties = (
        bossName,
        office,
        assistantName,
        number,
        keywords,
        occupation,
        priority,
        partnerName,
        sourceUrl,
        associatedCategories,
        isPrivate,
        showEmail3As,
        bank,
        account,
        dbStatus,
        associatedCompany,
        imAddress,
        ownerId,
        dirServer,
        showEmailAs,
        isReadonly,
        isEnterprise,
        sensitivity,
        contactId,
        nameAffix,
        companyId,
        anniversary,
        fileas,
        department,
        email,
        associatedContacts,
        description,
        firstname,
        objectVersion,
        freebusyUrl,
        birthday,
        emailAlias,
        bankCode,
        isCustomer,
        showEmail2As,
        url,
        login,
        nameTitle,
        toCompanyAssignment,
        toCompanyInfo,
        toDateCompanyAssignment,
        toNote,
        toStaff,
        toProjectCompanyAssignment,
        toOwner,
        toCompanyAssignment1,
        toTelephone,
        toAddress,
        toCompanyValue,
        toContact,
        toInvoice,
      );

      attributes = (
        {
          name           = "account";
          columnName     = "account";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "bank";
          columnName     = "bank";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "bankCode";
          columnName     = "bank_code";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "birthday";
          columnName     = "birthday";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "firstname";
          columnName     = "firstname";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isCustomer";
          columnName     = "is_customer";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isEnterprise";
          columnName     = "is_enterprise";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "number";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "showEmail2As";
          columnName     = "show_email2_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmail3As";
          columnName     = "show_email3_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmailAs";
          columnName     = "show_email_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toAddress";
          destination = "Address";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment1";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "subCompanyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyInfo";
          destination = "CompanyInfo";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toCompanyValue";
          destination = "CompanyValue";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toContact";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "contactId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDateCompanyAssignment";
          destination = "DateCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toInvoice";
          destination = "Invoice";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "debitorId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toNote";
          destination = "Note";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProjectCompanyAssignment";
          destination = "ProjectCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toStaff";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toTelephone";
          destination = "Telephone";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=Invoice table=invoice>
      name                 = "Invoice";
      externalName         = "invoice";
      className            = "LSInvoice";
      primaryKeyAttributes = ( "invoiceId" );
      
      attributesUsedForLocking = ( status, invoiceId, objectVersion );
      classProperties = (
        status,
        comment,
        kind,
        invoiceId,
        dbStatus,
        parentInvoiceId,
        invoiceDate,
        debitorId,
        invoiceNr,
        paid,
        objectVersion,
        grossAmount,
        netAmount,
        toInvoiceArticleAssignment,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "debitorId";
          columnName     = "debitor_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
        },
        {
          name           = "grossAmount";
          columnName     = "gross_amount";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "invoiceDate";
          columnName     = "invoice_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "invoiceNr";
          columnName     = "invoice_nr";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "netAmount";
          columnName     = "net_amount";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "paid";
          columnName     = "paid";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "parentInvoiceId";
          columnName     = "parent_invoice_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          width          = 100;
        },
      );

      relationships = (
        {
          name        = "toDebitor";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "debitorId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toInvoiceArticleAssignment";
          destination = "InvoiceArticleAssignment";
          joins       = ( {
            sourceAttribute      = "invoiceId";
            destinationAttribute = "invoiceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=InvoiceAccount table=invoice_account>
      name                 = "InvoiceAccount";
      externalName         = "invoice_account";
      className            = "LSInvoiceAccount";
      primaryKeyAttributes = ( "invoiceAccountId" );
      
      attributesUsedForLocking = (
        objectVersion,
        companyId,
        invoiceAccountId,
      );
      classProperties = (
        dbStatus,
        objectVersion,
        companyId,
        accountNr,
        invoiceAccountId,
        balance,
        toEnterprise,
      );

      attributes = (
        {
          name           = "accountNr";
          columnName     = "account_nr";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "balance";
          columnName     = "balance";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "enterprise_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "invoiceAccountId";
          columnName     = "invoice_account_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=InvoiceAccounting table=invoice_accounting>
      name                 = "InvoiceAccounting";
      externalName         = "invoice_accounting";
      className            = "LSInvoiceAccounting";
      primaryKeyAttributes = ( "invoiceAccountingId" );
      
      attributesUsedForLocking = (
        objectVersion,
        dbStatus,
        invoiceAccountingId,
        actionId,
      );
      classProperties = (
        objectVersion,
        dbStatus,
        invoiceAccountingId,
        debit,
        balance,
        actionId,
        toInvoiceAction,
      );

      attributes = (
        {
          name           = "actionId";
          columnName     = "action_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "balance";
          columnName     = "balance";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "debit";
          columnName     = "debit";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "invoiceAccountingId";
          columnName     = "invoice_accounting_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toInvoiceAction";
          destination = "InvoiceAction";
          joins       = ( {
            sourceAttribute      = "actionId";
            destinationAttribute = "invoiceActionId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=InvoiceAction table=invoice_action>
      name                 = "InvoiceAction";
      externalName         = "invoice_action";
      className            = "LSInvoiceAction";
      primaryKeyAttributes = ( "invoiceActionId" );
      
      attributesUsedForLocking = (
        invoiceId,
        objectVersion,
        documentId,
        accountId,
        dbStatus,
        invoiceActionId,
      );
      classProperties = (
        actionDate,
        invoiceId,
        logText,
        objectVersion,
        documentId,
        accountId,
        kind,
        dbStatus,
        invoiceActionId,
        toInvoiceAccount,
        toDocument,
        toInvoice,
      );

      attributes = (
        {
          name           = "accountId";
          columnName     = "account_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "actionDate";
          columnName     = "action_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "invoiceActionId";
          columnName     = "invoice_action_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "kind";
          columnName     = "action_kind";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "logText";
          columnName     = "log_text";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toInvoice";
          destination = "Invoice";
          joins       = ( {
            sourceAttribute      = "invoiceId";
            destinationAttribute = "invoiceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toInvoiceAccount";
          destination = "InvoiceAccount";
          joins       = ( {
            sourceAttribute      = "accountId";
            destinationAttribute = "invoiceAccountId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=InvoiceArticleAssignment table=invoice_article_assignment>
      name                 = "InvoiceArticleAssignment";
      externalName         = "invoice_article_assignment";
      className            = "LSInvoiceArticleAssignment";
      primaryKeyAttributes = ( "invoiceArticleAssignmentId" );
      
      attributesUsedForLocking = (
        objectVersion,
        invoiceArticleAssignmentId,
      );
      classProperties = (
        comment,
        invoiceId,
        objectVersion,
        articleId,
        articleCount,
        netAmount,
        dbStatus,
        invoiceArticleAssignmentId,
        vat,
        toArticle,
        toInvoice,
      );

      attributes = (
        {
          name           = "articleCount";
          columnName     = "article_count";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
        },
        {
          name           = "articleId";
          columnName     = "article_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "invoiceArticleAssignmentId";
          columnName     = "invoice_article_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "netAmount";
          columnName     = "net_amount";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "vat";
          columnName     = "vat";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toArticle";
          destination = "Article";
          joins       = ( {
            sourceAttribute      = "articleId";
            destinationAttribute = "articleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toInvoice";
          destination = "Invoice";
          joins       = ( {
            sourceAttribute      = "invoiceId";
            destinationAttribute = "invoiceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Job table=job>
      name                 = "Job";
      externalName         = "job";
      className            = "LSJob";
      primaryKeyAttributes = ( "jobId" );
      
      attributesUsedForLocking = ( jobId, objectVersion );
      classProperties = (
        comment,
        startDate,
        endDate,
        kilometers,
        jobId,
        keywords,
        completionDate,
        projectId,
        jobStatus,
        priority,
        accountingInfo,
        sourceUrl,
        parentJobId,
        associatedCompanies,
        isControlJob,
        timerDate,
        totalWork,
        isTeamJob,
        kind,
        dbStatus,
        name,
        lastModified,
        actualWork,
        ownerId,
        notify,
        sensitivity,
        executantId,
        percentComplete,
        category,
        associatedContacts,
        objectVersion,
        creatorId,
        toParentJobAssignment,
        toExecutant,
        toJob,
        toResourceAssignment,
        toJobHistory,
        toChildJobAssignment,
        toCreator,
        toOwner,
        toParentJob,
        toProject,
      );

      attributes = (
        {
          name           = "accountingInfo";
          columnName     = "accounting_info";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "actualWork";
          columnName     = "actual_work";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "associatedCompanies";
          columnName     = "associated_companies";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "category";
          columnName     = "category";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "comment";
          columnName     = "job_comment";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 8000;
        },
        {
          name           = "completionDate";
          columnName     = "completion_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "creatorId";
          columnName     = "creator_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "executantId";
          columnName     = "executant_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isControlJob";
          columnName     = "is_control_job";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeamJob";
          columnName     = "is_team_job";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "jobStatus";
          columnName     = "job_status";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "kilometers";
          columnName     = "kilometers";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "lastModified";
          columnName     = "last_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "name";
          columnName     = "name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "notify";
          columnName     = "notify_x";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "parentJobId";
          columnName     = "parent_job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "percentComplete";
          columnName     = "percent_complete";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "timerDate";
          columnName     = "timer_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "totalWork";
          columnName     = "total_work";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toChildJobAssignment";
          destination = "JobAssignment";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "parentJobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCreator";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "creatorId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toExecutant";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "executantId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "parentJobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJobHistory";
          destination = "JobHistory";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toParentJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "parentJobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toParentJobAssignment";
          destination = "JobAssignment";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "childJobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toResourceAssignment";
          destination = "JobResourceAssignment";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=JobAssignment table=job_assignment>
      name                 = "JobAssignment";
      externalName         = "job_assignment";
      className            = "LSJobAssignment";
      primaryKeyAttributes = ( "jobAssignmentId" );
      
      attributesUsedForLocking = (
        parentJobId,
        jobAssignmentId,
        dbStatus,
        childJobId,
      );
      classProperties = (
        parentJobId,
        jobAssignmentId,
        assignmentKind,
        dbStatus,
        childJobId,
        position,
        toParentJob,
        toChildJob,
      );

      attributes = (
        {
          name           = "assignmentKind";
          columnName     = "assignment_kind";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "childJobId";
          columnName     = "child_job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobAssignmentId";
          columnName     = "job_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "parentJobId";
          columnName     = "parent_job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "position";
          columnName     = "position_x";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toChildJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "childJobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toParentJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "parentJobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=JobHistory table=job_history>
      name                 = "JobHistory";
      externalName         = "job_history";
      className            = "LSJobHistory";
      primaryKeyAttributes = ( "jobHistoryId" );
      
      attributesUsedForLocking = (
        actionDate,
        jobHistoryId,
        jobId,
        dbStatus,
        jobStatus,
        action,
        actorId,
      );
      classProperties = (
        actionDate,
        jobHistoryId,
        jobId,
        dbStatus,
        jobStatus,
        action,
        actorId,
        toJob,
        toActor,
        toJobHistoryInfo,
      );

      attributes = (
        {
          name           = "action";
          columnName     = "action";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "actionDate";
          columnName     = "action_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "actorId";
          columnName     = "actor_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobHistoryId";
          columnName     = "job_history_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobStatus";
          columnName     = "job_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
      );

      relationships = (
        {
          name        = "toActor";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "actorId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toJobHistoryInfo";
          destination = "JobHistoryInfo";
          joins       = ( {
            sourceAttribute      = "jobHistoryId";
            destinationAttribute = "jobHistoryId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=JobHistoryInfo table=job_history_info>
      name                 = "JobHistoryInfo";
      externalName         = "job_history_info";
      className            = "LSJobHistoryInfo";
      primaryKeyAttributes = ( "jobHistoryInfoId" );
      
      attributesUsedForLocking = (
        comment,
        jobHistoryId,
        jobHistoryInfoId,
        dbStatus,
      );
      classProperties = (
        comment,
        jobHistoryId,
        jobHistoryInfoId,
        dbStatus,
        toJobHistory,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobHistoryId";
          columnName     = "job_history_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobHistoryInfoId";
          columnName     = "job_history_info_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toJobHistory";
          destination = "JobHistory";
          joins       = ( {
            sourceAttribute      = "jobHistoryId";
            destinationAttribute = "jobHistoryId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=JobResourceAssignment table=job_resource_assignment>
      name                 = "JobResourceAssignment";
      externalName         = "job_resource_assignment";
      className            = "LSJobResourceAssignment";
      primaryKeyAttributes = ( "jobResourceAssignmentId" );
      
      attributesUsedForLocking = (
        operativePart,
        dbStatus,
        jobResourceAssignmentId,
        resourceId,
        jobId,
      );
      classProperties = (
        operativePart,
        dbStatus,
        jobResourceAssignmentId,
        resourceId,
        jobId,
        toResource,
        toJob,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "jobResourceAssignmentId";
          columnName     = "job_resource_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "operativePart";
          columnName     = "operative_part";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceId";
          columnName     = "resource_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
      );

      relationships = (
        {
          name        = "toJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "jobId";
            destinationAttribute = "jobId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toResource";
          destination = "Resource";
          joins       = ( {
            sourceAttribute      = "resourceId";
            destinationAttribute = "resourceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Log table=log>
      name                 = "Log";
      externalName         = "log";
      className            = "LSLog";
      primaryKeyAttributes = ( "logId" );
      
      attributesUsedForLocking = ( logId );
      classProperties = (
        logId,
        logText,
        objectId,
        action,
        creationDate,
        accountId,
      );

      attributes = (
        {
          name           = "accountId";
          columnName     = "account_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "action";
          columnName     = "action";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "logId";
          columnName     = "log_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "logText";
          columnName     = "log_text";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectId";
          columnName     = "object_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=NewsArticle table=news_article>
      name                 = "NewsArticle";
      externalName         = "news_article";
      className            = "LSNewsArticle";
      primaryKeyAttributes = ( "newsArticleId" );
      
      attributesUsedForLocking = (
        caption,
        newsArticleId,
        isIndexArticle,
        name,
        dbStatus,
      );
      classProperties = (
        caption,
        newsArticleId,
        isIndexArticle,
        name,
        dbStatus,
        toNewsArticleLink,
        toNewsArticleLink1,
      );

      attributes = (
        {
          name           = "caption";
          columnName     = "caption";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isIndexArticle";
          columnName     = "is_index_article";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "name";
          columnName     = "name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "newsArticleId";
          columnName     = "news_article_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toNewsArticleLink";
          destination = "NewsArticleLink";
          joins       = ( {
            sourceAttribute      = "newsArticleId";
            destinationAttribute = "newsArticleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toNewsArticleLink1";
          destination = "NewsArticleLink";
          joins       = ( {
            sourceAttribute      = "newsArticleId";
            destinationAttribute = "subNewsArticleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=NewsArticleLink table=news_article_link>
      name                 = "NewsArticleLink";
      externalName         = "news_article_link";
      className            = "LSNewsArticleLink";
      primaryKeyAttributes = ( "newsArticleLinkId" );
      
      attributesUsedForLocking = (
        subNewsArticleId,
        newsArticleId,
        newsArticleLinkId,
      );
      classProperties = (
        subNewsArticleId,
        newsArticleId,
        newsArticleLinkId,
        toNewsArticle,
        toSubNewsArticle,
      );

      attributes = (
        {
          name           = "newsArticleId";
          columnName     = "news_article_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "newsArticleLinkId";
          columnName     = "news_article_link_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "subNewsArticleId";
          columnName     = "sub_news_article_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toNewsArticle";
          destination = "NewsArticle";
          joins       = ( {
            sourceAttribute      = "newsArticleId";
            destinationAttribute = "newsArticleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toSubNewsArticle";
          destination = "NewsArticle";
          joins       = ( {
            sourceAttribute      = "subNewsArticleId";
            destinationAttribute = "newsArticleId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Note table=note>
      name                 = "Note";
      externalName         = "note";
      className            = "LSNote";
      primaryKeyAttributes = ( "documentId" );
      
      attributesUsedForLocking = (
        abstract,
        isFolder,
        parentDocumentId,
        companyId,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        objectVersion,
        firstOwnerId,
        creationDate,
        documentId,
        dbStatus,
        lastmodifiedDate,
        title,
        isNote,
      );
      classProperties = (
        abstract,
        isFolder,
        parentDocumentId,
        companyId,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        objectVersion,
        firstOwnerId,
        creationDate,
        documentId,
        dbStatus,
        lastmodifiedDate,
        title,
        isNote,
        toEnterprise,
        toParentDocument,
        toDate,
        toDocument,
        toDocumentVersion,
        toFirstOwner,
        toPerson,
        toCurrentOwner,
        toProject,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "firstOwnerId";
          columnName     = "first_owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isFolder";
          columnName     = "is_folder";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isNote";
          columnName     = "is_note";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "lastmodifiedDate";
          columnName     = "lastmodified_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentDocumentId";
          columnName     = "parent_document_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "versionCount";
          columnName     = "version_count";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toCurrentOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "currentOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "dateId";
            destinationAttribute = "dateId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "parentDocumentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDocumentVersion";
          destination = "DocumentVersion";
          joins       = ( {
            sourceAttribute      = "documentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toFirstOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "firstOwnerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toParentDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "parentDocumentId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=ObjectAcl table=object_acl>
      name                 = "ObjectAcl";
      externalName         = "object_acl";
      className            = "LSObjectAcl";
      primaryKeyAttributes = ( "objectAclId" );
      
      attributesUsedForLocking = ( objectAclId );
      classProperties = (
        objectAclId,
        sortKey,
        objectId,
        authId,
        action,
        permissions,
      );

      attributes = (
        {
          name           = "action";
          columnName     = "action";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 10;
        },
        {
          name           = "authId";
          columnName     = "auth_id";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectAclId";
          columnName     = "object_acl_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectId";
          columnName     = "object_id";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "permissions";
          columnName     = "permissions";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          valueType      = 50;
          allowsNull     = Y;
        },
        {
          name           = "sortKey";
          columnName     = "sort_key";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
      );
    },
    { // <entity name=ObjectInfo table=obj_info>
      name                 = "ObjectInfo";
      externalName         = "obj_info";
      className            = "LSObjectInfo";
      primaryKeyAttributes = ( "objectId" );
      
      attributesUsedForLocking = ( objectId, objectType );
      classProperties = ( objectId, objectType );

      attributes = (
        {
          name           = "objectId";
          columnName     = "obj_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectType";
          columnName     = "obj_type";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
      );
    },
    { // <entity name=ObjectLink table=obj_link>
      name                 = "ObjectLink";
      externalName         = "obj_link";
      className            = "LSObjectLink";
      primaryKeyAttributes = ( "objectLinkId" );
      
      attributesUsedForLocking = ( objectLinkId, target, sourceId, targetId );
      classProperties = (
        linkType,
        targetType,
        objectLinkId,
        target,
        sourceId,
        label,
        targetId,
        sourceType,
      );

      attributes = (
        {
          name           = "label";
          columnName     = "label";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "linkType";
          columnName     = "link_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectLinkId";
          columnName     = "obj_link_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "sourceId";
          columnName     = "source_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "sourceType";
          columnName     = "source_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "target";
          columnName     = "target";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "targetId";
          columnName     = "target_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "targetType";
          columnName     = "target_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=ObjectProperty table=obj_property>
      name                 = "ObjectProperty";
      externalName         = "obj_property";
      className            = "LSObjectProperty";
      primaryKeyAttributes = ( "objectPropertyId" );
      
      attributesUsedForLocking = ( objectId, objectPropertyId );
      classProperties = (
        blobSize,
        valueDate,
        objectId,
        accessKey,
        valueBlob,
        namespacePrefix,
        preferredType,
        valueInt,
        key,
        valueFloat,
        valueOID,
        objectPropertyId,
        valueString,
        objectType,
        toDoc,
      );

      attributes = (
        {
          name           = "accessKey";
          columnName     = "access_key";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "blobSize";
          columnName     = "blob_size";
          externalType   = "INT";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "key";
          columnName     = "value_key";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "namespacePrefix";
          columnName     = "namespace_prefix";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectId";
          columnName     = "obj_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectPropertyId";
          columnName     = "obj_property_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectType";
          columnName     = "obj_type";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "preferredType";
          columnName     = "preferred_type";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "valueBlob";
          columnName     = "value_blob";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSData";
          allowsNull     = Y;
        },
        {
          name           = "valueDate";
          columnName     = "value_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "valueFloat";
          columnName     = "value_float";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = f;
          allowsNull     = Y;
        },
        {
          name           = "valueInt";
          columnName     = "value_int";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "valueOID";
          columnName     = "value_oid";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "valueString";
          columnName     = "value_string";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toDoc";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "objectId";
            destinationAttribute = "documentId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Person table=person>
      name                 = "Person";
      externalName         = "person";
      className            = "LSPerson";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = (
        companyId,
        objectVersion,
        dbStatus,
        ownerId,
      );
      classProperties = (
        emailAlias,
        office,
        isReadonly,
        sensitivity,
        assistantName,
        number,
        birthName,
        sex,
        salutation,
        contactId,
        associatedContacts,
        keywords,
        isTemplateUser,
        isIntraAccount,
        imapPasswd,
        nameAffix,
        fileas,
        degree,
        templateUserId,
        companyId,
        familyStatus,
        anniversary,
        priority,
        isLocked,
        isAccount,
        isExtraAccount,
        isPerson,
        isPrivate,
        occupation,
        citizenship,
        dayOfDeath,
        partnerName,
        birthPlace,
        sourceUrl,
        description,
        firstname,
        middlename,
        objectVersion,
        freebusyUrl,
        department,
        birthday,
        bossName,
        showEmail3As,
        password,
        login,
        showEmail2As,
        associatedCategories,
        dbStatus,
        name,
        url,
        associatedCompany,
        showEmailAs,
        imAddress,
        ownerId,
        isCustomer,
        nameTitle,
        dirServer,
        toCompanyAssignment,
        toStaff,
        toCompanyInfo,
        toProjectCompanyAssignment,
        toNote,
        toDateCompanyAssignment,
        toTelephone,
        toAddress,
        toOwner,
        toCompanyAssignment1,
        toCompanyValue,
        toContact,
      );

      attributes = (
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "birthName";
          columnName     = "birthname";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "birthPlace";
          columnName     = "birthplace";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "birthday";
          columnName     = "birthday";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "citizenship";
          columnName     = "citizenship";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dayOfDeath";
          columnName     = "dayofdeath";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "degree";
          columnName     = "degree";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "familyStatus";
          columnName     = "family_status";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "firstname";
          columnName     = "firstname";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imapPasswd";
          columnName     = "pop3_account";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isAccount";
          columnName     = "is_account";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isCustomer";
          columnName     = "is_customer";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isExtraAccount";
          columnName     = "is_extra_account";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isIntraAccount";
          columnName     = "is_intra_account";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isLocked";
          columnName     = "is_locked";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPerson";
          columnName     = "is_person";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTemplateUser";
          columnName     = "is_template_user";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "middlename";
          columnName     = "middlename";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "name";
          columnName     = "name";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "number";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "password";
          columnName     = "password";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "salutation";
          columnName     = "salutation";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sex";
          columnName     = "sex";
          externalType   = "VARCHAR(10)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 10;
        },
        {
          name           = "showEmail2As";
          columnName     = "show_email2_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmail3As";
          columnName     = "show_email3_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmailAs";
          columnName     = "show_email_as";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "templateUserId";
          columnName     = "template_user_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toAddress";
          destination = "Address";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment1";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "subCompanyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyInfo";
          destination = "CompanyInfo";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toCompanyValue";
          destination = "CompanyValue";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toContact";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "contactId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDateCompanyAssignment";
          destination = "DateCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toNote";
          destination = "Note";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProjectCompanyAssignment";
          destination = "ProjectCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toStaff";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toTelephone";
          destination = "Telephone";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=Project table=project>
      name                 = "Project";
      externalName         = "project";
      className            = "LSProject";
      primaryKeyAttributes = ( "projectId" );
      
      attributesUsedForLocking = (
        startDate,
        endDate,
        number,
        teamId,
        projectId,
        status,
        objectVersion,
        dbStatus,
        name,
        isFake,
        ownerId,
      );
      classProperties = (
        startDate,
        endDate,
        number,
        teamId,
        projectId,
        status,
        objectVersion,
        kind,
        dbStatus,
        name,
        url,
        isFake,
        ownerId,
        toStaffTeam,
        toProjectInfo,
        toJob,
        toProjectCompanyAssignment,
        toDocument,
        toNote,
        toOwner,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "isFake";
          columnName     = "is_fake";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "name";
          columnName     = "name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "number";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "teamId";
          columnName     = "team_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
      );

      relationships = (
        {
          name        = "toDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toNote";
          destination = "Note";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProjectCompanyAssignment";
          destination = "ProjectCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toProjectInfo";
          destination = "ProjectInfo";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toStaffTeam";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "teamId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=ProjectCompanyAssignment table=project_company_assignment>
      name                 = "ProjectCompanyAssignment";
      externalName         = "project_company_assignment";
      className            = "LSProjectCompanyAssignment";
      primaryKeyAttributes = ( "projectCompanyAssignmentId" );
      
      attributesUsedForLocking = (
        dbStatus,
        companyId,
        projectId,
        projectCompanyAssignmentId,
      );
      classProperties = (
        accessRight,
        info,
        dbStatus,
        companyId,
        projectId,
        hasAccess,
        projectCompanyAssignmentId,
        toPerson,
        toProject,
      );

      attributes = (
        {
          name           = "accessRight";
          columnName     = "access_right";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "hasAccess";
          columnName     = "has_access";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "info";
          columnName     = "info";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "projectCompanyAssignmentId";
          columnName     = "project_company_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=ProjectInfo table=project_info>
      name                 = "ProjectInfo";
      externalName         = "project_info";
      className            = "LSProjectInfo";
      primaryKeyAttributes = ( "projectId" );
      
      attributesUsedForLocking = ( dbStatus, projectId, projectInfoId );
      classProperties = (
        comment,
        dbStatus,
        projectId,
        projectInfoId,
        toProject,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectInfoId";
          columnName     = "project_info_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "projectId";
            destinationAttribute = "projectId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Resource table=resource>
      name                 = "Resource";
      externalName         = "resource";
      className            = "LSResource";
      primaryKeyAttributes = ( "resourceId" );
      
      attributesUsedForLocking = ( standardCosts, resourceId, objectVersion );
      classProperties = (
        comment,
        standardCosts,
        resourceId,
        objectVersion,
        resourceName,
        dbStatus,
        objectId,
        token,
        type,
        quantity,
        toSubResourceAssignment,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "objectId";
          columnName     = "object_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "quantity";
          columnName     = "quantity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceId";
          columnName     = "resource_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "resourceName";
          columnName     = "resource_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "standardCosts";
          columnName     = "standard_costs";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = f;
          allowsNull     = Y;
        },
        {
          name           = "token";
          columnName     = "token";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "type";
          columnName     = "type";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
      );

      relationships = (
        {
          name        = "toSubResourceAssignment";
          destination = "ResourceAssignment";
          joins       = ( {
            sourceAttribute      = "resourceId";
            destinationAttribute = "superResourceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=ResourceAssignment table=resource_assignment>
      name                 = "ResourceAssignment";
      externalName         = "resource_assignment";
      className            = "LSResourceAssignment";
      primaryKeyAttributes = ( "resourceAssignmentId" );
      
      attributesUsedForLocking = (
        subResourceId,
        superResourceId,
        dbStatus,
        resourceAssignmentId,
      );
      classProperties = (
        subResourceId,
        superResourceId,
        dbStatus,
        resourceAssignmentId,
        toSuperResource,
        toSubResource,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "resourceAssignmentId";
          columnName     = "resource_assignment_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "subResourceId";
          columnName     = "sub_resource_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "superResourceId";
          columnName     = "super_resource_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toSubResource";
          destination = "Resource";
          joins       = ( {
            sourceAttribute      = "subResourceId";
            destinationAttribute = "resourceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toSuperResource";
          destination = "Resource";
          joins       = ( {
            sourceAttribute      = "superResourceId";
            destinationAttribute = "resourceId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=SessionLog table=session_log>
      name                 = "SessionLog";
      externalName         = "session_log";
      className            = "LSSessionLog";
      primaryKeyAttributes = ( "sessionLogId" );
      
      attributesUsedForLocking = ( sessionLogId );
      classProperties = ( logDate, action, sessionLogId, accountId );

      attributes = (
        {
          name           = "accountId";
          columnName     = "account_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "action";
          columnName     = "action";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "logDate";
          columnName     = "log_date";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "sessionLogId";
          columnName     = "session_log_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
      );
    },
    { // <entity name=Staff table=staff>
      name                 = "Staff";
      externalName         = "staff";
      className            = "LSStaff";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = (
        dbStatus,
        description,
        companyId,
        isTeam,
        isAccount,
        staffId,
        login,
      );
      classProperties = (
        dbStatus,
        description,
        companyId,
        isTeam,
        isAccount,
        staffId,
        login,
        toJob,
        toDocument1,
        toPerson,
        toDocumentEditing,
        toProject1,
        toDocumentVersion,
        toTeam,
        toJob1,
        toJobHistory,
        toJob2,
        toProject,
        toDocument,
      );

      attributes = (
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isAccount";
          columnName     = "is_account";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeam";
          columnName     = "is_team";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "staffId";
          columnName     = "staff_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toDocument";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "firstOwnerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDocument1";
          destination = "Doc";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "currentOwnerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDocumentEditing";
          destination = "DocumentEditing";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "currentOwnerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDocumentVersion";
          destination = "DocumentVersion";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "lastOwnerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJob";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "ownerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJob1";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "executantId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJob2";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "creatorId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJobHistory";
          destination = "JobHistory";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "actorId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProject";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "ownerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toProject1";
          destination = "Project";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "teamId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=Team table=team>
      name                 = "Team";
      externalName         = "team";
      className            = "LSTeam";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = (
        isPrivate,
        ownerId,
        isReadonly,
        companyId,
        objectVersion,
      );
      classProperties = (
        isLocationTeam,
        bossName,
        office,
        assistantName,
        number,
        occupation,
        fileas,
        partnerName,
        isPrivate,
        associatedCategories,
        dbStatus,
        associatedCompany,
        imAddress,
        ownerId,
        dirServer,
        isReadonly,
        sensitivity,
        isTeam,
        contactId,
        nameAffix,
        companyId,
        anniversary,
        department,
        email,
        associatedContacts,
        description,
        objectVersion,
        freebusyUrl,
        emailAlias,
        login,
        nameTitle,
        toCompanyAssignment,
        toCompanyInfo,
        toStaff,
        toDate,
        toProjectCompanyAssignment,
        toDateCompanyAssignment,
        toOwner,
        toCompanyAssignment1,
        toTelephone,
        toAddress,
        toCompanyValue,
        toContact,
      );

      attributes = (
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isLocationTeam";
          columnName     = "is_location_team";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeam";
          columnName     = "is_team";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "number";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );

      relationships = (
        {
          name        = "toAddress";
          destination = "Address";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyAssignment1";
          destination = "CompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "subCompanyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toCompanyInfo";
          destination = "CompanyInfo";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toCompanyValue";
          destination = "CompanyValue";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toContact";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "contactId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toDate";
          destination = "Date";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "ownerId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toDateCompanyAssignment";
          destination = "DateCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toOwner";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "ownerId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toProjectCompanyAssignment";
          destination = "ProjectCompanyAssignment";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toStaff";
          destination = "Staff";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toTelephone";
          destination = "Telephone";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
      );
    },
    { // <entity name=Telephone table=telephone>
      name                 = "Telephone";
      externalName         = "telephone";
      className            = "LSTelephone";
      primaryKeyAttributes = ( "telephoneId" );
      
      attributesUsedForLocking = (
        info,
        number,
        objectVersion,
        telephoneId,
        dbStatus,
        realNumber,
        companyId,
        url,
        type,
      );
      classProperties = (
        info,
        number,
        objectVersion,
        telephoneId,
        dbStatus,
        realNumber,
        companyId,
        url,
        type,
        toEnterprise,
        toPerson,
        toTeam,
      );

      attributes = (
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "info";
          columnName     = "info";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "number";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "realNumber";
          columnName     = "real_number";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "telephoneId";
          columnName     = "telephone_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "type";
          columnName     = "type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );

      relationships = (
        {
          name        = "toEnterprise";
          destination = "Enterprise";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toPerson";
          destination = "Person";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
        {
          name        = "toTeam";
          destination = "Team";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "companyId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
        },
      );
    },
    { // <entity name=palm_address table=palm_address>
      name                 = "palm_address";
      externalName         = "palm_address";
      className            = "LSPalmAddress";
      primaryKeyAttributes = ( "palm_address_id" );
      
      attributesUsedForLocking = (
        skyrix_type,
        phone_label_id0,
        phone_label_id1,
        phone_label_id2,
        phone_label_id3,
        phone_label_id4,
        city,
        title,
        company_id,
        skyrix_version,
        skyrix_palm_version,
        object_version,
        lastname,
        company,
        is_modified,
        is_new,
        skyrix_id,
        is_private,
        is_deleted,
        skyrix_sync,
        custom4,
        is_archived,
        custom1,
        custom2,
        custom3,
        display_phone,
        zipcode,
        note,
        state,
        palm_address_id,
        md5hash,
        firstname,
        category_index,
        phone2,
        phone3,
        phone0,
        phone1,
        phone4,
        palm_id,
        address,
        device_id,
        country,
      );
      classProperties = (
        skyrix_type,
        phone_label_id0,
        phone_label_id1,
        phone_label_id2,
        phone_label_id3,
        phone_label_id4,
        city,
        title,
        company_id,
        skyrix_version,
        skyrix_palm_version,
        object_version,
        lastname,
        company,
        is_modified,
        is_new,
        skyrix_id,
        is_private,
        is_deleted,
        skyrix_sync,
        custom4,
        is_archived,
        custom1,
        custom2,
        custom3,
        display_phone,
        zipcode,
        note,
        state,
        palm_address_id,
        md5hash,
        firstname,
        category_index,
        phone2,
        phone3,
        phone0,
        phone1,
        phone4,
        palm_id,
        address,
        device_id,
        country,
      );

      attributes = (
        {
          name           = "address";
          columnName     = "address";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "city";
          columnName     = "city";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "company";
          columnName     = "company";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "country";
          columnName     = "country";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "custom1";
          columnName     = "custom1";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "custom2";
          columnName     = "custom2";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "custom3";
          columnName     = "custom3";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "custom4";
          columnName     = "custom4";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
        },
        {
          name           = "display_phone";
          columnName     = "display_phone";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "firstname";
          columnName     = "firstname";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "lastname";
          columnName     = "lastname";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
        {
          name           = "note";
          columnName     = "note";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_address_id";
          columnName     = "palm_address_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "phone0";
          columnName     = "phone0";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "phone1";
          columnName     = "phone1";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "phone2";
          columnName     = "phone2";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "phone3";
          columnName     = "phone3";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "phone4";
          columnName     = "phone4";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "phone_label_id0";
          columnName     = "phone_label_id0";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "phone_label_id1";
          columnName     = "phone_label_id1";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "phone_label_id2";
          columnName     = "phone_label_id2";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "phone_label_id3";
          columnName     = "phone_label_id3";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "phone_label_id4";
          columnName     = "phone_label_id4";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_type";
          columnName     = "skyrix_type";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "state";
          columnName     = "state";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "zipcode";
          columnName     = "zipcode";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=palm_category table=palm_category>
      name                 = "palm_category";
      externalName         = "palm_category";
      className            = "LSPalmCategory";
      primaryKeyAttributes = ( "palm_category_id" );
      
      attributesUsedForLocking = (
        palm_category_id,
        category_index,
        md5hash,
        is_modified,
        palm_id,
        device_id,
        palm_table,
        company_id,
        category_name,
      );
      classProperties = (
        palm_category_id,
        category_index,
        md5hash,
        is_modified,
        palm_id,
        device_id,
        palm_table,
        company_id,
        category_name,
      );

      attributes = (
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "category_name";
          columnName     = "category_name";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
        {
          name           = "palm_category_id";
          columnName     = "palm_category_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_table";
          columnName     = "palm_table";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
      );
    },
    { // <entity name=palm_date table=palm_date>
      name                 = "palm_date";
      externalName         = "palm_date";
      className            = "LSPalmDate";
      primaryKeyAttributes = ( "palm_date_id" );
      
      attributesUsedForLocking = (
        skyrix_palm_version,
        repeat_start_week,
        is_alarmed,
        object_version,
        description,
        category_index,
        is_new,
        is_archived,
        md5hash,
        is_modified,
        palm_id,
        palm_date_id,
        is_untimed,
        enddate,
        skyrix_version,
        repeat_frequency,
        device_id,
        startdate,
        repeat_type,
        is_deleted,
        company_id,
        skyrix_id,
        note,
        is_private,
        exceptions,
        skyrix_sync,
        repeat_on,
        alarm_advance_unit,
        repeat_enddate,
        alarm_advance_time,
      );
      classProperties = (
        skyrix_palm_version,
        repeat_start_week,
        is_alarmed,
        object_version,
        description,
        category_index,
        is_new,
        is_archived,
        md5hash,
        is_modified,
        palm_id,
        palm_date_id,
        is_untimed,
        enddate,
        skyrix_version,
        repeat_frequency,
        device_id,
        startdate,
        repeat_type,
        is_deleted,
        company_id,
        skyrix_id,
        note,
        is_private,
        exceptions,
        skyrix_sync,
        repeat_on,
        alarm_advance_unit,
        repeat_enddate,
        alarm_advance_time,
      );

      attributes = (
        {
          name           = "alarm_advance_time";
          columnName     = "alarm_advance_time";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "alarm_advance_unit";
          columnName     = "alarm_advance_unit";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
        },
        {
          name           = "enddate";
          columnName     = "enddate";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "exceptions";
          columnName     = "exceptions";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "is_alarmed";
          columnName     = "is_alarmed";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_untimed";
          columnName     = "is_untimed";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
        {
          name           = "note";
          columnName     = "note";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_date_id";
          columnName     = "palm_date_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_enddate";
          columnName     = "repeat_enddate";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "repeat_frequency";
          columnName     = "repeat_frequency";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_on";
          columnName     = "repeat_on";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_start_week";
          columnName     = "repeat_start_week";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_type";
          columnName     = "repeat_type";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "startdate";
          columnName     = "startdate";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
      );
    },
    { // <entity name=palm_memo table=palm_memo>
      name                 = "palm_memo";
      externalName         = "palm_memo";
      className            = "LSPalmMemo";
      primaryKeyAttributes = ( "palm_memo_id" );
      
      attributesUsedForLocking = (
        skyrix_palm_version,
        object_version,
        md5hash,
        is_deleted,
        palm_memo_id,
        is_new,
        is_archived,
        category_index,
        company_id,
        palm_id,
        is_private,
        is_modified,
        skyrix_id,
        skyrix_sync,
        skyrix_version,
        memo,
        device_id,
      );
      classProperties = (
        skyrix_palm_version,
        object_version,
        md5hash,
        is_deleted,
        palm_memo_id,
        is_new,
        is_archived,
        category_index,
        company_id,
        palm_id,
        is_private,
        is_modified,
        skyrix_id,
        skyrix_sync,
        skyrix_version,
        memo,
        device_id,
      );

      attributes = (
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
        {
          name           = "memo";
          columnName     = "memo";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_memo_id";
          columnName     = "palm_memo_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=palm_todo table=palm_todo>
      name                 = "palm_todo";
      externalName         = "palm_todo";
      className            = "LSPalmToDo";
      primaryKeyAttributes = ( "palm_todo_id" );
      
      attributesUsedForLocking = (
        is_completed,
        is_new,
        palm_todo_id,
        note,
        company_id,
        skyrix_version,
        priority,
        is_archived,
        skyrix_palm_version,
        object_version,
        description,
        category_index,
        md5hash,
        is_modified,
        palm_id,
        skyrix_id,
        is_private,
        device_id,
        is_deleted,
        duedate,
        skyrix_sync,
      );
      classProperties = (
        is_completed,
        is_new,
        palm_todo_id,
        note,
        company_id,
        skyrix_version,
        priority,
        is_archived,
        skyrix_palm_version,
        object_version,
        description,
        category_index,
        md5hash,
        is_modified,
        palm_id,
        skyrix_id,
        is_private,
        device_id,
        is_deleted,
        duedate,
        skyrix_sync,
      );

      attributes = (
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "VARCHAR(255)";
          valueClassName = "NSString";
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "VARCHAR(100)";
          valueClassName = "NSString";
        },
        {
          name           = "duedate";
          columnName     = "duedate";
          externalType   = "DATE";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%Y-%m-%d %H:%M:%S";
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_completed";
          columnName     = "is_completed";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "VARCHAR(50)";
          valueClassName = "NSString";
        },
        {
          name           = "note";
          columnName     = "note";
          externalType   = "VARCHAR(4000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_todo_id";
          columnName     = "palm_todo_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "INT";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
  );
}