{ // 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 = (
        city,
        sourceUrl,
        dbStatus,
        zip,
        addressId,
        companyId,
        country,
        state,
        street,
        name2,
        name3,
        name1,
        type,
      );
      classProperties = (
        city,
        sourceUrl,
        dbStatus,
        zip,
        addressId,
        companyId,
        country,
        state,
        street,
        name2,
        name3,
        name1,
        type,
        toTeam,
        toPerson,
        toEnterprise,
      );

      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 = ( dbStatus, name, appointmentResourceId );
      classProperties = (
        category,
        dbStatus,
        name,
        appointmentResourceId,
        notificationTime,
        emailSubject,
        email,
      );

      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 = (
        articleName,
        objectVersion,
        articleNr,
        vatGroup,
        articleId,
      );
      classProperties = (
        articleName,
        status,
        articleCategoryId,
        objectVersion,
        articleNr,
        price,
        comment,
        vatGroup,
        articleId,
        vat,
        articleUnitId,
        dbStatus,
        toArticleCategory,
        toArticleUnit,
        toInvoiceArticleAssignment,
      );

      attributes = (
        {
          name           = "articleCategoryId";
          columnName     = "article_category_id";
          externalType   = "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 = (
        articleCategoryId,
        categoryName,
        categoryAbbrev,
      );
      classProperties = (
        articleCategoryId,
        categoryName,
        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 = (
        pluralUnit,
        description,
        singularUnit,
        articleUnitId,
      );
      classProperties = (
        pluralUnit,
        description,
        singularUnit,
        articleUnitId,
        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 = (
        function,
        companyAssignmentId,
        isHeadquarter,
        dbStatus,
        companyId,
        subCompanyId,
        isChief,
      );
      classProperties = (
        function,
        companyAssignmentId,
        isHeadquarter,
        dbStatus,
        companyId,
        subCompanyId,
        isChief,
        toEnterprise,
        toPerson,
        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 = ( category, companyCategoryId, dbStatus );
      classProperties = ( category, companyCategoryId, dbStatus );

      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 = (
        comment,
        dbStatus,
        companyId,
        companyInfoId,
      );
      classProperties = (
        comment,
        dbStatus,
        companyId,
        companyInfoId,
        toEnterprise,
        toPerson,
        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 = (
        dbStatus,
        companyId,
        attribute,
        value,
        isEnum,
        companyValueId,
      );
      classProperties = (
        dbStatus,
        uid,
        companyId,
        attribute,
        value,
        label,
        isEnum,
        isLabelLocalized,
        companyValueId,
        type,
        toEnterprise,
        toTeam,
        toPerson,
      );

      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 = (
        dateId,
        objectVersion,
        accessTeamId,
        ownerId,
      );
      classProperties = (
        startDate,
        endDate,
        resourceNames,
        sensitivity,
        olReminder,
        associatedContacts,
        evoReminder,
        keywords,
        notificationTime,
        parentDateId,
        title,
        cycleEndDate,
        writeAccessList,
        absence,
        isConflictDisabled,
        location,
        type,
        dateId,
        sourceUrl,
        importance,
        calendarName,
        objectVersion,
        onlineMeeting,
        aptType,
        isAbsence,
        busyType,
        dbStatus,
        accessTeamId,
        lastModified,
        fbtype,
        ownerId,
        isAttendance,
        toOwner,
        toAccessTeam,
        toParentDate,
        toDateInfo,
        toDate,
        toDateCompanyAssignment,
        toNote,
      );

      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          = 255;
        },
        {
          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 = (
        comment,
        dateCompanyAssignmentId,
        dbStatus,
        companyId,
        outlookKey,
        role,
        isStaff,
        rsvp,
        partStatus,
        dateId,
      );
      classProperties = (
        comment,
        dateCompanyAssignmentId,
        dbStatus,
        companyId,
        outlookKey,
        role,
        isStaff,
        rsvp,
        partStatus,
        dateId,
        toDate,
        toTeam,
        toPerson,
      );

      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 = ( comment, dbStatus, dateId, dateInfoId );
      classProperties = ( comment, dbStatus, dateId, dateInfoId, 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 = (
        isIndexDoc,
        abstract,
        isFolder,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        firstOwnerId,
        fileSize,
        creationDate,
        isObjectLink,
        documentId,
        objectLink,
        dbStatus,
        lastmodifiedDate,
        contact,
        isNote,
      );
      classProperties = (
        isIndexDoc,
        abstract,
        isFolder,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        firstOwnerId,
        fileSize,
        creationDate,
        isObjectLink,
        documentId,
        objectLink,
        dbStatus,
        lastmodifiedDate,
        contact,
        isNote,
        toDoc,
        toParentDocument,
        toDate,
        toDocumentVersion,
        toDocumentEditing,
        toFirstOwner,
        toCurrentOwner,
        toNote,
        toProject,
      );

      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 = (
        status,
        fileType,
        checkoutDate,
        title,
        abstract,
        contact,
        version,
        isAttachChanged,
        fileSize,
        dbStatus,
        documentEditingId,
        currentOwnerId,
        documentId,
      );
      classProperties = (
        status,
        fileType,
        checkoutDate,
        title,
        abstract,
        contact,
        version,
        isAttachChanged,
        fileSize,
        dbStatus,
        documentEditingId,
        currentOwnerId,
        documentId,
        toCurrentOwner,
        toDoc,
      );

      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 = (
        fileSize,
        fileType,
        dbStatus,
        title,
        abstract,
        documentVersionId,
        contact,
        version,
        isPacked,
        creationDate,
        archiveDate,
        documentId,
        lastOwnerId,
      );
      classProperties = (
        fileSize,
        fileType,
        dbStatus,
        title,
        abstract,
        documentVersionId,
        contact,
        version,
        isPacked,
        creationDate,
        archiveDate,
        documentId,
        lastOwnerId,
        toLastOwner,
        toDoc,
      );

      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 = ( companyId, objectVersion, ownerId );
      classProperties = (
        emailAlias,
        office,
        isReadonly,
        isEnterprise,
        sensitivity,
        assistantName,
        number,
        showEmail3As,
        contactId,
        associatedContacts,
        keywords,
        occupation,
        nameAffix,
        fileas,
        showEmailAs,
        companyId,
        anniversary,
        priority,
        isPrivate,
        email,
        partnerName,
        sourceUrl,
        description,
        firstname,
        associatedCategories,
        objectVersion,
        freebusyUrl,
        department,
        birthday,
        bossName,
        bankCode,
        login,
        bank,
        showEmail2As,
        account,
        dbStatus,
        url,
        associatedCompany,
        imAddress,
        ownerId,
        isCustomer,
        nameTitle,
        dirServer,
        toCompanyAssignment,
        toStaff,
        toCompanyInfo,
        toProjectCompanyAssignment,
        toTelephone,
        toAddress,
        toOwner,
        toDateCompanyAssignment,
        toCompanyAssignment1,
        toInvoice,
        toCompanyValue,
        toContact,
      );

      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 = ( status, invoiceId, objectVersion );
      classProperties = (
        status,
        comment,
        kind,
        invoiceId,
        dbStatus,
        parentInvoiceId,
        invoiceDate,
        debitorId,
        invoiceNr,
        paid,
        objectVersion,
        grossAmount,
        netAmount,
        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 = (
        companyId,
        invoiceAccountId,
        objectVersion,
      );
      classProperties = (
        dbStatus,
        companyId,
        invoiceAccountId,
        objectVersion,
        accountNr,
        balance,
        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 = (
        objectVersion,
        dbStatus,
        invoiceAccountingId,
        actionId,
      );
      classProperties = (
        objectVersion,
        dbStatus,
        invoiceAccountingId,
        actionId,
        debit,
        balance,
        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 = (
        invoiceId,
        objectVersion,
        invoiceActionId,
        dbStatus,
        documentId,
        accountId,
      );
      classProperties = (
        actionDate,
        kind,
        invoiceId,
        logText,
        objectVersion,
        invoiceActionId,
        dbStatus,
        documentId,
        accountId,
        toDocument,
        toInvoiceAccount,
        toInvoice,
      );

      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 = (
        comment,
        invoiceId,
        dbStatus,
        invoiceArticleAssignmentId,
        objectVersion,
        articleId,
        vat,
        articleCount,
        netAmount,
        toArticle,
        toInvoice,
      );

      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 = (
        comment,
        startDate,
        endDate,
        sensitivity,
        jobId,
        associatedContacts,
        notify,
        keywords,
        category,
        projectId,
        jobStatus,
        priority,
        accountingInfo,
        completionDate,
        sourceUrl,
        isTeamJob,
        associatedCompanies,
        objectVersion,
        isControlJob,
        timerDate,
        kilometers,
        totalWork,
        parentJobId,
        kind,
        dbStatus,
        name,
        lastModified,
        percentComplete,
        actualWork,
        creatorId,
        executantId,
        toParentJobAssignment,
        toExecutant,
        toJob,
        toResourceAssignment,
        toJobHistory,
        toChildJobAssignment,
        toParentJob,
        toCreator,
        toProject,
      );

      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 = (
        parentJobId,
        dbStatus,
        jobAssignmentId,
        childJobId,
      );
      classProperties = (
        parentJobId,
        assignmentKind,
        dbStatus,
        jobAssignmentId,
        position,
        childJobId,
        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 = (
        actionDate,
        jobHistoryId,
        jobStatus,
        jobId,
        action,
        dbStatus,
        actorId,
      );
      classProperties = (
        actionDate,
        jobHistoryId,
        jobStatus,
        jobId,
        action,
        dbStatus,
        actorId,
        toJob,
        toJobHistoryInfo,
        toActor,
      );

      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 = (
        comment,
        jobHistoryId,
        jobHistoryInfoId,
        dbStatus,
      );
      classProperties = (
        comment,
        jobHistoryId,
        jobHistoryInfoId,
        dbStatus,
        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 = (
        operativePart,
        dbStatus,
        resourceId,
        jobResourceAssignmentId,
        jobId,
      );
      classProperties = (
        operativePart,
        dbStatus,
        resourceId,
        jobResourceAssignmentId,
        jobId,
        toJob,
        toResource,
      );

      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 = (
        logText,
        objectId,
        logId,
        action,
        creationDate,
        accountId,
      );

      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 = (
        isIndexArticle,
        name,
        caption,
        newsArticleId,
        dbStatus,
      );
      classProperties = (
        isIndexArticle,
        name,
        caption,
        newsArticleId,
        dbStatus,
        toNewsArticleLink,
        toNewsArticleLink1,
      );

      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,
        toNewsArticle,
        toSubNewsArticle,
      );

      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 = (
        abstract,
        isFolder,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        firstOwnerId,
        creationDate,
        documentId,
        dbStatus,
        isNote,
      );
      classProperties = (
        abstract,
        isFolder,
        parentDocumentId,
        title,
        projectId,
        fileType,
        versionCount,
        dateId,
        currentOwnerId,
        status,
        firstOwnerId,
        creationDate,
        documentId,
        dbStatus,
        isNote,
        toParentDocument,
        toDate,
        toDocument,
        toDocumentVersion,
        toFirstOwner,
        toCurrentOwner,
        toProject,
      );

      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;
          });
          isToMa