MSPECS API CHANGELOG Current database version: #174 Applied: 2020-12-16 Next version will be applied: TBD ======================================================================================================================== Version: #174 DATA STRUCTURE: queryFilters: added column - scope ADDED TABLES: providerServiceBundles providerServicesProviderServiceBundles queryFilterOrganizationUnits INFORMATION providerServiceBundles: Bundled providerServices named container queryFilters: Added column scope - sets the visibility of a saved query queryFilterOrganizationUnits: A group of organization units for which this query is visible ======================================================================================================================== Version: #173 DATA STRUCTURE: dealMarketingPlaces: added column - accessGrants marketValuations: added columns - numberOfPremises, numberOfRentApartments housingAssociations: added columns - numberOfPremises, numberOfRentApartments buyerInterestInformation: added columns - bookingFee, contributionFee, grantingFee, otherFees organizations: added columns - dataProtectionContactEmail providerServiceSubscribers: added columns - accessGrants, providerServiceAccessGrantId ADDED TABLES: providerServiceAccessGrants INFORMATION dealMarketingPlaces: accessGrants will contain grants for specific sensitive deal data marketValuations and housingAssociations: New fields that specify how many premises and rented apartments buyerInterestInformation: Added fields that contains fees the buyer have paid for new developments organizations: dataProtectionContactEmail will contain emails which will be contacted with data protection information providerServiceSubscribers: Added references to grants that will contain sensitive data providerServiceAccessGrants: Will be contain versions of access grants ======================================================================================================================== Version: #172 Internal update ======================================================================================================================== Version: #171 DATA STRUCTURE: dealMarketingPlaces: added column - isPreview ADDED TABLES: versionFiles, queryFilters, emailOutboxes, communicateSessions, communicateContacts, outgoingEmails, emailOutboxFiles, associationVersionAssociationFiles ENUMS: providerServices.type - added ENUMS_PROVIDER_SERVICE_TYPE_WEBSITE INFORMATION versionFiles: stores relationship and metadata to achieve version attachment functionality queryFilters: store graphql query specific for a usage defined in enum enumsQueryFilterType. communicateSessions: store "mailings" batches. Current state for batch defined in enumsCommunicateSessionState. communicateContacts: store contacts to send messages to from communicate flow. emailOutboxes: store email message batches about to be sent. outgoingEmails: store individual data about emails in email batches. emailOutboxFiles: store links to attached files in email batches. associationVersionAssociationFiles: stores relationship and metadata to achieve version attachment functionality providerServices.type: website providerServices will work a bit different from other marketingPlaces dealMarketingPlaces.isPreview: will be used by ENUMS_PROVIDER_SERVICE_TYPE_WEBSITE to preview an object ======================================================================================================================== Version: #170 DATA STRUCTURE: organizationUnits: added columns - zoomLevel, latitude, longitude contacts: added column - isRegisteredBrokerAtFMI buyerInterestInformation: added column - signedPreliminaryAgreement staff: added column - displayOrder, isPublic deals: added column - buyerApprovedByTennantDate easementsAndDetails: added column - isNotConfirmed marketValuations: added column - locationDescription, economicalConditionsDescription, legalConditionsDescription, environmentalAspectsDescription, basicAssessmentDescription DEFAULT DATA: accessRights: Added two more accessRights ACCESS_RIGHT_STUDENT and ACCESS_RIGHT_BROKER_OWN_DEALS INFORMATION: organizationUnits - Fields are used to store coordinates where the organizationUnit is located contacts - Bit to show if user is registered at FMI(fastighetsmäklarinspektionen) buyerInterestInformation - Bit if preliminary agreement is signed (new development) staff - displayOrder will be used to sort users on websites. isPublic will determine which users to display on website deals - buyerApprovedByTennantDate date that states when the buyer was approved by tenant easementsAndDetails - isNotConfirmed will be set on easements that can not be determined to still be valid after a LM import marketValuations - Added fields for commercial valuation accessRights - ACCESS_RIGHT_STUDENT will not have access to do as much as an assistant or broker ACCESS_RIGHT_BROKER_OWN_DEALS users with this accessRight will only be able to access deals were they are main broker ======================================================================================================================== Version: #169 ADDED TABLES: bidderStatusLog, versionDigitalSignatures, digitalSignatures DATA STRUCTURE: estates: added columns - numberOfBathrooms, numberOfToilets, swimmingPool, housingAssociationIdentifier, housingAssociationTaxationType invoiceAmounts: added column - displayOrder | modified column - amountId parkingSpaces: added column - tax ENUMS: webhome.header - added WEBHOME_HEADER_ANALYTICS_TRACKING_ID easementsAndDetails.easementType - added enum ENUMS_EASEMENTTYPE_CONTRACTUAL_RIGHTS INFORMATION: bidderStatusLog - will be used to keep track of bidder status changes estates.numberOfBathrooms, numberOfToilets, swimmingPool - Are only used for international deals estates.housingAssociationIdentifier - Will contain the identifier (organisations nummer) of the housingAssociation estates.housingAssociationTaxationType - Will contain the taxation type (Taxeringstyp) of the housingAssociation invoiceAmounts.displayOrder - Used to order the amounts in an invoice invoiceAmounts.amountId is now mandatory easementsAndDetails.easementType - Contractual rights(Avtalsrättigheter) were prevoiusly categorized under ENUMS_EASEMENTTYPE_ENROLLEDEASEMENT but will now be categorized as ENUMS_EASEMENTTYPE_CONTRACTUAL_RIGHTS versionDigitalSignatures, digitalSignatures - used to sign documents digital webhome.header - WEBHOME_HEADER_GOOGLE_ANALYTICS_TRACKING_ID will contain google analytics tracking id ======================================================================================================================== Version: #168 DATA STRUCTURE: files: added columns - extension, mimeType, fileName webhome: added column - fileId INFORMATION: files.extension - Will contain the file extension of the file files.mimeType - Will contain the mimeType of the file files.fileName - Is used to identify the file at the fileserver ======================================================================================================================== Version: #167 DATA STRUCTURE: added some mandatory fields. Read more in info. ENUMS teamRoles.role - Added ENUMS_TEAMROLES_TYPE_PREMISE_BROKER INFORMATION dealContacts: dealId and contactId is now mandatory newDevelopmentDeals: projectDealId and dealId is now mandatory teamRoles: contactId and dealId is now mandatory ======================================================================================================================== Version: #165 & #166 DATA STRUCTURE: providers: added column - isLocal providerServices: added column - isHidden files: modified columns - viewURI and thumbnailURI maxLength from 200 to 500. originalURI is now mandatory removed column - deleteURI ENUMS providerServices.publicationStatus - Replaced ENUMS_PROVIDER_SERVICE_PUBLICATION_STATUS_HIDDEN with ENUMS_PROVIDER_SERVICE_PUBLICATION_STATUS_DISABLED deals.objectStatus - Added - ENUMS_OBJECTSTATUS_TYPE_ASSIGNMENT_SIGNED INFORMATION: deals.objectStatus - ENUMS_OBJECTSTATUS_TYPE_ASSIGNMENT_SIGNED used when the assignment is singed providers.isLocal - The provider can only add services that are local to the organization providerServices.isHidden - The service will only be displayed in GUI for provider users providerServices.publicationStatus - ENUMS_PROVIDER_SERVICE_PUBLICATION_STATUS_DISABLED will disable the service files: The following columns are now readOnly - viewURI, viewResolution, thumbnailURI, thumbnailResolution, originalURI, originalResolution, fileSize, isImage, createdByUserId originalURI is mandatory in the sence that you can always expect it to be returned. It will always be populated when file is uploaded originalURI can still be sent in when uploading file. deleteURI is removed ======================================================================================================================== Version: #163 & #164 DATA STRUCTURE: estates: added columns - cashFlowAnalysisId, sharedOwnershipName, sharedOwnershipFee, sharedOwnershipFeePeriod sellers: added column - description added some mandatory fields. Read more in info. ADDED TABLES: providerServiceObjectTypes, premises, marketValuationFiles, cashFlowAnalysis, cashFlowAnalysisYears INFORMATION providerServiceObjectTypes: Used in upcoming services to mark a service for an objectType premises: Almost the same as rooms but for premises marketValuationFiles: Its now possible to print files and images with the market valuation cashFlowAnalysis: New table that holds five year calculation. Will in the future hold all cash flow fields cashFlowAnalysisYears: Holds information about a specific years cash flow calc estates: cashFlowAnalysisId points to a table which have support for five year cash flow calculation At a later date we will migrate all cashFlow fields to that table Added more fields for shared ownership, we will have a new section for shared ownership sellers: description will hold a text that is specific for that seller (contact and deal) estateOperatingCosts: estateId and amountId is now mandatory estateCashFlowAnalysisOtherCostsAmounts: estateId and amountId is now mandatory dealCashDefinitiveStatementAmounts: dealId and amountId is now mandatory buildingOperatingCosts: buildingId and amountId is now mandatory estateFarmingPurposes: estateId and farmingPurposeId is now mandatory patios: estateId is now mandatory rooms: estateId is now mandatory ======================================================================================================================== Version: #162 DATA STRUCTURE: dealMarketingPlaces: added columns - status, publishedDate, providerServiceId providers: added column - subscriberHookURL ADDED TABLES: providerServices, providerServiceSubscribers INFORMATION This db update is in preparation of our upcoming new service interface ======================================================================================================================== Version: #161 DATA STRUCTURE: estates: added columns - roomsDescriptionMultiLang, locationCommentMultiLang buildings: added column - buildYearDescription customFields: modified column - name (maxLength from 40 to 100 chars) added some mandatory fields. Read more in info. DEFAULT DATA: webhome.header - WEBHOME_HEADER_TEMPLATE_DEAL_FILTER, WEBHOME_HEADER_IMAGE_PAGE_CONTACT, WEBHOME_HEADER_PAGE_CONTACT farmingSpecifics.type - ENUM_FARMING_SPECIFICS_TYPE_CLEANING, ENUM_FARMING_SPECIFICS_TYPE_PARTIAL_SALE, ENUM_FARMING_SPECIFICS_TYPE_SUBDEVIDE, ENUM_FARMING_SPECIFICS_TYPE_AREA_FIGURE, ENUM_FARMING_SPECIFICS_TYPE_PROPERTY_BOUNDARY, ENUM_FARMING_SPECIFICS_TYPE_VIEWING, ENUM_FARMING_SPECIFICS_TYPE_ACCESS INFORMATION: farmingSpecifics: type is now mandatory | added more farming specifics webhome: added more settings that can be retrieved by website | header is now mandatory filesInContacts: fileId and contactId is now mandatory imagesInHousingAssociations: fileId and housingAssociationId is now mandatory filesInDeals: fileId and dealId is now mandatory imagesInEstates: fileId and estateId is now mandatory imagesInDeals: fileId and dealId is now mandatory ======================================================================================================================== Version: #160 ADDED TABLES: bankIdVerifications, buyerBankIdVerifications, sellerBankIdVerifications INFORMATION: bankIdVerifications, buyerBankIdVerifications and sellerBankIdVerifications will be used when verifying a buyer or seller with bankId bankIdVerifications will be per deal now, instead of once for each contact. ======================================================================================================================== Version: #159 DATA STRUCTURE: contacts: added columns - isPublished, presentation organizationUnits: added columns - isPublished, presentation deals: added columns - sellingTextSubjectMultiLang, sellingTextShortMultiLang, sellingTextMultiLang viewingBuyers: added column - attended viewingSlotBuyers: added column - attended licenseSystemSettings: added column - isHidden systemSettings: added column - isHidden INFORMATION: contacts.isPublished - Used by websites to mark which users to display. Not in use yet. contacts.presentation - Presentation of the user, displayed on websites. Not in use yet. organizationUnits.isPublished - Used by websites to mark which organizationUnits to display. Not in use yet. organizationUnits.presentation - Presentation of the orgUnit, displayed on websites. Not in use yet. deals.sellingTextSubjectMultiLang deals.sellingTextShortMultiLang deals.sellingTextMultiLang - Json object that can hold multiple languages of the same text structure { "sv": "Hus", "en": "House" } Allowed languages are: en, sv, es, de, da, fr, nl viewingBuyers.attended viewingSlotBuyers.attended - Marks if a buyer attended a viewing ======================================================================================================================== Version: #158 DATA STRUCTURE: estates: added column - hasNoMortgages biddings: added column - websiteBidSettings deals: added columns - email, residentialArea | modified column - earliestAccessDateComment(maxLength 50 -> 100) organizations: added column - allowOnlySSOLogin userAccounts: added column - allowPasswordLogin DEPRECATED: biddings.hideBidsOnWebsite INFORMATION: estates.hasNoMortgages - If set to true, the broker have confirmed that there are no mortgages on the estate We suggest showing a specific message when this is set to true biddings.websiteBidSettings - Replaces biddings.hideBidsOnWebsite. Describes how the website should display bids biddings.hideBidsOnWebsite - Can still be used, but for a limited time. If set it will change biddings.websiteBidSettings value deals.email - Deal specific email that can be used as an alternative to contacting brokers directly. Right now only used for new dev projects deals.residentialArea - Residential areas for new dev projects deals.earliestAccessDateComment - Changed maxlength from 50 to 100 chars organizations.allowOnlySSOLogin - If set to true only SSO logins is allowed, except for API users userAccounts.allowPasswordLogin - Used in combination with organizations.allowOnlySSOLogin. To allow specific users to login with password. ======================================================================================================================== Version: #157 Internal db update ======================================================================================================================== Version: #156 DATA STRUCTURE: organizations: added column - dealWebPageDeleteURL ADDED DEFAULT DATA: fileCategories - FILES_CATEGORY_STATUTES(Stadgar) FILES_CATEGORY_ANNUAL_ACCOUNTING(Årsredovisning) FILES_CATEGORY_ENERGY_PERFORMANCE(Energideklaration) FILES_CATEGORY_MAP_CADASTRAL(Förrättrinskarta) FILES_CATEGORY_CADASTRAL_DOCUMENT(Förrättringsakt) FILES_CATEGORY_ECONOMIC_PLAN(Ekonomiskplan) INFORMATION organizations.dealWebPageDeleteURL - If set, we will use this URL to send a DELETE, which should prompt the website to remove a deal from the website ======================================================================================================================== Version: #155 DATA STRUCTURE: estates: added columns - premiseRentIsNegotiable, isHotWaterIncluded, isColdWaterIncluded housingAssociations: added columns - isHotWaterIncluded, isColdWaterIncluded deals: added columns - buyerAccessOfficerContactId, buyerAccessLocationContactId, buyerAccessLocation, buyerAccessOfficer capitalGainCalculationImprovements: added column - includeLowerCostInCalculation marketValuations: modified column - waterType INFORMATION estates.premiseRentIsNegotiable, if set to true. Do not display the rent set, display instead that rent is negotiable. estates - isHotWaterIncluded and isColdWaterIncluded. If set, they are included in rent. Should be displayed on website and OD capitalGainCalculationImprovements.includeLowerCostInCalculation, if set it will ignore any lower boundary rules in capital gain marketValuations.waterType - Increased maxLength from 100 to 200 chars. housingAssociations, fields are used to populate estate when created from HA ======================================================================================================================== Version: #154 DATA STRUCTURE: organizations: added columns - saleReportIncludeApproximate, saleReportApproxMarginPercent, saleReportApproxMarkUpPercent estates: added column - storageDescription customFieldsValues: added index - foreignId DEFAULT DATA: buyers.interestedStatus - ENUM_BUYER_INTERESTED_STATUS_CONTACTED_UNDECIDED, ENUM_BUYER_INTERESTED_STATUS_CONTACTED_NO_ANSWER INFORMATION organizations fields will be used for more specific sale reports estates.storageDescription will be used to describe a storage space customFieldsValues.foreignId added index to the field to fix some slow queries ======================================================================================================================== Version: #153 DATA STRUCTURE: commissions: added column - payedDate housingAssociationBuildings: added column - energyPrimaryPerformance estates: added column - energyPrimaryPerformance buildings: added column - energyPrimaryPerformance capitalGainCalculationSellers: added column - deferralAmount viewings: added columns - viewingType, numberOfSlots, slotLength, slotCapacity, slotLimitReminder organizations: added column - validUntil DEFAULT DATA: objectSubTypes - OBJECTSUBTYPES_COMMERCIAL_HA_PREMISE ADDED TABLE: viewingSlots, viewingSlotBuyers INFORMATION: organizations - Field that specifies for how long a license is active or valid commissions - payedDate is a date when the commission is payed housingAssociationBuildings - energyPrimaryPerformance, new way to measure energy performance estates - energyPrimaryPerformance, new way to measure energy performance buildings - energyPrimaryPerformance, new way to measure energy performance capitalGainCalculationSellers - deferralAmount, we now allow a custom value to use as deferral amount instead of the maximum amount as we had before viewings, viewingSlots, viewingSlotBuyers - Fields and tables are not in use yet, but will be used for times slots and to make viewings easier to manage ======================================================================================================================== Version: #152 DATA STRUCTURE: dealAdditions: added column - isAdditionalService DEFAULT DATA: fileCategories - FILES_CATEGORY_CASH_FLOW_CALCULATION INFORMATION: dealAdditions - isAdditionalService is a bit field that will mark an dealAddition as additional fileCategories - New category to set on cash flow calculations ======================================================================================================================== Version: #151 DROPPED FIELDS: organizationUnits penaltyInterest housingAssociations housingAssociationStartDate note numberOfFacilities isLegalEntityOK pledgingFeePaidBy ownership membershipApplicationSentDate hasLift heatAndAirConditionFacilityComment internetSummary maxFloors buildYear liftComment buildingComment energyClass energyPerformance energyDescription energyStatus energyStatusDate energyStatusEntrepreneur energyStatusSummary contacts bookkeepingAccountNr isSmsNumber contactBranchId organizationUnitId encryptedDataId PULsetDate buyers mortgageCommitmentAmount bidders buyerGroupId contactId comment buyerGroups selectedBidder commissions commissionReportedDate minimumRepresentsFixedPrice isCommissionSumSetManually housingAssociationBuildings hasLift parkingSpaces totalRevenue tenantStatus estates tenureTypeId hasLift liftMaxPersons liftMaxLoad courtyardComment isSatelliteDishAllowed hasCableTv pledgingFeePaidBy tenureFee isRepairFund isShareInCondo isShareInCondoFee isPawned pawnedAmount pawnedComment insuranceCompany otherOperationCost displayOrder housingComment isRental kindOfBuilding isInternational isExchange cableTvSupplier cableTvCostText isTransferFeePaidBySeller isPledgingFeePaidBySeller convertRoom staircaseTotal patioComment cashFlowAnalysisSumRevenueParkingSpaces premiseEconomyValuesIsInVAT isEstateTenantCalculationSetManually chimneyTestDate capitalGainCalculations propertyUsedAsPermanentOrHolidayLivingFullPeriod livingPeriodFromDate livingPeriodToDate areaUSedForPermanentOrHolidayLiving livedOnPropertyFromDate livedOnPropertyToDate beenLivingOneYearPrecedingSale beenLiving3OfLast5YearsBeforeSale acquiredNewHomeBeforeSale deals isLegalEntityOK sellerSignatureLocation buyerSignatureLocation accessNoticeToSeller accessNoticeToBuyer vatPercentage isPublishedOnHemnet publishedOnHemnetDate energyStatus energyDeclarationAmount energyStatusDeadlineDate buildingStartDate preliminaryOccupancyStartDate municipalPropertyTax isAcceptedStartingPrice isSoldByQuotation optionalEquipmentValue optionalEquipmentComment incomingPartialPaymentDate incomingPartialPaymentAmount outgoingPartialPaymentDate outgoingPartialPaymentAmount interestRate interestRateStartDate interestRateEndDate isInterestRateAndDepositInSettlement downPaymentAmountInText matchingId depositedOutDate depositedOutComment depositedOutAmount listingReservedEndDate listingReservedStartDate buyerApprovedByTennantDate allConditionsMetDate assignmentType buildings surroundingComment premiseComment matchings minLatitude minLongitude maxLatitude maxLongitude objectSubTypeId housingAssociationContacts contactInformation roleStartDate other loans paymentPlan accessOfficerId marketValuations customerType mortgages isForeignCurrency foreignCurrencyAmount foreignCurrencyExchangeRate outgoingSms statusCode rooms roomTypeId ceilingType ceilingTypeYear wallType wallTypeYear floorType floorTypeYear area kitchenBrand kitchenBrandYear kitchenCabinetDoorsType kitchenCabinetDoorsYear kitchenCabinetDoorsColor benchHeight hasSeparateDinePlace isOpenFloorPlan fitsMaxNumberPers summary laundryRoomPlacement hasSink hasWashbasin hasHeatingCoils securityDoorType securityDoorYear servicesInDeals commissionHasBeenCharged staff activityFraction transactions printComment viewings isBookable isBookingRequired bookingLimit bookingTrigger triggerAction triggeredViewingId viewingSignDescription organizations emailDomainName themeCssUrl parentId dbUseExternal dbServerAddress dbServerPort dbServerUser dbServerPassword dbManagementSystem webFontId printFontId limitVisibilityToOrganizationalUnits useIpAddressFilter penaltyInterest allowInsecureLoginMethod ssoChallengeUrl invoiceNumberIncrement invoicingChargeForUsers isMaklarsamfundetMember invoicingChargeForOrganizationUnits invoicingChargeStaticCostsToOrganization propertyCustomLink propertyCustomLinkTitle userAccounts supportToken licenseInvoices specification isRetrieved communicationTokens usedToken flowSteps description DROPPED TABLES: accomondationCalculusLoans contactBudgetAccomondationCalculus accomondationCalculus biddingSettings blacklistedServices bonds buyerComments contactBranches contactBudgets dealWebPageTokens encryptedData estateContactInformation filesInCustomFields filesInNotifications filesInOrganizations followUpAppointments imagesInOrganizations insurances invoiceNumbers legalEntityContacts notifications organizationalUnitGeographicalAreas partialPayments roomAppliances roomTypeAppliances serviceInDealInvoices tenureTypes viewingAttendees viewingContacts fonts letterTemplateObjectTypes letterTemplates organizationIpAddresses roomTypes serverVersion userAccountIpAddresses userAccountUserAccountPolicyTexts userAccountPolicyTexts userAccountsLogins memberships INFORMATION: Removed deprecated fields and tables ======================================================================================================================== Version: #150 DATA STRUCTURE: estates: modified column - propertyName(maxlength 100 to 150) viewings: added columns - allowExternalBooking, externalBookingTriggerAction, externalBookingTriggerRecipientContactId organizations: added columns - allowExternalBookingViewing, archivedDate DEFAULT DATA: organization.licenseStatus - ENUMS_LICENSE_STATUS_ARCHIVED easementsAndDetails.easementType - ENUMS_EASEMENTTYPE_SEIZURE INFORMATION: estates - Increased maxlength for the field propertyName from 100 to 150 viewings - New fields to allow customers to booking an viewing from external sources, like broker web page ======================================================================================================================== Version: #149 CHANGED FROM datetime TO date deals: listingStartDate, listingEndDate, contractDate, downPaymentDate, depositedInDate allConditionsMetDate, buyerApprovalByTennantSentDate, accessDate, quotationDueDate estates: ventilationInspectionDate, chimneyLastUsedDate, keyInDate, keyOutDate groundRentEndDate, repairFundCheckDate, pawnedAmountCheckDate, energyStatusDate buildings: ventilationInspectionDate, chimneyTestedDate, energyStatusDate loans: loanEndDate, interestRateAdjustmentDate, conversionDate, loanControlDate transactions: transactionDate newspaperAds: advertisingDate mortgages: registrationDate farmingSpecifics: prepared estateTenants: contractEndDate dealSignatures: date buyerInterestInformation: latestContactDate, nextContactDate housingAssociationBuildings: energyStatusDate signatures date organizations: activationDate, suspendedDate INFORMATION: This update converts datetimes to date where a time is not needed ======================================================================================================================== Version: #148 DATA STRUCTURE: organizations: added column - gdprCollectionFromDifferentSources, gdprCompanyPersonalInfoAssistants, gdprCompanyPersonalInfoResponsible, gdprCountryOutsideEuPersonalDataTransfer INFORMATION: organizations - the fields are used in documents to inform about how the company handles GDPR ======================================================================================================================== Version: #147 DATA STRUCTURE: estates: added columns - companyTransferValuesFromDate, companyTransferBookedEstateValue, companyTransferBookedInventoryValue, companyTransferBookedSum, companyTransferTaxResidualEstateValue, companyTransferTaxResidualInventoryValue, companyTransferTaxResidualSum organizations: added column - hostname contacts: added column - gdprLatestExport, gdprForgottenDate dealMarketingPlaces: added column - updatedOnMarketingPlaceDate | modified column - unpublishedDate (from date, to datetime) communicationTokens: added column - type DEFAULT DATA: teamRoles.role - ENUMS_TEAMROLES_TYPE_RENTER INFORMATION: estates - fields are used for company transfers organizations - hostname will contain customers custom hostname contacts - gdprLatestExport contains date when latest data export was done, gdprForgottenDate when the contact were forgotten dealMarketingPlaces - updatedOnMarketingPlaceDate timestamp when updated on marketingPlace communicationTokens - type is used to define what type of communicationToken it is ======================================================================================================================== Version: #146 ADDED TABLE: signatureSourceTypes DATA STRUCTURE: organizationUnits: added column - email contacts: added columns - timelinessDate, gdprInformationSendDate, gdprDirectMarketingAllowedUntil deals: added columns - minOtherLivingArea, maxOtherLivingArea, minMonthlyRent, maxMonthlyRent, valuationDate dealMarketingPlaces: added column - unpublishedDate organizations: added columns - dealWebPageGetVisitorsURL, urlToGDPRDoc DEFAULT DATA: deals.objectStatus - ENUMS_OBJECTSTATUS_TYPE_AVAILABLE_FOR_RENT INFORMATION: signatureSourceTypes - Table used to keep track of signatures for non version documents organizationUnits - Email will contain the organizationUnits contact email contacts - timelinessDate date when the contact was contacted last. Added some gdpr fields deals - valuationDate date when the deal was valuated. Rest of the fields are for new development projects dealMarketingPlaces - unpublishedDate will be set when the deal is removed from marketing place organizations - dealWebPageGetVisitorsURL used to get visitor statistics from web page. urlToGDPRdoc url to company specific GDPR documentation. ======================================================================================================================== Version: #145 ADDED TABLES: gdprDataRequest, gdprForgotten DATA STRUCTURE: contacts: added columns - gdprApprovalDate, gdprValidUntil, gdprFlaggedForInvestigationDate, gdprReminderToApproveDate matchings: added column - matchingChangedDate estates: modified column - chimneyComment (from maxlength 150 to text) deals: added column - sellerDownPaymentAccountId viewings: added column - comment newspaperAds: added column - media marketValuations: modified column - marketValueSpread (from type money to text, maxLength 100) INFORMATION: contacts - Fields added are used to keep track of GDPR matchings.matchingChangedDate - Used to keep track of when an active changed was made to a matching, to avoid stale matchings estates.chimneyComment - Changed type from varchar maxLength 150 to text deals.sellerDownPaymentAccountId - When downpayment is to be paid to one seller, the bankAccount is set in this field viewings.comment - Field used for private comments that should not be publicly displayed newspaperAds.media - Its now possible to set which media a newspaperAd is displayed in gdprDataRequest and gdprForgotten - Tables needed for GDPR marketValuations.marketValueSpread - Changed from money to text, allow more flexible values ======================================================================================================================== Version: #144 DATA STRUCTURE: commissions: dropped column - paymentDate | added column - estimatedPaymentDate contacts: added column - shouldBeContactedDate emailContacts: added column - contactType INFORMATION: contacts.shouldBeContactedDate - Date when a contact should be contacted by broker, combined with calender booking commissions.estimatedPaymentDate - A date when the broker believe the commission will be paid out emailContacts.contactType - Will determine if the user will receive email as cc or bcc. ======================================================================================================================== Version: #143 ADDED TABLES: futureChanges DATA STRUCTURE: communications: dropped column - isSmsSent | added columns - subject, letterSubject, letterSigneeText DEFAULT DATA: imagesInEstates.category - ENUMS_IMAGES_IN_ESTATES_CATEGORY_RESIDENTAL_BUILDING, ENUMS_IMAGES_IN_ESTATES_CATEGORY_ECONOMI_BUILDING, ENUMS_IMAGES_IN_ESTATES_CATEGORY_FOREST_AND_LAND, ENUMS_IMAGES_IN_ESTATES_CATEGORY_DIRECTIONS, ENUMS_IMAGES_IN_ESTATES_CATEGORY_OTHER searchFilters.filterType - hdDeals deals.objectStatus - ENUMS_OBJECTSTATUS_TYPE_TERMINATED INFORMATION: The table futureChanges will contain changes that will be set in place when a date is passed. communications - field that will extend communication module ======================================================================================================================== Version: #142 ADDED TABLES: communications, communicationContacts, formInvitations, formInvitationContacts, matchingObjectSubTypes, quarantine, forms DATA STRUCTURE: deals: added column - cashDefinitiveStatementHideDownPaymentTransactions DEFAULT DATA: languages - Español INFORMATION: Tables communications and communicationContacts are used for our upcoming communication component Tables formInvitations, formInvitationContacts, forms and quarantine. Are used for upcoming customers page matchingObjectSubTypes is used to allow a matching to have multiple objectSubTypes languages - Español, most of the system can now be run in spanish ======================================================================================================================== Version: #141 DATA STRUCTURE: capitalGainCalculations: added columns - isCalculationIndividual, apartmentNumber DEFAULT DATA: fileCategories - FILES_CATEGORY_EXTERNAL_WEBSITE INFORMATION: capitalGainCalculations - Fields used to fill out more information in K forms(Tax return) fileCategories - New type that define a link to an external website ======================================================================================================================== Version: #140 ADDED TABLES: dealGeographicalAreas DATA STRUCTURE: deals: added column - countryId signatures: added column - headerText INFORMATION: dealGeographicalAreas - Used for new development projects to set state and municipality on a project deals.countryId - Used for new development projects to set country on a project signatures.headerText - Allows the user to add a text to the signature that explains in what context the signature is made ======================================================================================================================== Version: #139 DEFAULT DATA: areas.type - ENUM_AREA_TYPE_FOREST_WITH_RESTRICTIONS DATA STRUCTURE: organizations: added column - leadForwardEmail organizationUnits: added column - leadForwardEmail housingAssociations: added column - plotOwnership estates: added column - housingAssociationPlotOwnership deals: added column - sellerContactReferralChannelId memoPad: added column - subject ADDED TABLES: customPropertyLinks, gridFilters, contactReferralChannels DEPRECATED FIELDS: organizations.propertyCustomLinkTitle and propertyCustomLinkTitle.propertyCustomLink - Moved to customPropertyLinks INFORMATION: organizations.leadForwardEmail and organizationUnits.leadForwardEmail - Email we will forward leads from webpage to housingAssociations.plotOwnership and estates.housingAssociationPlotOwnership - Enum that specifies if the HA owns the land or leases it deals.sellerContactReferralChannelId - Specifies how the sellers gained knowledge about the company memoPad.subject - Its now possible to add subject to memoPad entries that can be used in letters/email/documents customPropertyLinks - Contains buttons that will be displayed in the left menu in property view gridFilters - Table will contain filters for our grids and flow page contactReferralChannels - The license can define their own referralChannels ======================================================================================================================== Version: #138 DEFAULT DATA: dealMarketingPlaces.marketingPlace - ENUM_MARKETING_PLACES_KUSTIT DATA STRUCTURE: organizations: added column - dealWebPageUpdateSettingsURL versions: added column - issuingInformation associationVersions: added column - issuingInformation contacts: added column - invoiceAddress matchings: added columns - maxHectare, minHectare, objectSubTypeId, inactivatedDate estates: added columns - cashFlowAnalysisIgnoreFields, cashFlowAnalysisGeneralizedOperationCost, cashFlowAnalysisGeneralizedMaintenanceCost | modified column - polygonListJSON (from text to mediumtext) housingAssociations: isCondominiumSupplementIncluded estateTenantsSubObjectTypeEstateCalculations: added columns - generalizedOperationCost, generalizedMaintenanceCost, totalRevenuePerArea, otherRevenuesPerArea, vacancyQuantity, vacancyTotalArea, vacancyTotalRevenue documentBundleDocuments: added column - associationDocumentId ADDED TABLES: emails, emailFiles, emailContacts, matchingHistory DEPRECATED FIELDS: estates.isEstateTenantCalculationSetManually INFORMATION: dealMarketingPlaces.marketingPlace.ENUM_MARKETING_PLACES_KUSTIT - New upcoming marketingplace organizations.dealWebPageUpdateSettingsURL - New url that we use to update website settings colors texts and so on, previous we used dealWebPageBaseURL versions.issuingInformation and associationVersions.issuingInformation - Used in customer made documents that will contain copyright information contacts.invoiceAddress - Will contain invoicing information for legal entity contacts matchings - New fields that will be in our new matching module estates.polygonListJSON - changed from text to medium text as text didnt have enough space for some properties estates.cashFlowAnalysisIgnoreFields - Contains fields that will not be included in cash flow calculation estates.cashFlowAnalysisGeneralizedOperationCost and estates.cashFlowAnalysisGeneralizedMaintenanceCost - We now have different generalized costs for commercial estates.isEstateTenantCalculationSetManually - Is now deprecated, the system will behave as it is always set to true housingAssociations.isCondominiumSupplementIncluded - Will be transferred to estate when creating from HA. Field already exists on estates estateTenantsSubObjectTypeEstateCalculations - Fields added to make the whole estate tenant summary manual. We only allow manual data in the summary now documentBundleDocuments.associationDocumentId - Will now point to a associationDocument so we can keep the bundle up to date emails, emailFiles, emailContacts - Tables that will contain emails sent from the system to contacts matchingHistory - Connects a deal with a contact and if they have been sent matching email/sms/mail ======================================================================================================================== Version: #137 DATA STRUCTURE: contacts: added columns - externalIdentifier, encryptedDataId estates: added column - isCondominiumSupplementIncluded | modified columns - drainType(maxLength 100 -> 200), waterType(maxLength 100 -> 200), groundRentLandlord(maxLength 100 -> 250) matchings: added column - comment areas: added column - isMarketing dealReceiptAmounts: added column - displayOrder pushSubscriptions: added column - rowField organizations: added columns - legalName, excludeFromStatistics, securityPolicies wall: added columns - organizationId, startDate ADDED TABLE: encryptedData INFORMATION: encryptedData - Contains data that is encrypted and can only be retrieved with the correct password that the user chooses contacts.externalIdentifier - used to store LM identifier from imported contacts contacts.encryptedDataId - foreignKey to table encryptedData matchings.comments - Used to write comments on a contacts matching criteria estates.waterType, estates.drainType - Increased maxLength from 100 to 200 chars estates.groundRentLandlord - Increased maxLength from 100 to 250 chars estates.isCondominiumSupplementIncluded - If set to true, condominium supplement will be included in rent areas.isMarketing - Used in commercial. If area should be in object description and so forth dealReceiptAmounts.displayOrder - Used to order amounts in a receipt pushSubscriptions.rowField - Not in use yet, will be used for more advanced pushSubscription settings organizations.legalName - Used in the same way as organizationUnits.legalName, organizations.name is common name and legalName will be the correct legal name of the company organizations.excludeFromStatistics - If set to true we will not retrieve statistic data from this organization organizations.securityPolicies - Contains policies regarding two factor auth and more to come wall.organizationId - Used to target a wall message to a specific organization wall.startDate - A wall message will not show until the date have passed ======================================================================================================================== Version: #136 DATA STRUCTURE: contacts: added column - isIdentifierVerified ADDED TABLE: contactLogs INFORMATION: contacts.isIdentifierVerified - read only field that will specify if the identifier have been validated in some manner. For now we only support BankId contactLogs: Read only table that will keep track of events connected to the contact. For now we mainly handle bankId events. ======================================================================================================================== Version: #135 DEFAULT DATA: objectSubTypes - OBJECTSUBTYPES_FARMING_FIELD, OBJECTSUBTYPES_FARMING_TENURE, OBJECTSUBTYPES_FARMING_FARM currencies - NOK DATA STRUCTURE: buyers: added columns - interestedStatus, ownsProperty | modified columns - contactId, buyerGroupId buyerGroups: added column - mainBuyerId dealReceipts: added column - payer invoices: added column - hideCommunicationToken estates: modified column - radonComment buildings: added column - isMarketing marketValuations: added column - isLeasehold, isPartOf, isTenureHouse, isSharedOwnership userAccounts: added column - securityPolicies INFORMATION: buyers.contactId and buyers.buyerGroupId will from now on be mandatory to avoid buyers that are not connected to anything. All buyers that are missing either contactId or buyerGroupId will be removed in this update New subObjectTypes for objectType OBJECT_TYPE_FARMING (OBJECTSUBTYPES_FARMING_FIELD,OBJECTSUBTYPES_FARMING_TENURE,OBJECTSUBTYPES_FARMING_FARM) New currency norwegian krone(NOK) buyerGroups.mainBuyerId, will be used in our new upcoming way to handle prospective buyer. The mainBuyer will be the person/organization that the broker will have primary contact with in a buyerGroup dealReceipts.payer is be the person/organization that paid the amount that the receipt will document invoices.hideCommunicationToken in invoice print its now possible to toggle if deal token(communicationToken) will be printed estates.radonComment changed type from varchar(200) to text buildings.isMarketing, used for commercial buildings if they should be in marketing documents like object description marketValuations, fields added to specify what sort of property that is valued ======================================================================================================================== Version: #134 DEFAULT DATA: accessRights - ACCESS_RIGHT_API_FREE teamRoles.role - ENUMS_TEAMROLES_TYPE_AGRONOMIST DATA STRUCTURE: invoicingInformation: added column - accountNr deals: modified column - startingPriceType (from 50 chars to 100) sellers: modified column - share (from 10 chars to 20) buyers: modified column - share (from 10 chars to 20) estates: modified column - liftComment (from 200 chars to text) files: added column - createdDate transactions: added column - description marketValuations: added columns - objectSubTypeText, floorNr, floorsInTotal, estateEconomicTypeCodeId contactSignatures: added column - dealId organizations: added columns - propertyCustomLink, propertyCustomLinkTitle | modified column - defaultStartingPriceType (from 50 chars to 100) ======================================================================================================================== Version: #133 DEFAULT DATA: estateTenantsObjectTypes - ESTATE_TENANTS_OBJECT_TYPES_PARKING estateTenantsObjectTypesStatus - ESTATE_TENANTS_OBJECTY_TYPES_STATUS_VACANT, ESTATE_TENANTS_OBJECTY_TYPES_STATUS_RESERVED, ESTATE_TENANTS_OBJECTY_TYPES_STATUS_RENTED all connected to ESTATE_TENANTS_OBJECT_TYPES_PARKING estateTenantsSubObjectTypes - ESTATE_TENANTS_SUB_OBJECT_TYPES_PARKING_SPACE, ESTATE_TENANTS_SUB_OBJECT_TYPES_GARAGE, ESTATE_TENANTS_SUB_OBJECT_TYPES_CARPORT all connected to ESTATE_TENANTS_OBJECT_TYPES_PARKING DEPRECATED FIELDS: parkingSpaces: totalRevenue and tenantStatus INFORMATION: This update focuses on adding a new estateTenantsObjectType, ESTATE_TENANTS_OBJECT_TYPES_PARKING (Parking) with statuses and subTypes estateTenants will no longer use the table parkingSpaces in its summary, we will instead use this new estateTenantsObjectType We will copy data from the parkingSpaces that was used in estateTenantList summary and add new estateTenants with the new type ESTATE_TENANTS_OBJECT_TYPES_PARKING ======================================================================================================================== Version: #132 RENAMED TABlE: old name "estateTenantsSubObjectTypeEstateCosts" new name "estateTenantsSubObjectTypeEstateCalculations" name changed to better represent its use DATA STRUCTURE: estateTenantsSubObjectTypes: added column - organizationUnitId estates: added columns - repairFundSetting, isEstateTenantCalculationSetManually | modified column - identifier transactions: added column - printComment estateTenantsSubObjectTypeEstateCalculations: added columns - quantity, totalArea, totalRevenue, otherRevenues DEFAULT DATA: estateTenantsSubObjectTypes - ESTATE_TENANTS_SUB_OBJECT_TYPES_HOUSING for ESTATE_TENANTS_OBJECT_TYPES_HOUSING DEPRECATED FIELDS: estates.isRepairFund, replaced by estates.repairFundSetting MODIFIED DATA: estates.identifier will be changed from "fastighetsnyckel" to a GUID estates.isRepairFund if set to true estates.repairFundSetting will equal ENUM_ESTATE_REPAIR_FUND_SETTING_EXISTS estateTenants.estateTenantsSubObjectTypeId will be set to ESTATE_TENANTS_SUB_OBJECT_TYPES_HOUSING for all with objectType ESTATE_TENANTS_OBJECT_TYPES_HOUSING and where estateTenants.estateTenantsSubObjectTypeId is null INFORMATION: estateTenantsSubObjectTypes: organizationUnitId used for organizationUnits to set their own estateTenantsSubObjectTypes name is no longer unique on its own. Its now unique together with organizationUnitId estates: identifier maxLength changed from 20 to 50. To allow place for a guid that will be our new Lantmateriet identifier repairFundSetting enum that allows more settings than a single bit/boolean isEstateTenantCalculationSetManually if set to true estateTents will not be automatically summed, it will instead be entered manually by the user in the table estateTenantsSubObjectTypeEstateCalculations transactions: printComment if set to true the comment will be added to pdf:s where the transaction is used estateTenantsSubObjectTypeEstateCalculations: New fields are used if the user wants to enter sum manually instead of adding estateTenants ======================================================================================================================== Version: #131 DATA STRUCTURE: estates: added columns - objectSubTypeText, propertyTaxPaidByTenants, netPropertyTax, cashFlowAnalysisGeneralizedOperationAndMaintenanceCost deals: added columns - outgoingPaymentBankAccountId, outgoingPaymentBankAccountText estateTenantsSubObjectTypes: added column - generalizedCost sellers: modified columns - contactId, dealId (both fields are now mandatory) ADDED TABLE: estateTenantsSubObjectTypeEstateCosts DEFAULT DATA: webhome: added WEBHOME_HIDE_FOR_SALE_TITLE objectSubTypes: OBJECTSUBTYPES_COMMERCIAL_HEALTH_CARE_FACILITY(Only for commercial), OBJECTSUBTYPES_OTHER(For all objectTypes, enables estates.objectSubTypeText) INFORMATION: estates: objectSubTypeText - When objectSubTypeId = OBJECTSUBTYPES_OTHER we allow the user to enter their own definition of subType propertyTaxPaidByTenants - Used in commercial objects, the amount tenants pay of the propertyTax netPropertyTax - The amount the owner pays of propertyTax cashFlowAnalysisGeneralizedOperationAndMaintenanceCost - Used in cash flow analysis to display generalized costs deals: outgoingPaymentBankAccountId - BankAccount all payments will be made to in cash definitive statement outgoingPaymentBankAccountText - Bank account all payments will be made to in cash definitive statement estateTenantsSubObjectTypes: generalizedCost - general cost per/m2 for that subObjectType estateTenantsSubObjectTypeEstateCosts: table used to set generalizedCost for a specific estate sellers: contactId and dealId - Are now mandatory, all sellers missing either contactId or dealId will be deleted in this update ======================================================================================================================== Version: #130 DATA STRUCTURE: organizations: added column - smsNumber(Read only) associationVersions: added column - associationDisplayOrderId, settingsJSON ADDED TABLE: associationDisplayOrders, associationRowContainers, associationRowContainerRows INFORMATION: organizations: smsNumber - Read only field that contains the number all sms will be sent from in that license(Contact Mspecs support for more information regarding license specific smsNumber) The remaining database changes will support the new documents(doc.2017) ======================================================================================================================== Version: #129 DATA STRUCTURE: housingAssociations: added columns - isHeatIncluded, isWaterIncluded, isElectricityIncluded, isCableTVIncluded, isInternetIncluded, isGarageIncluded, isCarportIncluded, isParkingSpaceIncluded, otherFeesIncludedInRent, monthlyRentSummary estates: added column - locationDescriptionId capitalGainCalculations: added column - kType versions: added column - settingsJSON dealUrls: modified column - url (maxLength 150-200chars) housingAssociationUrls: added column - url (maxLength 150-200chars) letters: added column - signature parkingSpaces: added column - tenantStatus ADDED TABLES: locationDescriptions ENUMS: deals.newDevelopmentStatus - Added ENUM_DEAL_NEW_DEVELOPMENT_STATUS_MARKETING INFORMATION: housingAssociations: added fields for costs that will be transferred to estate when connecting housingAssociation. locationDescriptions: will contain descriptions that can be imported to an estate estates: added id to connect a locationDescription capitalGainCalculations: kType will be used mainly to choose if K5 or K7 is used. versions: settingsJSON will contain settings specific for the current version dealUrls and housingAssociationUrls: expanded url maxLength from 150 chars to 200 chars letters: We will now store the signature for every specific letter, this allows the user to edit the signature for each letter. parkingSpaces: tenantStatus will determine if a parkingSpace should be included in cashFlowAnalysis ======================================================================================================================== Version: #128 INFORMATION: Refactored table contactSigneeContactOtherSignatures, used in the new documents ======================================================================================================================== Version: #127 DATA STRUCTURE: organizationUnits: added column - receiptNumber dealReceipts: added column - number housingAssociationContacts: added column - displayOrder organizations: added column - receiptNumber ADDED TABLES: dealBrokerJournalFlowStepProgress ADDED DEFAULT DATA: fileCategories - FILES_CATEGORY_DRONE_VIEW_INTERACTIVE(Drönarvy, interaktiv) INFORMATION: dealBrokerJournalFlowStepProgress - The table will be used to mark a section in the brokerJournal as finished organizations,organizationUnits and dealReceipts - receiptNumber will be used on receipts in the same way as invoice numbers housingAssociationContacts - The field will be used to order contacts in a HA ======================================================================================================================== Version: #126 DATA STRUCTURE: versions: added column - displayOrderId ADDED TABLES: signatures, contactSignatures, contactSigneeContactOtherSignatures, displayOrders, rowContainers, rowContainerRows,versionContactSignatures, versionSignatures, witnesses INFORMATION: This update focuses on the new documents. The tables and fields added will be needed in the new document module, including signatures ======================================================================================================================== Version: #125 DATA STRUCTURE: deals: modified columns - accessLocation(from 100 to 150chars), accessOfficer(from 50 to 150chars) estates: added columns - cashFlowAnalysisSumRevenue, cashFlowAnalysisSumOtherIncomes,cashFlowAnalysisSumRevenueParkingSpaces, cashFlowAnalysisSumVacancies, cashFlowAnalysisCosts, cashFlowAnalysisMaintenanceCost, cashFlowAnalysisPropertyTax, cashFlowAnalysisYearlyGroundRend, isCashFlowAnalysisCalculationSetManually areas: added column - estateEconomicTypeCodeId buildings: added column - estateEconomicTypeCodeId viewings: added column - displayOnlyViewingDescription staff: added column - isDebtUnit ADDED TABLE: newDevelopmentProperties ADDED DEFAULT DATA: fileCategories - FILES_CATEGORY_LANTMATERI_INVESTIGATION(Lantmäteriutredning) INFORMATION: deals: accessLocation - Increased maxLength from 100 to 150 chars, accessOfficer - Increased maxLength from 50 to 150chars estates: cashFlowFields - added to allow the user to use manually entered data to calculate cashFlow. Even when it's automatically calculated we will store the data in these fields areas and buildings: estateEconomicTypeCodeId will be set from LM. Will be used to calculate taxes viewings: displayOnlyViewingDescription will be set to true when user only wants the description to be displayed on marketingPlaces staff: isDebtUnit used to specify which organizationUnit that will be invoiced for the specific user, only one staff post can be marked at a time. newDevelopmentProperties: used in new development projects to specify how many of which objectType will be build in the project fileCategories: FILES_CATEGORY_LANTMATERI_INVESTIGATION will be used to mark files for "Lantmäteriutredning" ======================================================================================================================== Version: #124 DATA STRUCTURE: deals: added column - plotDescription INFORMATION: deals - Added plotDescription that will only be used in new development projects ======================================================================================================================== Version: #123 DATA STRUCTURE: estates: added columns - isCashFlowAnalysisMaintenanceCostPerAreaSetManually, cashFlowAnalysisMaintenanceCostPerArea, isCashFlowAnalysisCostPerAreaSetManually, cashFlowAnalysisCostPerArea organizationUnits: added columns - envelopeType deals: added columns - cashDefinitiveStatementFeeAndTaxInformation, assignmentIsTerminated, assignmentTerminatedDate, assignmentTerminatedReason marketValuations: modified column - propertyName letters: modified column - name organizations: added columns - changePasswordInterval userAccounts: added columns - passwordSetDate ADDED DEFAULT DATA: objectSubTypes - OBJECTSUBTYPES_HOUSING_COOPERATIVE_DETACHEDHOUSE for tenant ownerships INFORMATION: estates: Added new fields for cash flow analysis on commercial objects. organizationUnits: Previous it was only possible to set default envelope type on organization, it is now possible to set per organizationUnit deals: cashDefinitiveStatementFeeAndTaxInformation, we now allow the user to edit the text regarding fees and taxes in cash definitive statement new bit to mark a deal as terminated, with date and reason marketValuations: propertyName length is extended from 100 to 200 chars letters: name length is extended from 30 to 100 chars organizations: changePasswordInterval will allow organizations to enforce a change password policy, set in days. userAccounts: passwordSetDate will contain a date that shows when password was set ======================================================================================================================== Version: #122 DATA STRUCTURE: capitalGainCalculationSellers: added columns - reversalOfImpairment, departsFromProfit, deprecationForCompensationFundForLand buildings: added columns - areaId, tax, isPublic(default true) areas: added columns - tax, valueYear deals: added column - sellAsCompany filesInHousingAssociations: added column - doNotCopy comments: added columns - subject, isRead estateTenantsSubObjectTypes: added column - isInactive letters: added columns - cityAndDate, subject estates: added column - electricityCost organizations: added column - allowOrganizationUnitAdminToEditUsers MOVED DATA: estates.plotArea is moved to estates.plotDescription for objectType OBJECT_TYPE_HOUSING_DEVELOPMENT INFORMATION: filesInHousingAssociations: is no longer a connectionTable and we can now mark files that should not be copied to deals capitalGainCalculationSellers: fields are used to fill K7 form buildings and areas: areaId and tax are used to calculate tax for farming. isPublic makes is possible for a broker to toggle if the building should be in the object description, its only used for farming deals: The field is only used for commercial and to mark that its a company for sale as well as the estate comments: Fields that will extend the comment functionality estateTenantsSubObjectTypes: It will now be possible to inactivate user made objectTypes, it will not be possible to choose for new estateTenants. But will work for estateTenants that already have it set letters: Fields are used to extend the functionality for letters estates.electricityCost: That field can be used to set total electricity cost instead of dividing it into: estates.householdElectricityCost and estates.heatingCost estates.plotArea: After requests from brokers we will use a text field instead of a decimal field. We will move the data for housing development to plotDescription and switch the field in UI organizations.allowOrganizationUnitAdminToEditUsers: It will now be possible to allow orgUnitAdmins to edit the members that belong to their orgUnits ======================================================================================================================== Version: #121 DATA STRUCTURE: amounts: modified column - title maxLength is now 120 organizationUnits: modified column - dueDays default is now 30 added column - companyHeadquarters organizations: modified column - dueDays default is now 30 added column - companyHeadquarters contacts: modified column - companyName maxLength is now 120 housingAssociations: added column - transferRoutine estates: added column - valueIndication biddings: added column - displayBidderStatusOnWebsite commercialOtherIncomes: added columns - displayOrder, type dealReceipts: added column - hideSignees userAccounts: added column - letterSignature customFields: added column - defaultValue ADDED DEFAULT DATA: currencies: GBP ENUMS: deals.objectStatus: added - ENUMS_OBJECTSTATUS_TYPE_LEASED (Leased - Uthyrd) OTHER: commercialOtherIncomes is no longer a strict connection table. ======================================================================================================================== Version: #120 DATA STRUCTURE: bankAccounts: modified column - accountNumber maxLength is now 100 estates: added columns - livingAreaIsApproximate, isAcquisitionPermitNeeded, district, feeDescription, businessTradeType, businessEquipment, businessEstablishedYear, businessNumberOfEmployees, businessNumberOfCustomers, businessRevenue, businessProfit, costDescription, farmingPurposeText, grantingFee, contributionFee, keyIdentifier dealUrls: added columns - displayOrder housingAssociationUrls: added columns - displayOrder organizationUnits: added columns - documentFooterUpperShowArchiveNumber, businessInsideEUOutsideSweden, businessOutsideEUOutsideSweden, vatNumber deals: modified column - finalPriceInText changed maxLength to 200 organizations: added columns - objectDescriptionExternalURL, displayWindowExternalURL, documentFooterUpperShowArchiveNumber, defaultStartingPriceType, businessInsideEUOutsideSweden, businessOutsideEUOutsideSweden, invoicingChargeForOrganizationUnits, invoicingChargeStaticCostsToOrganization modified column - vatNumber maxLength is now 50 marketValuations: modified column - officerRole is now a type along field with suggestions DEPRECATION: deals.finalPriceInText is not deprecated anymore estates.tenureFee is deprecated ADDED TABLES: commercialOtherIncomes MOVED DATA: estates.otherFeeIncludedComment is moved to estates.costDescription for objectTypes OBJECT_TYPE_HOUSE and OBJECT_TYPE_PREMISE estates.otherFeeIncludedComment is moved to estates.feeDescription for objectType OBJECT_TYPE_PREMISE ADDED DEFAULT DATA: objectSubTypes: OBJECTSUBTYPES_RECREATIONAL_HOUSE_BOATHOUSE for OBJECT_TYPE_HOUSE and OBJECT_TYPE_RECREATIONAL_HOUSE ENUMS: teamRoles.role: added - ENUMS_TEAMROLES_TYPE_SELLER ======================================================================================================================== Version: #119 DATA STRUCTURE: userAccounts: added column - emailSignature ======================================================================================================================== Version: #118 DATA STRUCTURE: deals: added columns - plotArea, newDevelopmentStatus, developmentPhase, objectType, habitat, salesStartDate ======================================================================================================================== Version: #117 DATA STRUCTURE: contacts: added column - userAccountId estates: added column - isPropertyAssociation | modified column - tenantOwnershipLandComment(varchar(200) > text) biddings: added column - contactSmsNumberId deals: added columns - buildingStarted, preliminaryOccupancy areas: added column - isTaxable dealReceipts : added column - estateDisplayName estateTenants: added column - rentIndex invoices: modified column - date(Is now mandatory, if null will be set to NOW()) marketValuations: added column - marketValueInText services: added column - isPrivate DEPRECATED FIELDS: deals.buildingStartDate deals.preliminaryOccupancyStartDate ADDED DEFAULT DATA: estateEconomicTypeCodes - Duplicated codes from House to Recreational house objectSubTypes - Added new objectSubType for House, OBJECTSUBTYPES_FARMING_PARCELED_FARM ======================================================================================================================== Version: #116 DATA STRUCTURE: housingAssociationBuildings: added column - hasLiftSetting areas: added columns - parentId, isCommercialArea, buildingRightArea organizationUnits: added columns - phoneNumber, faxNumber dealAdditions: added column - addToCommissionInReports documents: added columns - clonedAssociationDocumentId, clonedAssociationVersionId, createdByUserId estateTenants: added column - buildingId marketValuations: added column - officerRole organizations: added columns - invoiceAttention, supportURL, supportFormURL associationDocuments: added columns - clonedAssociationDocumentId, clonedAssociationVersionId, createdByUserId services: added column - editOrderURI DEPRECATED FIELDS: housingAssociationBuildings.hasLift - Replaced by housingAssociationBuildings.hasLiftSetting estates.hasLift - Replaced by estates.hasLiftSetting ======================================================================================================================== Version: #115 Internal db update that won't affect the public API ======================================================================================================================== Version: #114 DATA STRUCTURE: capitalGainCalculationSellers: added columns - isForcedSale, newProperty, deferral ======================================================================================================================== Version: #113 ADDED TABLE capitalGainCalculationSellers ======================================================================================================================== Version: #112 DATA STRUCTURE: estates: added columns - premiseHideRentOnMarketingPlaces, premiseHideRentInObjectDescription, isGarageIncluded, isCarportIncluded, isParkingSpaceIncluded, buildingRightsLandDescription organizationUnits: added columns - alias, documentFooterUpperShowOrgAlias, documentFooterUpperShowBrokerAlias, documentFooterUpperShowPropertyName, documentFooterUpperShowPropertyAddress, documentFooterUpperShowDealToken organizations: added columns - alias, documentFooterUpperShowOrgAlias, documentFooterUpperShowBrokerAlias, documentFooterUpperShowPropertyName, documentFooterUpperShowPropertyAddress, documentFooterUpperShowDealToken contacts: added columns - faxNumber, alias contactInformation: added columns - faxNumber commissions: added columns - showDealTokenInSettlement ADDED TABLE: documentBundleObjectTypes ENUMS: contactInformation.contactType ADDED: ENUMS_CONTACTTYPE_FAX ======================================================================================================================== Version: #111 DATA STRUCTURE: organizationUnits: modified column - invoiceAttention(40 -> 100 chars) bankAccountRoles: added column - isPrimaryBankAccount documents: modified columns - preValidationUrl(200 -> 400chars), postValidationUrl(200 -> 400chars) estates: added columns - premiseTenantContractNumber, showBurglarAlarmOnMarketingPlaces teamRoles: added column - isPublic associationDocuments: added columns - preValidationUrl, postValidationUrl brokerJournalEventTypes: added column - organizationId ======================================================================================================================== Version: #110 DATA STRUCTURE: documentBundles: added column - isHidden dealUrls: added column - isBundleItem versions: added column - isBundleItem ======================================================================================================================== Version: #109 DATA STRUCTURE: contacts: added columns - hasSecretIdentity, contactSecretIdentityId associationVersions: added column - changelog ADDED TABLES: contactSecretIdentities, dealDocumentBundles, dealDocumentBundleDocuments DEFAULT DATA: fileCategories: ADDED: FILES_CATEGORY_3D_OBJECT, FILES_CATEGORY_SLIDE_SHOW, FILES_CATEGORY_SAMPLE_FURNISHING, FILES_CATEGORY_PHOTO_STYLING, FILES_CATEGORY_PANORAMA ENUMS: farmingSpecifics.type ADDED: ENUM_FARMING_SPECIFICS_TYPE_SUGAR_QUOTA, ENUM_FARMING_SPECIFICS_TYPE_SUPPORTGRANTS deals.objectStatus ADDED: ENUMS_OBJECTSTATUS_TYPE_SOLD ======================================================================================================================== Version: #108 DATA STRUCTURE: documentBundleDocuments: removed column - associationDocumentId | added column - associationVersionId ======================================================================================================================== Version: #107 DATA STRUCTURE: files: modified column - originalURI(Changed maxLength to 500) documentBundles: added columns - customFieldId, customFieldValue contacts: added column - isDeceased documentBundleDocuments: added column - allowSinglePrint sellers: added column - shouldNotSign, isDeceasedInheritor services: added columns - emailSubject, emailTo, emailCc, emailBody associationFiles: modified column - originalURI(Changed maxLength to 500) ADDED TABLE: hiddenAssociationDocuments ENUMS deals.objectStatus Added: ENUMS_OBJECTSTATUS_TYPE_FOR_SALE ENUMS_OBJECTSTATUS_TYPE_INTAKE ENUMS_OBJECTSTATUS_TYPE_MARKETING services.presentation Added: ENUMS_SERVICE_PRESENTATION_EMAIL ADDED DEFAULT DATA: currencies: DKK ======================================================================================================================== Version: #106 Internal db update that won't affect the public API ======================================================================================================================== Version: #105 DEPRECATED: viewingContacts is deprecated and is replaced by viewingBuyers bidders.comment is deprecated and is replaced by buyers.description viewingContacts.description is deprecated and is replaced by buyers.description DATA STRUCTURE: organizationUnits: added column - invoiceEmail deals: added column - webPageAccessibleOnlyByDirectUrl estates: added column - isCoolingIncluded buildings: added columns - isSanitationMature, redevelopmentCost buyers: added column - description documents: added columns - preValidationUrl, postValidationUrl organizations: added columns - office365ClientId, office365Secret, invoiceEmail ADDED TABLES: documentBundles, documentBundleDocuments, viewingBuyers ADDED DEFAULT DATA: fileCategories: FILES_CATEGORY_AERIAL_PHOTO, FILES_CATEGORY_AERIAL_FILM MOVED DATA: viewingContacts.description & bidders.comment => buyers.description ======================================================================================================================== Version: #104 DATA STRUCTURE: deals: added column - webPageImagesURL ======================================================================================================================== Version: #103 DATA STRUCTURE: estates: added columns - isSharedOwnership, sharedOwnershipDescription buildings: added column - isCommercialBuilding | modified columns - showOnlyCommentInObjectDescription, showOnlyBuildingCommentInObjectDescription (changed to not null with default false) bidders: modified column - sendInformationWebsite (changed to not null with default false) capitalGainCalculations: added column - saleApartmentEquipment contactSmsNumbers: modified columns - id (changed to not null), contactId (correct int setting, added FK), phoneNumber (correct length) customFields: added column - lookupURL ADDED TABLES: eventGenericConnection, filesInCustomFields ======================================================================================================================== Version: #102 UPDATE PURPOSE: REFACTOR BIDDING, bidding 2.0 DATA STRUCTURE: biddings: added columns - allowWebsiteBids, allowSMSBids, displayBiddingOnWebsite, displayBiddingOnWebsite, hideBidsOnWebsite, displayBiddingOnMarketingPlaces, dealId dropped columns - identifier, startDate, createdDate, createdByUserId, isActive, bidBroadcastThreshold, languageId, currency, isPublished, hideBids bidders: added columns - buyerId, sendInformationBySMS, sendInformationByEmail, allowBidsFromWebsite, allowBidsFromSMS, acceptAutomaticBids, sendInformationWebsite, comment dropped columns - hasInformationChannelSMS, hasInformationChannelEmail, isActive, isInternetBidder, showInternetBidAutomaticly, isSmsBidder, showSmsBidAutomaticly, emailAddress, phoneNumber buyerGroups: added columns - bidderAlias, selectedBidder dropped columns - identifier sellers: added columns - sendBiddingInformationBySMS, sendBiddingInformationByEmail teamRoles: added columns - sendBiddingInformationBySMS, sendBiddingInformationByEmail dopped columns - retrieveBiddingInformation ADDED TABLES: contactSmsNumbers MOVED DATA: biddings.isPublished -> displayBiddingOnWebsite biddings.hideBids -> hideBidsOnWebsite bidders.hasInformationChannelSMS -> sendInformationBySMS bidders.hasInformationChannelEmail -> sendInformationByEmail bidders.isInternetBidder -> sendInformationWebsite bidders.isInternetBidder -> allowBidsFromWebsite bidders.isSmsBidder -> allowBidsFromSMS bidders.showInternetBidAutomaticly -> acceptAutomaticBids bidders.showSmsBidAutomaticly -> acceptAutomaticBids bidders.contactId & bidders.buyerGroupId -> buyerId buyerGroups.identifier -> bidderAlias teamRoles.retrieveBiddingInformation -> sendBiddingInformationBySMS & sendBiddingInformationByEmail DEPRECATED FIELDS: bidders.contactId bidders.buyerGroupId ======================================================================================================================== Version: #101 Applied: 2015-08-24 DATA STRUCTURE: organizationUnits: added columns - defaultMapLatitude, defaultMapLongitude deals: added columns - capitalGainCalculationId, legalEntityAcceptableSetting, webPageURL housingAssociations: added column - legalEntityAcceptableSetting estates: added column - zoomLevel buildings: added column - parentId, showOnlyCommentInObjectDescription, showOnlyBuildingCommentInObjectDescription customFields: added columns - documentVariableName, documentVariableText documents: added column - organizationUnitId invoices: added column - includeEstateAddress marketValuations: added columns - printHeadline, finalValueAssessment viewingContacts: added column - description organizations: added column - defaultMapLatitude, defaultMapLongitude ADDED TABLES: dealAdditions, filesInHousingAssociationBuildings, organizationSidelines, organizationUnitSidelines MOVED DATA: deals.isLegalEntityOK -> legalEntityAcceptableSetting housingAssociations.isLegalEntityOK -> legalEntityAcceptableSetting DEPRECATED FIELDS: deals.isLegalEntityOK housingAssociations.isLegalEntityOK ======================================================================================================================== Version: #100 Applied: 2015-07-06 DATA STRUCTURE: matchings: added column - isInternational housingAssociations: added columns - communications, yearlyRent, loans, loansPerAreaUnit estates: added column - housingAssociationFoundedYear deals: added column - approveMarketingOfFinalPrice, approveMarketingOfDeal contacts: added column - ignoreDuplicateCheck customFields: added column - customFieldsGroupId dealReceipts: added column - createdDate invoices: added column - createdDate letters: added column - createdDate organizations: added column - isMaklarsamfundetMember ADDED TABLES: capitalGainCalculations, customFieldsGroups, housingAssociationUrls, sidelines DROPPED TABLES: capitalGainCalculation ======================================================================================================================== Version: #99 Applied: 2015-06-15 DATA STRUCTURE: organizationUnits: added column - fTaxVATDescription commissions: added column - isSoldWithoutVAT deals: dropped column - isSoldWithoutVAT | added columns - sellingMethodIsQuotation,sellingMethodQuotationDateTime,sellingMethodIsBid,sellingMethodBidDateTime,sellingMethodIsInterest,sellingMethodInterestDateTime,sellingMethodIsFixedPrice,sellingMethodIsOpenBidding, sellingMethodIsPublicAuction, sellingMethodPublicAuctionDateTime, sellingMethodDescription, sellingMethodTermsOfPayment housingAssociation: added column - websiteURL contacts: added column - homePhoneNumber areas: modified column - overallType(type along) loans: modified column - financialInstitution(length 100) marketValuations: added column - signatureDate organizations: added column - fTaxVATDescription DROPPED TABLES: propertyToolWorkingPages, propertyToolWorkingTemplates, propertyToolPageTemplateLayout, propertyToolPages propertyToolLayouts, propertyToolTemplates ======================================================================================================================== Version: #98 Applied: 2015-05-25 MOVED DATA: estates.premiseEconomyValuesIsInVAT -> premiseEconomyValuesVATSetting buildings.surroundingComment && buildings.premiseComment -> technicalDescription DEPRECATED FIELDS: estates.premiseEconomyValuesIsInVAT buildings.surroundingComment buildings.premiseComment ======================================================================================================================== Version: #97 Applied: 2015-05-25 DATA STRUCTURE: estates: added columns - businessDescription, premiseEconomyValuesVATSetting, communications, pawnedSetting | modified columns: keyComment(now text) files: added columns - isMarketing areas: added columns - overallType buildings: added columns - technicalDescription dealReceipts: added columns - otherSignee easementsAndDetails: modified columns - description(now text) estateTenants: modified columns - vatSettings marketValuations: added columns - valuationDate organizations: modified columns - technicalContactEmail(400 maxLength now) associationDocuments: added columns - description ======================================================================================================================== Version: #96 Applied: 2015-05-08 DATA STRUCTURE: estates: added columns - insuranceDescription organizationUnits: added columns - archiveNumber deals: added columns - archiveNumber estateTenants: added columns - displayOrder organizations: added columns - archiveNumber userAccounts: added columns - claimedIdentifier marketValuations: added columns - printExtendedInformation, valuationPurposeDescription, preconditionsDescription, descriptionDescription, inspectionDescription, otherSourcesDescription, other, valuationDescription, partValuesDescription, finalValuationDescription, residentialBuildingValue, economyBuildingValue, forestValue, fieldValue, fencedFieldValue, plotValue, mainBuildingValue, impedimentForestValue, pastureValue ADDED DEFAULT DATA: estateEconomicTypeCoes: added code - 225, 230 ======================================================================================================================== Version: #95 Applied: 2015-04-22 ADDED TABLES: contactOrganizationUnits DATA STRUCTURE: estates: added columns - isPartOf | modified columns - groundRentPeriod(text instead of year) farmingSpecifics: added columns - forestProductivity invoices: added columns - createdByUserId marketValuations: added columns - acreageDescription staff: added columns - activityFraction organizations: added columns - invoicingChargeForUsers ======================================================================================================================== Version: #94 Applied: 2015-04-07 ADDED TABLES: organizationUnitInvoices, organizationInvoices, dealInvoices DATA STRUCTURE: viewings: added columns - contactBrokerForViewing organizationUnits: added columns - printDocumentHeaderLogoFileId, streetAddress, postalCode, city deals: added columns - accessOfficerContactId, accessLocationContactId | dropped columns - accessOfficerId customFields: added columns - organizationUnitId invoiceAmounts: added columns - invoiceId | dropped columns - dealInvoiceId invoiceNumbers: added columns - invoiceId | dropped columns - dealInvoiceId RENAMED TABLES: dealInvoices -> invoices dealInvoiceAmounts -> invoiceAmounts dealInvoiceNumber -> invoiceNumbers ADDED DEFAULT DATA: organizationUnits: set city to invoiceCity invoiceAmounts: moved dealInvoiceId to invoiceId invoiceNumbers: moved dealInvoiceId to invoiceId dealInvoices: populated dealId and invoiceId from invoices ======================================================================================================================== Version: #93 Applied: 2015-03-30 ADDED TABLES: licenseInvoices DATA STRUCTURE: estates: added columns - isTenureHouse, tenureHouseCost, tenureHousePeriod, tenureHouseLandLord, tenureHouseEndDate dealReceipts: added column - signeeCompanyDescription patios: added column - displayOrder ======================================================================================================================== Version: #92 Applied: 2015-03-24 ADDED TABLES: dealInvoiceNumbers DATA STRUCTURE: dealInvoices: modified columns - number organizationUnits: added column - invoiceNumberIncrement matchingAttributes: added column - organizationUnitId dealReceipts: added column - hideVATCalculation organizationFiles: added column - organizationUnitId organizations: added columns - invoiceNumberIncrement, envelopeType associationDocuments: added column - organizationUnitId ======================================================================================================================== Version: #91 Applied: 2015-03-16 ADDED TABLES: estatePremiseEconomyAmounts, letterTemplates, letterTemplateObjectTypes DATA STRUCTURE: commissions: added columns - companyCutPercentage, showSplitInReports commissionCuts: modified columns - commissionId, contactId | dropped columns - percentageAmmount, toCompany estates: added columns - housingAssociationName, premiseType, premiseNumber, moduleArea, premiseTypeText, floorPlanDescription, localServicesDescription, displayPremiseRentAs, premiseIndex, premiseEconomyValuesIsInVAT, tenantOwnershipLandComment memoPad: added columns - userAccountId staff: added columns - isAdminOnUnit ADDED DEFAULT DATA: objectTypes: OBJECT_TYPE_PREMISE objectSubTypes: OBJECTSUBTYPES_PREMISE_PREMISE_FOR_RENT, OBJECTSUBTYPES_PREMISE_PREMISE_FOR_SALE, OBJECTSUBTYPES_PREMISE_BUSINESS_FOR_SALE, OBJECTSUBTYPES_PREMISE_TENANT_PREMISE_FOR_SALE ======================================================================================================================== Version: #90 Applied: 2015-03-10 DATA STRUCTURE: estates: modified columns - heatingPlantAge buildings: modified columns - heatingPlantAge marketValuations: added columns - assessmentYear, buildingDescription ======================================================================================================================== Version: #89 Applied: 2015-03-09 ADDED TABLES: dealReceipts, dealReceiptAmounts DATA STRUCTURE: organizationUnits: added columns - invoiceTermsOfPayment contacts: added columns - organizationUnitId, tags amounts: modified columns - amount, title no longer mandatory dealInvoices: added columns - invoiceTermsOfPayment marketValuations: added columns - generalInformation sellerDealSignatures: added columns - isSpouseSignature organizations: added columns - allowInsecureLoginMethod, ssoChallengeUrl ADDED DEFAULT DATA: webhome: WEBHOME_SECTION_BG_COLOR accessRights: ACCESS_RIGHT_ORGANIZATION_UNIT_ADMIN ======================================================================================================================== Version: #88 Applied: 2015-03-03 DATA STRUCTURE: services.identifier is now unique ADDED DEFAULT DATA: services: SERVICES_IDENTIFIER_LANTMATERIET_MAPS_ESTATE_KM2 ======================================================================================================================== Version: #87 Applied: 2015-02-25 DATA STRUCTURE: dealInvoices: modified columns - plusgiroNumber and bankgiroNumber to varchar instead of int organizationUnits: modified columns - plusgiroNumber and bankgiroNumber to varchar instead of int organizations: modified columns - plusgiroNumber and bankgiroNumber to varchar instead of int ======================================================================================================================== Version: #86 Applied: 2015-02-23 ADDED TABLES: viewingAttendees, letters DATA STRUCTURE: parkingSpaces: added columns - totalRevenue organizationUnits: modified columns - invoiceNumber dealInvoices: added columns - recipient, plusgiroNumber, bankgiroNumber, period | modified columns - number, date, dueDate, paidDate organizations: modified columns - invoiceNumber ======================================================================================================================== Version: #85 Applied: 2015-02-19 DATA STRUCTURE: estates: added column - electricityConsumption deals: added column - isHidden dealInvoices: added column - vatPercentage dealInvoiceAmounts: added column - quantity newspaperAds: added column - advertisingDate organizations: added column - invoiceTermsOfPayment userAccounts: added column - dealId ======================================================================================================================== Version: #84 Applied: 2015-02-13 ADDED TABLES: dealCostAmounts REMOVED TABLES: commissionSupplements DATA STRUCTURE: amounts: modified columns - title commissions: added columns - showBrokerAccountInSettlement | removed columns - showBrokerAccountInSettlement estates: added columns - assessValueDescription deals: added columns - isSoldWithoutVAT ======================================================================================================================== Version: #83 Applied: 2015-02-12 DATA STRUCTURE: estateTenantsSubObjectTypes.name is now unique ADDED DEFAULT DATA: estateTenantsSubObjectTypes: ESTATE_TENANTS_SUB_OBJECT_TYPES_OFFICE ======================================================================================================================== Version: #82 Applied: 2015-02-09 ADDED TABLES: sellerDealSignatures, companyContacts, buyerDealSignatures, dealSignatures DATA STRUCTURE: sellers: added columns - spouseConsentSignature viewings: added columns - viewingSignDescription mortgages: added columns - logEntryId | modified columns - externalId marketValuations: addeded columns - numberOfApartments, apartmentNumber | modified columns - waterType, drainType, heatingType, renovateYear estateTenants: addeded columns - vatSettings easementsAndDetails: addeded columns - logEntryId | modified columns - externalId contactSignees: addeded columns - displayOrder buildings: modified columns - subFoundationType, foundationType, roofingType, facadeType, windowsType, joistType, guttersType, frameType, waterType, drainType, heatingType estates: modified columns - renovateYear, subFoundationType, foundationType, roofingType, facadeType, windowsType, joistType, guttersType, frameType, waterType, drainType, heatingType deals: addeded columns - buyerApprovalByTennantSentDate, vatPercentage organizationUnits: addeded columns - vatPercentage commissions: added columns - discountAmount, isDiscountInPercentage contacts: added columns - isExternalContact, externalId organizations: modified columns - vatPercentage ADDED DEFAULT DATA: webhome: WEBHOME_HEADER_COLOR_INPUT_AREA, WEBHOME_HEADER_COLOR_BROKER_AREA_BG ======================================================================================================================== Version: #81 Applied: 2015-02-02 ADDED TABLES: contactSignees, buyerContactSignees, marketValuationCustomers, sellerContactSignees REMOVED TABLES: buyerContactRepresentatives, sellerContactRepresentatives, contactRepresentatives DATA STRUCTURE estates: added columns - isAllYear deals: added columns - importedDate, importedName | modified columns - isDownPaymentInBrokerClientAccount sellers: added columns - spouseConsentNeeded ADDED DEFAULT DATA: new estateTenantsSubObjectTypes: ESTATE_TENANTS_SUB_OBJECT_TYPES_SCHOOL_OR_PRE_SCHOOL ======================================================================================================================== Version: #80 Applied: 2015-01-19 ADDED TABLES: pushTrail DATA STRUCTURE estates: modified columns - heatingType dealCashDefinitiveStatementAmounts: added columns - dealCashDefinitiveStatementAmounts ADDED DEFAULT DATA: new fileCategories: FILES_CATEGORY_MAP_FOREST, FILES_CATEGORY_MAP_PROPERTY, FILES_CATEGORY_MAP_OVERVIEW, FILES_CATEGORY_MAP_OTHER, FILES_CATEGORY_FORM_QUOTATION, FILES_CATEGORY_FORM_INTEREST, FILES_CATEGORY_FORM_BIDDING ======================================================================================================================== Version: #79 Applied: 2015-01-17 ALTERED TABLES: estates: added columns - feeChanges contacts: added columns - housingAssociationId organizations: added columns - suspendedDate ======================================================================================================================== Version: #78 Applied: 2015-01-12 ALTERED TABLES: organizations: added columns - printCity, documentFooterLeft, documentFooterCenter, documentFooterRight userAccounts: added columns - createdDate | dropped columns - supportWindowEndDate housingAssociationContacts: added columns - contactInformation | modified columns - housingAssociationId estates: added columns - repairFundDescription capitalGainCalculation: added columns - id housingAssociationBuildings: added columns - doorCode housingAssociations: added columns - locationDescription, directions organizationUnits: added columns - printCity, documentFooterLeft, documentFooterCenter, documentFooterRight ADDED TABLES: organizationFiles, marketValuations ADDED DEFAULT DATA: new objectSubType: OBJECTSUBTYPES_CONDOMINIUM_SEMI-DETACHED for TENANT OWNERSHIP MOVED DATA: housingAssociationContacts.contactId to housingAssociationContacts.contactInformation ======================================================================================================================== Version: #77 Applied: 2015-01-08 ALTERED TABLES: estates: added columns - polygonListJSON ADDED TABLES: capitalGainCalculation ======================================================================================================================== Version: #75 Applied: 2014-12-17 DATA STRUCTURE: commissions: added columns - commissionBaseFee, commissionType DEPRECATED FIELDS commissions.isCommissionSumSetManually ======================================================================================================================== Version: #74 Applied: 2014-11-26 ADDED TABLES: dealInvoices, dealInvoiceAmounts, housingAssociationGeographicalAreas, matchingAttributesEstate DATA STRUCTURE buildings: modified column - numberOfBedrooms INT(3) amounts: added column - excludeVAT BIT rooms: modified column - fitsMaxNumberPers INT(3) deals: added columns - isVIP BIT, archiveExternalId VARCHAR(200) organizationUnits: added columns - plusgiroNumber int(8), bankgiroNumber int(8), penaltyInterest decimal(8,5), dueDays int(11), invoiceNumber bigint(20) unsigned estates: added column - isInternetIncluded BIT | altered columns - buildYear varchar(20), (Fixed int length) numberOfBedrooms, convertNumberOfBedRooms, floorsInTotal, staircaseTotal, liftMaxPersons, liftMaxLoad housingAssociationBuildings: altered columns - description TEXT | added columns - streetAddress VARCHAR(100), postalCode VARCHAR(20), city VARCHAR(100), displayOrder INT(11) housingAssociations: added column - parkingDescription TEXT buyerGroups: added column - displayName VARCHAR(100) contacts: added column - isSystem BIT organizations: added columns - plusgiroNumber int(8), bankgiroNumber int(8), penaltyInterest decimal(8,5), dueDays int(11), invoiceNumber bigint(20) unsigned userAccounts: added column - isSystem BIT ADDED DEFAULT DATA: new objectSubType: OBJECTSUBTYPES_HOUSING_COOPERATIVE_CONDOMINIUM for TENANT OWNERSHIP new webhome data: WEBHOME_HEADER_TEMPLATE_MENU, WEBHOME_HEADER_TEMPLATE_LIST, WEBHOME_HEADER_TEMPLATE_DEALS_SEARCH ======================================================================================================================== Version: #73 Applied: 2014-11-12 DEPRECATED FIELDS matchings.minLatitude matchings.minLongitude matchings.maxLatitude matchings.maxLongitude deals.isAcceptedStartingPrice buyers.mortgageCommitmentAmount estates.isTransferFeePaidBySeller estates.isPledgingFeePaidBySeller housingAssociations.hasLift housingAssociations.heatAndAirConditionFacilityComment housingAssociations.internetSummary housingAssociations.maxFloors housingAssociations.buildYear housingAssociations.liftComment housingAssociations.buildingComment housingAssociations.energyClass housingAssociations.energyPerformance housingAssociations.energyDescription housingAssociations.energyStatus housingAssociations.energyStatusDate housingAssociations.energyStatusEntrepreneur housingAssociations.energyStatusSummary DATA STRUCTURE Added tables: housingAssociationBuildings, estateParkingSpaces, housingAssociationsParkingSpaces estateTenants: modified columns - area, livingArea, otherLivingArea estateTenantsSubObjectTypes: added columns - isUserDefined parkingSpaces: removed columns - estateId buyers: added columns - mortgageCommitmentComment buildings: added columns - classification estates: added columns - housingAssociationBuildingId, otherBuildings, description, isCableTVIncluded, bboxObjectJSON, transferFeePaidBy, pledgingFeePaidBy housingAssociations: modified columns - buildYear | added columns - updatedByContactId, manuallyUpdatedDate deals: added columns - externalId matchings: added columns - polygonListJSON organizations: added columns - limitVisibilityToOrganizationalUnits, useIpAddressFilter DATA TRANSFER moved data from housingAssociations -> housingAssociationBuildings moved data from parkingSpaces -> connection table estateParkingSpaces estates.isTransferFeePaidBySeller -> estates.transferFeePaidBy estates.isPledgingFeePaidBySeller -> estates.pledgingFeePaidBy isAcceptedStartingPrice -> startingPriceType mortgages.createdDate -> mortgages.registrationDate NEW DATA fileCategories: FILES_CATEGORY_PROPERTY_MAP ========================================================================================================================