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

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

      attributes = (
        {
          name           = "addressId";
          columnName     = "address_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "city";
          columnName     = "zipcity";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "country";
          columnName     = "country";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "name1";
          columnName     = "name1";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name2";
          columnName     = "name2";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "name3";
          columnName     = "name3";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "state";
          columnName     = "state";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "street";
          columnName     = "street";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "type";
          columnName     = "ftype";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "zip";
          columnName     = "zip";
          externalType   = "t_tinystring";
          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 = ( appointmentResourceId, name, dbStatus );
      classProperties = (
        appointmentResourceId,
        emailSubject,
        name,
        dbStatus,
        email,
        notificationTime,
        category,
      );

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

      attributes = (
        {
          name           = "articleCategoryId";
          columnName     = "article_category_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "articleId";
          columnName     = "article_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "articleName";
          columnName     = "article_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "articleNr";
          columnName     = "article_nr";
          externalType   = "t_string";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "articleUnitId";
          columnName     = "article_unit_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "comment";
          columnName     = "article_text";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_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   = "t_tinystring";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "vat";
          columnName     = "vat";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "vatGroup";
          columnName     = "vat_group";
          externalType   = "t_tinystring";
          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 = (
        categoryName,
        articleCategoryId,
        categoryAbbrev,
      );
      classProperties = (
        categoryName,
        articleCategoryId,
        categoryAbbrev,
        toArticle,
      );

      attributes = (
        {
          name           = "articleCategoryId";
          columnName     = "article_category_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "categoryAbbrev";
          columnName     = "category_abbrev";
          externalType   = "t_string";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "categoryName";
          columnName     = "category_name";
          externalType   = "t_string";
          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 = (
        singularUnit,
        articleUnitId,
        description,
        pluralUnit,
      );
      classProperties = (
        singularUnit,
        articleUnitId,
        description,
        pluralUnit,
        toArticle,
      );

      attributes = (
        {
          name           = "articleUnitId";
          columnName     = "article_unit_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "format";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "pluralUnit";
          columnName     = "plural_unit";
          externalType   = "t_string";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "singularUnit";
          columnName     = "singular_unit";
          externalType   = "t_string";
          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 = (
        subCompanyId,
        isChief,
        companyId,
        dbStatus,
        isHeadquarter,
        companyAssignmentId,
        function,
      );
      classProperties = (
        subCompanyId,
        isChief,
        companyId,
        dbStatus,
        isHeadquarter,
        companyAssignmentId,
        function,
        toPerson,
        toEnterprise,
        toTeam,
      );

      attributes = (
        {
          name           = "companyAssignmentId";
          columnName     = "company_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "function";
          columnName     = "ffunction";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isChief";
          columnName     = "is_chief";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isHeadquarter";
          columnName     = "is_headquarter";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "subCompanyId";
          columnName     = "sub_company_id";
          externalType   = "t_id";
          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 = ( dbStatus, companyCategoryId, category );
      classProperties = ( dbStatus, companyCategoryId, category );

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

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyInfoId";
          columnName     = "company_info_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          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 = (
        companyValueId,
        isEnum,
        value,
        attribute,
        companyId,
        dbStatus,
      );
      classProperties = (
        type,
        companyValueId,
        isEnum,
        label,
        value,
        attribute,
        companyId,
        isLabelLocalized,
        uid,
        dbStatus,
        toEnterprise,
        toPerson,
        toTeam,
      );

      attributes = (
        {
          name           = "attribute";
          columnName     = "attribute";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "companyValueId";
          columnName     = "company_value_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isEnum";
          columnName     = "is_enum";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isLabelLocalized";
          columnName     = "is_label_localized";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "label";
          columnName     = "label";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "type";
          columnName     = "ftype";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "uid";
          columnName     = "uid";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "value";
          columnName     = "value_string";
          externalType   = "t_string";
          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=appointment>
      name                 = "Date";
      externalName         = "appointment";
      className            = "LSAppointment";
      primaryKeyAttributes = ( "dateId" );
      
      attributesUsedForLocking = (
        ownerId,
        dateId,
        accessTeamId,
        objectVersion,
      );
      classProperties = (
        isAttendance,
        type,
        ownerId,
        dateId,
        isConflictDisabled,
        absence,
        fbtype,
        writeAccessList,
        cycleEndDate,
        notificationTime,
        title,
        accessTeamId,
        dbStatus,
        associatedContacts,
        startDate,
        parentDateId,
        keywords,
        busyType,
        evoReminder,
        isAbsence,
        aptType,
        olReminder,
        onlineMeeting,
        objectVersion,
        calendarName,
        sensitivity,
        importance,
        lastModified,
        endDate,
        sourceUrl,
        location,
        resourceNames,
        toAccessTeam,
        toDateCompanyAssignment,
        toOwner,
        toDateInfo,
        toParentDate,
        toNote,
        toDate,
      );

      attributes = (
        {
          name           = "absence";
          columnName     = "absence";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "accessTeamId";
          columnName     = "access_team_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "aptType";
          columnName     = "apt_type";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "busyType";
          columnName     = "busy_type";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "calendarName";
          columnName     = "calendar_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "cycleEndDate";
          columnName     = "cycle_end_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "evoReminder";
          columnName     = "evo_reminder";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fbtype";
          columnName     = "fbtype";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "importance";
          columnName     = "importance";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isAbsence";
          columnName     = "is_absence";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "isAttendance";
          columnName     = "is_attendance";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isConflictDisabled";
          columnName     = "is_conflict_disabled";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "lastModified";
          columnName     = "last_modified";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "location";
          columnName     = "location";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "notificationTime";
          columnName     = "notification_time";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "olReminder";
          columnName     = "ol_reminder";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "onlineMeeting";
          columnName     = "online_meeting";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentDateId";
          columnName     = "parent_date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceNames";
          columnName     = "resource_names";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "type";
          columnName     = "ftype";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "writeAccessList";
          columnName     = "write_access_list";
          externalType   = "t_string";
          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 = (
        partStatus,
        isStaff,
        companyId,
        dateId,
        role,
        outlookKey,
        rsvp,
        dbStatus,
        dateCompanyAssignmentId,
        comment,
      );
      classProperties = (
        partStatus,
        isStaff,
        companyId,
        dateId,
        role,
        outlookKey,
        rsvp,
        dbStatus,
        dateCompanyAssignmentId,
        comment,
        toPerson,
        toDate,
        toTeam,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateCompanyAssignmentId";
          columnName     = "date_company_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isStaff";
          columnName     = "is_staff";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "outlookKey";
          columnName     = "outlook_key";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "partStatus";
          columnName     = "partstatus";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "role";
          columnName     = "role";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "rsvp";
          columnName     = "rsvp";
          externalType   = "t_bool";
          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 = ( dateInfoId, dateId, dbStatus, comment );
      classProperties = ( dateInfoId, dateId, dbStatus, comment, toDate );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(100000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateInfoId";
          columnName     = "date_info_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          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 = (
        currentOwnerId,
        isNote,
        dateId,
        contact,
        versionCount,
        fileType,
        projectId,
        title,
        parentDocumentId,
        objectLink,
        isObjectLink,
        dbStatus,
        creationDate,
        documentId,
        fileSize,
        firstOwnerId,
        isFolder,
        abstract,
        lastmodifiedDate,
        isIndexDoc,
        status,
      );
      classProperties = (
        currentOwnerId,
        isNote,
        dateId,
        contact,
        versionCount,
        fileType,
        projectId,
        title,
        parentDocumentId,
        objectLink,
        isObjectLink,
        dbStatus,
        creationDate,
        documentId,
        fileSize,
        firstOwnerId,
        isFolder,
        abstract,
        lastmodifiedDate,
        isIndexDoc,
        status,
        toProject,
        toDoc,
        toDocumentEditing,
        toDate,
        toFirstOwner,
        toNote,
        toParentDocument,
        toCurrentOwner,
        toDocumentVersion,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "firstOwnerId";
          columnName     = "first_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isFolder";
          columnName     = "is_folder";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isIndexDoc";
          columnName     = "is_index_doc";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isNote";
          columnName     = "is_note";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isObjectLink";
          columnName     = "is_object_link";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "lastmodifiedDate";
          columnName     = "lastmodified_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "objectLink";
          columnName     = "object_link";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "parentDocumentId";
          columnName     = "parent_document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "versionCount";
          columnName     = "version_count";
          externalType   = "t_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 = (
        currentOwnerId,
        dbStatus,
        documentEditingId,
        documentId,
        fileSize,
        contact,
        version,
        fileType,
        abstract,
        isAttachChanged,
        title,
        checkoutDate,
        status,
      );
      classProperties = (
        currentOwnerId,
        dbStatus,
        documentEditingId,
        documentId,
        fileSize,
        contact,
        version,
        fileType,
        abstract,
        isAttachChanged,
        title,
        checkoutDate,
        status,
        toDoc,
        toCurrentOwner,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "checkoutDate";
          columnName     = "checkout_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentEditingId";
          columnName     = "document_editing_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isAttachChanged";
          columnName     = "is_attach_changed";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "version";
          columnName     = "version";
          externalType   = "t_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 = (
        archiveDate,
        creationDate,
        documentId,
        isPacked,
        fileSize,
        version,
        fileType,
        documentVersionId,
        abstract,
        title,
        contact,
        dbStatus,
        lastOwnerId,
      );
      classProperties = (
        archiveDate,
        creationDate,
        documentId,
        isPacked,
        fileSize,
        version,
        fileType,
        documentVersionId,
        abstract,
        title,
        contact,
        dbStatus,
        lastOwnerId,
        toDoc,
        toLastOwner,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "archiveDate";
          columnName     = "archive_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "contact";
          columnName     = "contact";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "documentVersionId";
          columnName     = "document_version_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileSize";
          columnName     = "file_size";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isPacked";
          columnName     = "is_packed";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "lastOwnerId";
          columnName     = "last_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "version";
          columnName     = "version";
          externalType   = "t_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, objectVersion, companyId );
      classProperties = (
        dirServer,
        isCustomer,
        ownerId,
        imAddress,
        sensitivity,
        associatedCompany,
        department,
        url,
        showEmail3As,
        associatedCategories,
        showEmail2As,
        bank,
        dbStatus,
        nameTitle,
        bankCode,
        sourceUrl,
        emailAlias,
        birthday,
        freebusyUrl,
        objectVersion,
        firstname,
        description,
        associatedContacts,
        office,
        email,
        isPrivate,
        priority,
        anniversary,
        fileas,
        companyId,
        nameAffix,
        occupation,
        keywords,
        login,
        account,
        contactId,
        number,
        assistantName,
        bossName,
        isEnterprise,
        isReadonly,
        showEmailAs,
        partnerName,
        toContact,
        toInvoice,
        toCompanyValue,
        toTelephone,
        toOwner,
        toCompanyAssignment1,
        toDateCompanyAssignment,
        toAddress,
        toProjectCompanyAssignment,
        toStaff,
        toCompanyInfo,
        toCompanyAssignment,
      );

      attributes = (
        {
          name           = "account";
          columnName     = "account";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "bank";
          columnName     = "bank";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "bankCode";
          columnName     = "bank_code";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "birthday";
          columnName     = "birthday";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "firstname";
          columnName     = "firstname";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isCustomer";
          columnName     = "is_customer";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isEnterprise";
          columnName     = "is_enterprise";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "showEmail2As";
          columnName     = "show_email2_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmail3As";
          columnName     = "show_email3_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmailAs";
          columnName     = "show_email_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "t_string";
          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        = "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 = ( objectVersion, status, invoiceId );
      classProperties = (
        netAmount,
        objectVersion,
        paid,
        invoiceNr,
        debitorId,
        status,
        invoiceDate,
        parentInvoiceId,
        dbStatus,
        invoiceId,
        kind,
        grossAmount,
        comment,
        toInvoiceArticleAssignment,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "debitorId";
          columnName     = "debitor_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
        },
        {
          name           = "grossAmount";
          columnName     = "gross_amount";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "invoiceDate";
          columnName     = "invoice_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "invoiceNr";
          columnName     = "invoice_nr";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "t_smallstring";
          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   = "t_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   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "t_smallstring";
          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 = (
        invoiceAccountId,
        companyId,
        objectVersion,
      );
      classProperties = (
        balance,
        invoiceAccountId,
        accountNr,
        companyId,
        dbStatus,
        objectVersion,
        toEnterprise,
      );

      attributes = (
        {
          name           = "accountNr";
          columnName     = "account_nr";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          width          = 50;
        },
        {
          name           = "balance";
          columnName     = "balance";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "companyId";
          columnName     = "enterprise_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "invoiceAccountId";
          columnName     = "invoice_account_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_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 = (
        invoiceAccountingId,
        actionId,
        dbStatus,
        objectVersion,
      );
      classProperties = (
        invoiceAccountingId,
        balance,
        debit,
        actionId,
        dbStatus,
        objectVersion,
        toInvoiceAction,
      );

      attributes = (
        {
          name           = "actionId";
          columnName     = "action_id";
          externalType   = "t_id";
          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   = "t_tinystring";
          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   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_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 = (
        accountId,
        documentId,
        invoiceActionId,
        objectVersion,
        dbStatus,
        invoiceId,
      );
      classProperties = (
        accountId,
        documentId,
        invoiceActionId,
        objectVersion,
        logText,
        dbStatus,
        invoiceId,
        kind,
        actionDate,
        toInvoice,
        toInvoiceAccount,
        toDocument,
      );

      attributes = (
        {
          name           = "accountId";
          columnName     = "account_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "actionDate";
          columnName     = "action_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "invoiceActionId";
          columnName     = "invoice_action_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "kind";
          columnName     = "action_kind";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "logText";
          columnName     = "log_text";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_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 = (
        invoiceArticleAssignmentId,
        objectVersion,
      );
      classProperties = (
        netAmount,
        invoiceArticleAssignmentId,
        articleId,
        articleCount,
        objectVersion,
        vat,
        dbStatus,
        invoiceId,
        comment,
        toInvoice,
        toArticle,
      );

      attributes = (
        {
          name           = "articleCount";
          columnName     = "article_count";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
        },
        {
          name           = "articleId";
          columnName     = "article_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "invoiceArticleAssignmentId";
          columnName     = "invoice_article_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "invoiceId";
          columnName     = "invoice_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "netAmount";
          columnName     = "net_amount";
          externalType   = "t_double";
          valueClassName = "NSNumber";
          valueType      = d;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_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 = (
        executantId,
        creatorId,
        accountingInfo,
        isTeamJob,
        actualWork,
        priority,
        jobStatus,
        projectId,
        name,
        dbStatus,
        kind,
        parentJobId,
        category,
        completionDate,
        keywords,
        kilometers,
        timerDate,
        notify,
        lastModified,
        isControlJob,
        jobId,
        objectVersion,
        associatedCompanies,
        sensitivity,
        associatedContacts,
        percentComplete,
        totalWork,
        endDate,
        sourceUrl,
        startDate,
        comment,
        toCreator,
        toResourceAssignment,
        toProject,
        toChildJobAssignment,
        toExecutant,
        toJob,
        toParentJob,
        toParentJobAssignment,
        toJobHistory,
      );

      attributes = (
        {
          name           = "accountingInfo";
          columnName     = "accounting_info";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "actualWork";
          columnName     = "actual_work";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "associatedCompanies";
          columnName     = "associated_companies";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "category";
          columnName     = "category";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "comment";
          columnName     = "job_comment";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 8000;
        },
        {
          name           = "completionDate";
          columnName     = "completion_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "creatorId";
          columnName     = "creator_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "executantId";
          columnName     = "executant_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isControlJob";
          columnName     = "is_control_job";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeamJob";
          columnName     = "is_team_job";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "jobStatus";
          columnName     = "job_status";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "kilometers";
          columnName     = "kilometers";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "lastModified";
          columnName     = "last_modified";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "name";
          columnName     = "fname";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "notify";
          columnName     = "notify";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentJobId";
          columnName     = "parent_job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "percentComplete";
          columnName     = "percent_complete";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "timerDate";
          columnName     = "timer_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "totalWork";
          columnName     = "total_work";
          externalType   = "t_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        = "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 = (
        childJobId,
        dbStatus,
        jobAssignmentId,
        parentJobId,
      );
      classProperties = (
        childJobId,
        assignmentKind,
        dbStatus,
        position,
        jobAssignmentId,
        parentJobId,
        toChildJob,
        toParentJob,
      );

      attributes = (
        {
          name           = "assignmentKind";
          columnName     = "assignment_kind";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "childJobId";
          columnName     = "child_job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobAssignmentId";
          columnName     = "job_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "parentJobId";
          columnName     = "parent_job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "position";
          columnName     = "fposition";
          externalType   = "t_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 = (
        actorId,
        action,
        actionDate,
        jobId,
        jobStatus,
        dbStatus,
        jobHistoryId,
      );
      classProperties = (
        actorId,
        action,
        actionDate,
        jobId,
        jobStatus,
        dbStatus,
        jobHistoryId,
        toActor,
        toJobHistoryInfo,
        toJob,
      );

      attributes = (
        {
          name           = "action";
          columnName     = "faction";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "actionDate";
          columnName     = "action_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "actorId";
          columnName     = "actor_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobHistoryId";
          columnName     = "job_history_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobStatus";
          columnName     = "job_status";
          externalType   = "t_tinystring";
          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 = (
        jobHistoryInfoId,
        dbStatus,
        comment,
        jobHistoryId,
      );
      classProperties = (
        jobHistoryInfoId,
        dbStatus,
        comment,
        jobHistoryId,
        toJobHistory,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "VARCHAR(1000000)";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobHistoryId";
          columnName     = "job_history_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "jobHistoryInfoId";
          columnName     = "job_history_info_id";
          externalType   = "t_id";
          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 = (
        jobId,
        jobResourceAssignmentId,
        resourceId,
        operativePart,
        dbStatus,
      );
      classProperties = (
        jobId,
        jobResourceAssignmentId,
        resourceId,
        operativePart,
        dbStatus,
        toResource,
        toJob,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "jobId";
          columnName     = "job_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "jobResourceAssignmentId";
          columnName     = "job_resource_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "operativePart";
          columnName     = "operative_part";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceId";
          columnName     = "resource_id";
          externalType   = "t_id";
          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 = (
        accountId,
        creationDate,
        action,
        objectId,
        logText,
        logId,
      );

      attributes = (
        {
          name           = "accountId";
          columnName     = "account_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "action";
          columnName     = "faction";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "logId";
          columnName     = "log_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "logText";
          columnName     = "log_text";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectId";
          columnName     = "object_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
    { // <entity name=NewsArticle table=news_article>
      name                 = "NewsArticle";
      externalName         = "news_article";
      className            = "LSNewsArticle";
      primaryKeyAttributes = ( "newsArticleId" );
      
      attributesUsedForLocking = (
        dbStatus,
        name,
        isIndexArticle,
        newsArticleId,
        caption,
      );
      classProperties = (
        dbStatus,
        name,
        isIndexArticle,
        newsArticleId,
        caption,
        toNewsArticleLink1,
        toNewsArticleLink,
      );

      attributes = (
        {
          name           = "caption";
          columnName     = "caption";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isIndexArticle";
          columnName     = "is_index_article";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "name";
          columnName     = "fname";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "newsArticleId";
          columnName     = "news_article_id";
          externalType   = "t_id";
          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,
        toSubNewsArticle,
        toNewsArticle,
      );

      attributes = (
        {
          name           = "newsArticleId";
          columnName     = "news_article_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "newsArticleLinkId";
          columnName     = "news_article_link_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "subNewsArticleId";
          columnName     = "sub_news_article_id";
          externalType   = "t_id";
          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 = (
        currentOwnerId,
        isNote,
        dateId,
        fileType,
        projectId,
        title,
        parentDocumentId,
        dbStatus,
        creationDate,
        documentId,
        versionCount,
        isFolder,
        abstract,
        firstOwnerId,
        status,
      );
      classProperties = (
        currentOwnerId,
        isNote,
        dateId,
        fileType,
        projectId,
        title,
        parentDocumentId,
        dbStatus,
        creationDate,
        documentId,
        versionCount,
        isFolder,
        abstract,
        firstOwnerId,
        status,
        toProject,
        toDocumentVersion,
        toCurrentOwner,
        toDate,
        toDocument,
        toFirstOwner,
        toParentDocument,
      );

      attributes = (
        {
          name           = "abstract";
          columnName     = "abstract";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "creationDate";
          columnName     = "creation_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "currentOwnerId";
          columnName     = "current_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dateId";
          columnName     = "date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "documentId";
          columnName     = "document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "fileType";
          columnName     = "file_type";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "firstOwnerId";
          columnName     = "first_owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isFolder";
          columnName     = "is_folder";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isNote";
          columnName     = "is_note";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "parentDocumentId";
          columnName     = "parent_document_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "title";
          columnName     = "title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "versionCount";
          columnName     = "version_count";
          externalType   = "t_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        = "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        = "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 = (
        permissions,
        sortKey,
        action,
        authId,
        objectId,
        objectAclId,
      );

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

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

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

      attributes = (
        {
          name           = "accessKey";
          columnName     = "access_key";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "blobSize";
          columnName     = "blob_size";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          allowsNull     = Y;
        },
        {
          name           = "key";
          columnName     = "value_key";
          externalType   = "t_string";
          valueClassName = "NSString";
        },
        {
          name           = "namespacePrefix";
          columnName     = "namespace_prefix";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "objectId";
          columnName     = "obj_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectPropertyId";
          columnName     = "obj_property_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "objectType";
          columnName     = "obj_type";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "preferredType";
          columnName     = "preferred_type";
          externalType   = "t_string";
          valueClassName = "NSString";
        },
        {
          name           = "valueBlob";
          columnName     = "value_blob";
          externalType   = "t_image";
          valueClassName = "NSData";
          allowsNull     = Y;
        },
        {
          name           = "valueDate";
          columnName     = "value_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "valueFloat";
          columnName     = "value_float";
          externalType   = "t_float";
          valueClassName = "NSNumber";
          valueType      = f;
          allowsNull     = Y;
        },
        {
          name           = "valueInt";
          columnName     = "value_int";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "valueOID";
          columnName     = "value_oid";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "valueString";
          columnName     = "value_string";
          externalType   = "VARCHAR(2000000)";
          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 = (
        ownerId,
        dbStatus,
        objectVersion,
        companyId,
      );
      classProperties = (
        dirServer,
        isCustomer,
        ownerId,
        imAddress,
        sensitivity,
        associatedCompany,
        department,
        url,
        name,
        dbStatus,
        associatedCategories,
        showEmail2As,
        password,
        showEmailAs,
        emailAlias,
        birthday,
        freebusyUrl,
        objectVersion,
        associatedContacts,
        description,
        middlename,
        firstname,
        degree,
        imapPasswd,
        sourceUrl,
        partnerName,
        showEmail3As,
        isPrivate,
        isPerson,
        isExtraAccount,
        isAccount,
        isLocked,
        priority,
        anniversary,
        fileas,
        companyId,
        templateUserId,
        nameAffix,
        occupation,
        isIntraAccount,
        isTemplateUser,
        keywords,
        login,
        contactId,
        sex,
        number,
        assistantName,
        bossName,
        nameTitle,
        isReadonly,
        office,
        salutation,
        toContact,
        toCompanyValue,
        toTelephone,
        toCompanyAssignment1,
        toCompanyInfo,
        toProjectCompanyAssignment,
        toDateCompanyAssignment,
        toOwner,
        toAddress,
        toStaff,
        toCompanyAssignment,
      );

      attributes = (
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "birthday";
          columnName     = "birthday";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "degree";
          columnName     = "degree";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "firstname";
          columnName     = "firstname";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imapPasswd";
          columnName     = "pop3_account";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "isAccount";
          columnName     = "is_account";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isCustomer";
          columnName     = "is_customer";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isExtraAccount";
          columnName     = "is_extra_account";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isIntraAccount";
          columnName     = "is_intra_account";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isLocked";
          columnName     = "is_locked";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPerson";
          columnName     = "is_person";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTemplateUser";
          columnName     = "is_template_user";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "middlename";
          columnName     = "middlename";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "name";
          columnName     = "fname";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "password";
          columnName     = "password";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "salutation";
          columnName     = "salutation";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "sex";
          columnName     = "sex";
          externalType   = "t_tinieststring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 10;
        },
        {
          name           = "showEmail2As";
          columnName     = "show_email2_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmail3As";
          columnName     = "show_email3_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "showEmailAs";
          columnName     = "show_email_as";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sourceUrl";
          columnName     = "source_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "templateUserId";
          columnName     = "template_user_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "t_string";
          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        = "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,
        dbStatus,
        ownerId,
        teamId,
        isFake,
        projectId,
        name,
        endDate,
        number,
        status,
      );
      classProperties = (
        startDate,
        dbStatus,
        ownerId,
        teamId,
        isFake,
        projectId,
        url,
        name,
        endDate,
        kind,
        number,
        status,
        toOwner,
        toDocument,
        toStaffTeam,
        toProjectInfo,
        toProjectCompanyAssignment,
        toJob,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "endDate";
          columnName     = "end_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "isFake";
          columnName     = "is_fake";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "kind";
          columnName     = "kind";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "name";
          columnName     = "fname";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "startDate";
          columnName     = "start_date";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "status";
          columnName     = "status";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "teamId";
          columnName     = "team_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "t_smallstring";
          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        = "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 = (
        projectCompanyAssignmentId,
        companyId,
        projectId,
        dbStatus,
      );
      classProperties = (
        accessRight,
        projectCompanyAssignmentId,
        companyId,
        projectId,
        hasAccess,
        dbStatus,
        info,
        toProject,
        toPerson,
      );

      attributes = (
        {
          name           = "accessRight";
          columnName     = "access_right";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "hasAccess";
          columnName     = "has_access";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "info";
          columnName     = "info";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "projectCompanyAssignmentId";
          columnName     = "project_company_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          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 = ( projectInfoId, projectId, dbStatus );
      classProperties = (
        projectInfoId,
        projectId,
        dbStatus,
        comment,
        toProject,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "projectId";
          columnName     = "project_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "projectInfoId";
          columnName     = "project_info_id";
          externalType   = "t_id";
          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 = ( objectVersion, resourceId, standardCosts );
      classProperties = (
        quantity,
        type,
        resourceName,
        dbStatus,
        token,
        objectVersion,
        resourceId,
        standardCosts,
        objectId,
        comment,
        toSubResourceAssignment,
      );

      attributes = (
        {
          name           = "comment";
          columnName     = "comment";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "objectId";
          columnName     = "object_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "quantity";
          columnName     = "quantity";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "resourceId";
          columnName     = "resource_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "resourceName";
          columnName     = "resource_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          width          = 255;
        },
        {
          name           = "standardCosts";
          columnName     = "standard_costs";
          externalType   = "t_price";
          valueClassName = "NSNumber";
          valueType      = f;
          allowsNull     = Y;
        },
        {
          name           = "token";
          columnName     = "token";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "type";
          columnName     = "ftype";
          externalType   = "t_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 = (
        resourceAssignmentId,
        dbStatus,
        superResourceId,
        subResourceId,
      );
      classProperties = (
        resourceAssignmentId,
        dbStatus,
        superResourceId,
        subResourceId,
        toSubResource,
        toSuperResource,
      );

      attributes = (
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "resourceAssignmentId";
          columnName     = "resource_assignment_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "subResourceId";
          columnName     = "sub_resource_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "superResourceId";
          columnName     = "super_resource_id";
          externalType   = "t_id";
          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 = ( accountId, sessionLogId, action, logDate );

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

      attributes = (
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isAccount";
          columnName     = "is_account";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeam";
          columnName     = "is_team";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "staffId";
          columnName     = "staff_id";
          externalType   = "t_id";
          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 = "creatorId";
            joinSemantic         = EOInnerJoin;
            joinOperator         = EOJoinEqualTo;
          });
          isToMany       = Y;
        },
        {
          name        = "toJob1";
          destination = "Job";
          joins       = ( {
            sourceAttribute      = "companyId";
            destinationAttribute = "executantId";
            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 = ( ownerId, objectVersion, companyId );
      classProperties = (
        dirServer,
        login,
        ownerId,
        imAddress,
        associatedCategories,
        sensitivity,
        associatedCompany,
        dbStatus,
        emailAlias,
        isTeam,
        freebusyUrl,
        objectVersion,
        description,
        associatedContacts,
        partnerName,
        email,
        department,
        anniversary,
        fileas,
        companyId,
        nameAffix,
        occupation,
        contactId,
        number,
        assistantName,
        bossName,
        nameTitle,
        office,
        isLocationTeam,
        toContact,
        toCompanyValue,
        toAddress,
        toTelephone,
        toCompanyInfo,
        toOwner,
        toCompanyAssignment1,
        toDateCompanyAssignment,
        toProjectCompanyAssignment,
        toDate,
        toStaff,
        toCompanyAssignment,
      );

      attributes = (
        {
          name           = "anniversary";
          columnName     = "anniversary";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "assistantName";
          columnName     = "assistant_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCategories";
          columnName     = "associated_categories";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedCompany";
          columnName     = "associated_company";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "associatedContacts";
          columnName     = "associated_contacts";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "bossName";
          columnName     = "boss_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "department";
          columnName     = "department";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "dirServer";
          columnName     = "dir_server";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "emailAlias";
          columnName     = "email_alias";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "fileas";
          columnName     = "fileas";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "freebusyUrl";
          columnName     = "freebusy_url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "imAddress";
          columnName     = "im_address";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "isLocationTeam";
          columnName     = "is_location_team";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTeam";
          columnName     = "is_team";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "login";
          columnName     = "login";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameAffix";
          columnName     = "name_affix";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "nameTitle";
          columnName     = "name_title";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "objectVersion";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "occupation";
          columnName     = "occupation";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "office";
          columnName     = "office";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "partnerName";
          columnName     = "partner_name";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "sensitivity";
          columnName     = "sensitivity";
          externalType   = "t_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 = (
        type,
        number,
        url,
        companyId,
        realNumber,
        dbStatus,
        telephoneId,
        info,
      );
      classProperties = (
        type,
        number,
        url,
        companyId,
        realNumber,
        dbStatus,
        telephoneId,
        info,
        toPerson,
        toEnterprise,
        toTeam,
      );

      attributes = (
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "info";
          columnName     = "info";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "realNumber";
          columnName     = "real_number";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "telephoneId";
          columnName     = "telephone_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "type";
          columnName     = "ftype";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "t_string";
          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=Trust table=trust>
      name                 = "Trust";
      externalName         = "trust";
      className            = "LSTrust";
      primaryKeyAttributes = ( "companyId" );
      
      attributesUsedForLocking = (
        email,
        ownerId,
        keywords,
        contactId,
        isTrust,
        priority,
        isReadonly,
        number,
        isPrivate,
        url,
        companyId,
        description,
        dbStatus,
      );
      classProperties = (
        email,
        ownerId,
        keywords,
        contactId,
        isTrust,
        priority,
        isReadonly,
        number,
        isPrivate,
        url,
        companyId,
        description,
        dbStatus,
      );

      attributes = (
        {
          name           = "companyId";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "contactId";
          columnName     = "contact_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "dbStatus";
          columnName     = "db_status";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "email";
          columnName     = "email";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "isPrivate";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isReadonly";
          columnName     = "is_readonly";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "isTrust";
          columnName     = "is_trust";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "keywords";
          columnName     = "keywords";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
        {
          name           = "number";
          columnName     = "fnumber";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 100;
        },
        {
          name           = "ownerId";
          columnName     = "owner_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 50;
        },
        {
          name           = "url";
          columnName     = "url";
          externalType   = "t_string";
          valueClassName = "NSString";
          allowsNull     = Y;
          width          = 255;
        },
      );
    },
    { // <entity name=palm_address table=palm_address>
      name                 = "palm_address";
      externalName         = "palm_address";
      className            = "LSPalmAddress";
      primaryKeyAttributes = ( "palm_address_id" );
      
      attributesUsedForLocking = (
        skyrix_sync,
        palm_address_id,
        country,
        company,
        is_deleted,
        device_id,
        is_private,
        skyrix_id,
        address,
        zipcode,
        palm_id,
        phone4,
        is_modified,
        phone1,
        phone0,
        lastname,
        phone2,
        category_index,
        firstname,
        object_version,
        skyrix_palm_version,
        md5hash,
        state,
        note,
        skyrix_version,
        company_id,
        title,
        phone3,
        city,
        phone_label_id4,
        phone_label_id3,
        phone_label_id2,
        phone_label_id1,
        phone_label_id0,
        display_phone,
        is_new,
        skyrix_type,
        custom3,
        custom2,
        custom1,
        is_archived,
        custom4,
      );
      classProperties = (
        skyrix_sync,
        palm_address_id,
        country,
        company,
        is_deleted,
        device_id,
        is_private,
        skyrix_id,
        address,
        zipcode,
        palm_id,
        phone4,
        is_modified,
        phone1,
        phone0,
        lastname,
        phone2,
        category_index,
        firstname,
        object_version,
        skyrix_palm_version,
        md5hash,
        state,
        note,
        skyrix_version,
        company_id,
        title,
        phone3,
        city,
        phone_label_id4,
        phone_label_id3,
        phone_label_id2,
        phone_label_id1,
        phone_label_id0,
        display_phone,
        is_new,
        skyrix_type,
        custom3,
        custom2,
        custom1,
        is_archived,
        custom4,
      );

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

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

      attributes = (
        {
          name           = "alarm_advance_time";
          columnName     = "alarm_advance_time";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "alarm_advance_unit";
          columnName     = "alarm_advance_unit";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
        },
        {
          name           = "enddate";
          columnName     = "enddate";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "exceptions";
          columnName     = "exceptions";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "is_alarmed";
          columnName     = "is_alarmed";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_untimed";
          columnName     = "is_untimed";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
        },
        {
          name           = "note";
          columnName     = "note";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_date_id";
          columnName     = "palm_date_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_enddate";
          columnName     = "repeat_enddate";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "repeat_frequency";
          columnName     = "repeat_frequency";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_on";
          columnName     = "repeat_on";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_start_week";
          columnName     = "repeat_start_week";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "repeat_type";
          columnName     = "repeat_type";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "startdate";
          columnName     = "startdate";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
      );
    },
    { // <entity name=palm_memo table=palm_memo>
      name                 = "palm_memo";
      externalName         = "palm_memo";
      className            = "LSPalmMemo";
      primaryKeyAttributes = ( "palm_memo_id" );
      
      attributesUsedForLocking = (
        device_id,
        skyrix_id,
        skyrix_sync,
        palm_memo_id,
        memo,
        is_new,
        palm_id,
        company_id,
        md5hash,
        is_archived,
        is_modified,
        category_index,
        skyrix_version,
        is_deleted,
        object_version,
        skyrix_palm_version,
        is_private,
      );
      classProperties = (
        device_id,
        skyrix_id,
        skyrix_sync,
        palm_memo_id,
        memo,
        is_new,
        palm_id,
        company_id,
        md5hash,
        is_archived,
        is_modified,
        category_index,
        skyrix_version,
        is_deleted,
        object_version,
        skyrix_palm_version,
        is_private,
      );

      attributes = (
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
        },
        {
          name           = "memo";
          columnName     = "memo";
          externalType   = "t_text";
          valueClassName = "NSString";
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_memo_id";
          columnName     = "palm_memo_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "t_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,
        duedate,
        skyrix_sync,
        note,
        skyrix_version,
        company_id,
        is_modified,
        is_deleted,
        device_id,
        palm_todo_id,
        palm_id,
        is_new,
        md5hash,
        is_archived,
        is_private,
        category_index,
        skyrix_id,
        description,
        priority,
        object_version,
        skyrix_palm_version,
      );
      classProperties = (
        is_completed,
        duedate,
        skyrix_sync,
        note,
        skyrix_version,
        company_id,
        is_modified,
        is_deleted,
        device_id,
        palm_todo_id,
        palm_id,
        is_new,
        md5hash,
        is_archived,
        is_private,
        category_index,
        skyrix_id,
        description,
        priority,
        object_version,
        skyrix_palm_version,
      );

      attributes = (
        {
          name           = "category_index";
          columnName     = "category_index";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "company_id";
          columnName     = "company_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "description";
          columnName     = "description";
          externalType   = "t_string";
          valueClassName = "NSString";
        },
        {
          name           = "device_id";
          columnName     = "device_id";
          externalType   = "t_smallstring";
          valueClassName = "NSString";
        },
        {
          name           = "duedate";
          columnName     = "duedate";
          externalType   = "t_datetime";
          valueClassName = "NSCalendarDate";
          allowsNull     = Y;
          calendarFormat = "%b %d %Y %I:%M:%S:000%p";
        },
        {
          name           = "is_archived";
          columnName     = "is_archived";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_completed";
          columnName     = "is_completed";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_deleted";
          columnName     = "is_deleted";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_modified";
          columnName     = "is_modified";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_new";
          columnName     = "is_new";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "is_private";
          columnName     = "is_private";
          externalType   = "t_bool";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "md5hash";
          columnName     = "md5hash";
          externalType   = "t_tinystring";
          valueClassName = "NSString";
        },
        {
          name           = "note";
          columnName     = "note";
          externalType   = "t_text";
          valueClassName = "NSString";
          allowsNull     = Y;
        },
        {
          name           = "object_version";
          columnName     = "object_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_id";
          columnName     = "palm_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "palm_todo_id";
          columnName     = "palm_todo_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "priority";
          columnName     = "priority";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
        },
        {
          name           = "skyrix_id";
          columnName     = "skyrix_id";
          externalType   = "t_id";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_palm_version";
          columnName     = "skyrix_palm_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_sync";
          columnName     = "skyrix_sync";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
        {
          name           = "skyrix_version";
          columnName     = "skyrix_version";
          externalType   = "t_int";
          valueClassName = "NSNumber";
          valueType      = i;
          allowsNull     = Y;
        },
      );
    },
  );
}