This is an old revision of the document!
Analyse indexes
Full
ALTER TABLE `Analyse` ADD KEY `status` (`status`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Ansprechpartner` ADD KEY `gesellschaftId` (`gesellschaftId`); ALTER TABLE `ApplicationState` ADD KEY `loginId` (`loginId`); ALTER TABLE `Arbeitgeber` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Asset` ADD KEY `angebotsType` (`angebotsType`), ADD KEY `tarifTypeId` (`tarifTypeId`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `AssetAttribut` ADD KEY `fx_assetattribut_assetId` (`assetId`); ALTER TABLE `Bankverbindung` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Bedarf` ADD KEY `analyseId` (`analyseId`); ALTER TABLE `BedarfAttribut` ADD KEY `bedarfId` (`bedarfId`); ALTER TABLE `Berater` ADD KEY `salutationId` (`salutationId`), ADD KEY `efpId` (`efpId`); ALTER TABLE `BeraterAction` ADD KEY `mandantId` (`mandantId`), ADD KEY `beraterId` (`beraterId`), ADD KEY `assetId` (`assetId`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `BeraterAssistant` ADD KEY `beraterId` (`beraterId`), ADD KEY `assistantId` (`assistantId`); ALTER TABLE `BeraterBeraterRole` ADD PRIMARY KEY (`beraterId`,`beraterRoleId`); ALTER TABLE `BeraterHomepage` ADD KEY `beraterId` (`beraterId`); ALTER TABLE `BeraterSnippet` ADD KEY `beraterId` (`beraterId`); ALTER TABLE `BeraterVorgesetzter` ADD KEY `beraterId` (`beraterId`), ADD KEY `vorgesetzterId` (`vorgesetzterId`); ALTER TABLE `Bestandsuebertragung` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `BestandsuebertragungAsset` ADD KEY `bestandsuebertragungId` (`bestandsuebertragungId`), ADD KEY `assetId` (`assetId`); ALTER TABLE `CalculationProfile` ADD KEY `beraterId` (`beraterId`), ADD KEY `contextId` (`contextId`), ADD KEY `tariftype` (`tariftype`(255)); ALTER TABLE `CalculationResults` ADD KEY `assetId` (`assetId`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Context` ADD KEY `uuid` (`uuid`), ADD KEY `parentContextId` (`parentContextId`); ALTER TABLE `ContextAttribut` ADD KEY `contextId` (`contextId`); ALTER TABLE `ContextSubContext` ADD KEY `contextId` (`contextId`), ADD KEY `parentContextId` (`parentContextId`); ALTER TABLE `Dokument` ADD KEY `analyseId` (`analyseId`), ADD KEY `synchId` (`synchId`); ALTER TABLE `DokumentAttribut` ADD KEY `dokumentId` (`dokumentId`); ALTER TABLE `Empfehlung` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ErweiterteBerufsfragen` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `EventLog` ADD KEY `loginId` (`loginId`,`sessionId`); ALTER TABLE `EventLogParam` ADD KEY `eventLogId` (`eventLogId`); ALTER TABLE `ExternalId` ADD KEY `system` (`system`(255)), ADD KEY `mandantId` (`mandantId`), ADD KEY `assetId` (`assetId`), ADD KEY `analyseId` (`analyseId`), ADD KEY `loginId` (`loginId`), ADD KEY `mandantGroupId` (`mandantGroupId`), ADD KEY `mandantMandantGroupId` (`mandantMandantGroupId`), ADD KEY `bankverbindungId` (`bankverbindungId`), ADD KEY `externalId` (`externalId`(255)); ALTER TABLE `ExternalProductId` ADD KEY `efpId` (`efpId`), ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `productId` (`productId`), ADD KEY `contextId` (`contextId`); ALTER TABLE `File` ADD KEY `fk_File_Berater` (`beraterId`), ADD KEY `analyseId` (`analyseId`), ADD KEY `mandantId` (`mandantId`), ADD KEY `assetId` (`assetId`), ADD KEY `innolink` (`innolink`(255)), ADD KEY `folder` (`folder`), ADD KEY `groupId` (`groupId`), ADD KEY `purpose` (`purpose`), ADD KEY `synchId` (`synchId`); ALTER TABLE `GandavVBeruf` ADD KEY `such` (`such`(255)); ALTER TABLE `Gesellschaft` ADD KEY `contextId` (`contextId`); ALTER TABLE `GesellschaftTarifTypeId` ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `tarifTypeId` (`tarifTypeId`(255)); ALTER TABLE `Handlungsempfehlung` ADD KEY `analyseId` (`analyseId`), ADD KEY `tarifTypeId` (`tarifTypeId`), ADD KEY `aktuelAssetId` (`aktuelAssetId`); ALTER TABLE `IhreErwartungen` ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `InnoFilter` ADD KEY `gesnr` (`gesnr`), ADD KEY `tarifTypeId` (`tarifTypeId`(255)), ADD KEY `contextId` (`contextId`); ALTER TABLE `InsignSession` ADD KEY `session` (`session`(255)); ALTER TABLE `IntegerIdMapping` ADD KEY `uuid` (`uuid`); ALTER TABLE `Kontakt` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Kundenbedarf` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Login` ADD UNIQUE KEY `login` (`login`), ADD KEY `beraterId` (`beraterId`), ADD KEY `contextId` (`contextId`), ADD KEY `sessionId` (`sessionId`), ADD KEY `mobileSessionId` (`mobileSessionId`); ALTER TABLE `LoginAttribut` ADD KEY `loginId` (`loginId`); ALTER TABLE `Mandant` ADD KEY `userId` (`beraterId`), ADD KEY `username` (`username`), ADD KEY `mandantSessionId` (`mandantSessionId`); ALTER TABLE `MandantAttribut` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `MandantBerechnung` ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `MandantGroup` ADD KEY `efpId` (`efpId`); ALTER TABLE `MandantMandantGroup` ADD KEY `fk_MandantMandantGroup_MandantGroup` (`groupeId`), ADD KEY `fk_MandantGruppe_Mandant` (`mandantId`); ALTER TABLE `PlzData` ADD KEY `plz` (`plz`), ADD KEY `ort` (`ort`(255)); ALTER TABLE `ProductId` ADD KEY `efpId` (`efpId`), ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `contextId` (`contextId`); ALTER TABLE `RequestLog` ADD KEY `beraterId` (`beraterId`), ADD KEY `logtype` (`logtype`), ADD KEY `efpId` (`efpId`); ALTER TABLE `Sammelmappe` ADD KEY `analyseId` (`analyseId`); ALTER TABLE `SeminarAttendance` ADD KEY `beraterId` (`beraterId`), ADD KEY `eventId` (`eventId`); ALTER TABLE `ServerMessage` ADD KEY `loginId` (`loginId`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Steuern` ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `UserAnalyse` ADD KEY `analyseId` (`analyseId`); ALTER TABLE `Verlauf` ADD KEY `mandantId` (`mandantId`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Vorschaeden` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Wiedervorlage` ADD KEY `externeReferenz` (`externeReferenz`), ADD KEY `assetId` (`assetId`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ZielWunsch` ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ZielWunschAttribut` ADD KEY `zielwunschId` (`zielwunschId`);
Without Primary Key
ALTER TABLE `Analyse` ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Ansprechpartner` ADD PRIMARY KEY (`id`), ADD KEY `gesellschaftId` (`gesellschaftId`); ALTER TABLE `ApplicationState` ADD PRIMARY KEY (`id`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Arbeitgeber` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Asset` ADD PRIMARY KEY (`id`), ADD KEY `angebotsType` (`angebotsType`), ADD KEY `tarifTypeId` (`tarifTypeId`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `AssetAttribut` ADD PRIMARY KEY (`id`), ADD KEY `fx_assetattribut_assetId` (`assetId`); ALTER TABLE `AssetAusbildung` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetDreadDisease` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetPrivatrente` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetRiester` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetRisiko` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetRuerup` ADD PRIMARY KEY (`id`); ALTER TABLE `AssetUnfall` ADD PRIMARY KEY (`id`); ALTER TABLE `Bankverbindung` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Bedarf` ADD PRIMARY KEY (`id`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `BedarfAsset` ADD PRIMARY KEY (`bedarfId`,`assetId`); ALTER TABLE `BedarfAttribut` ADD PRIMARY KEY (`id`), ADD KEY `bedarfId` (`bedarfId`); ALTER TABLE `Berater` ADD PRIMARY KEY (`id`), ADD KEY `salutationId` (`salutationId`), ADD KEY `efpId` (`efpId`); ALTER TABLE `BeraterAction` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`), ADD KEY `beraterId` (`beraterId`), ADD KEY `assetId` (`assetId`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `BeraterAssistant` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`), ADD KEY `assistantId` (`assistantId`); ALTER TABLE `BeraterBeraterRole` ADD PRIMARY KEY (`beraterId`,`beraterRoleId`); ALTER TABLE `BeraterHomepage` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`); ALTER TABLE `BeraterHomepageTeam` ADD PRIMARY KEY (`beraterHomepageId`,`beraterId`); ALTER TABLE `BeraterRole` ADD PRIMARY KEY (`id`); ALTER TABLE `BeraterSnippet` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`); ALTER TABLE `BeraterVorgesetzter` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`), ADD KEY `vorgesetzterId` (`vorgesetzterId`); ALTER TABLE `Bestandsuebertragung` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `BestandsuebertragungAsset` ADD PRIMARY KEY (`id`), ADD KEY `bestandsuebertragungId` (`bestandsuebertragungId`), ADD KEY `assetId` (`assetId`); ALTER TABLE `CalculationProfile` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`), ADD KEY `contextId` (`contextId`), ADD KEY `tariftype` (`tariftype`(255)); ALTER TABLE `CalculationResults` ADD PRIMARY KEY (`id`), ADD KEY `assetId` (`assetId`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Context` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`), ADD KEY `parentContextId` (`parentContextId`); ALTER TABLE `ContextAttribut` ADD PRIMARY KEY (`id`), ADD KEY `contextId` (`contextId`); ALTER TABLE `ContextSubContext` ADD PRIMARY KEY (`id`), ADD KEY `contextId` (`contextId`), ADD KEY `parentContextId` (`parentContextId`); ALTER TABLE `Dokument` ADD PRIMARY KEY (`id`), ADD KEY `analyseId` (`analyseId`), ADD KEY `synchId` (`synchId`); ALTER TABLE `DokumentAttribut` ADD PRIMARY KEY (`id`), ADD KEY `dokumentId` (`dokumentId`); ALTER TABLE `Empfehlung` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ErweiterteBerufsfragen` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `EventLog` ADD PRIMARY KEY (`id`), ADD KEY `loginId` (`loginId`,`sessionId`); ALTER TABLE `EventLogParam` ADD PRIMARY KEY (`id`), ADD KEY `eventLogId` (`eventLogId`); ALTER TABLE `ExpertCondition` ADD PRIMARY KEY (`id`); ALTER TABLE `ExternalGesellschaft` ADD PRIMARY KEY (`id`); ALTER TABLE `ExternalId` ADD PRIMARY KEY (`id`), ADD KEY `system` (`system`(255)), ADD KEY `mandantId` (`mandantId`), ADD KEY `assetId` (`assetId`), ADD KEY `analyseId` (`analyseId`), ADD KEY `loginId` (`loginId`), ADD KEY `mandantGroupId` (`mandantGroupId`), ADD KEY `mandantMandantGroupId` (`mandantMandantGroupId`), ADD KEY `bankverbindungId` (`bankverbindungId`), ADD KEY `externalId` (`externalId`(255)); ALTER TABLE `ExternalProductId` ADD PRIMARY KEY (`id`), ADD KEY `efpId` (`efpId`), ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `productId` (`productId`), ADD KEY `contextId` (`contextId`); ALTER TABLE `File` ADD PRIMARY KEY (`id`), ADD KEY `fk_File_Berater` (`beraterId`), ADD KEY `analyseId` (`analyseId`), ADD KEY `mandantId` (`mandantId`), ADD KEY `assetId` (`assetId`), ADD KEY `innolink` (`innolink`(255)), ADD KEY `folder` (`folder`), ADD KEY `groupId` (`groupId`), ADD KEY `purpose` (`purpose`), ADD KEY `synchId` (`synchId`); ALTER TABLE `Folder` ADD PRIMARY KEY (`id`); ALTER TABLE `GandavVBeruf` ADD PRIMARY KEY (`id`), ADD KEY `such` (`such`(255)); ALTER TABLE `GandavVBeruf_old` ADD PRIMARY KEY (`id`); ALTER TABLE `Gesellschaft` ADD PRIMARY KEY (`id`), ADD KEY `contextId` (`contextId`); ALTER TABLE `GesellschaftTarifTypeId` ADD PRIMARY KEY (`id`), ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `tarifTypeId` (`tarifTypeId`(255)); ALTER TABLE `Handlungsempfehlung` ADD PRIMARY KEY (`id`), ADD KEY `analyseId` (`analyseId`), ADD KEY `tarifTypeId` (`tarifTypeId`), ADD KEY `aktuelAssetId` (`aktuelAssetId`); ALTER TABLE `IhreErwartungen` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `InnoBeruf` ADD PRIMARY KEY (`id`); ALTER TABLE `InnoFilter` ADD PRIMARY KEY (`id`), ADD KEY `gesnr` (`gesnr`), ADD KEY `tarifTypeId` (`tarifTypeId`(255)), ADD KEY `contextId` (`contextId`); ALTER TABLE `InsignSession` ADD PRIMARY KEY (`id`), ADD KEY `session` (`session`(255)); ALTER TABLE `IntegerIdMapping` ADD PRIMARY KEY (`id`), ADD KEY `uuid` (`uuid`); ALTER TABLE `Kontakt` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Kundenbedarf` ADD PRIMARY KEY (`mandantId`), ADD UNIQUE KEY `id_ndx` (`id`); ALTER TABLE `Login` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `login` (`login`), ADD KEY `beraterId` (`beraterId`), ADD KEY `contextId` (`contextId`), ADD KEY `sessionId` (`sessionId`), ADD KEY `mobileSessionId` (`mobileSessionId`); ALTER TABLE `LoginAttribut` ADD PRIMARY KEY (`id`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Mandant` ADD PRIMARY KEY (`id`), ADD KEY `userId` (`beraterId`), ADD KEY `username` (`username`), ADD KEY `mandantSessionId` (`mandantSessionId`); ALTER TABLE `MandantAttribut` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `MandantBerechnung` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `MandantGroup` ADD PRIMARY KEY (`id`), ADD KEY `efpId` (`efpId`); ALTER TABLE `MandantMandantGroup` ADD PRIMARY KEY (`id`), ADD KEY `fk_MandantMandantGroup_MandantGroup` (`groupeId`), ADD KEY `fk_MandantGruppe_Mandant` (`mandantId`); ALTER TABLE `PlzData` ADD PRIMARY KEY (`id`), ADD KEY `plz` (`plz`), ADD KEY `ort` (`ort`(255)); ALTER TABLE `ProductId` ADD PRIMARY KEY (`id`), ADD KEY `efpId` (`efpId`), ADD KEY `gesellschaftId` (`gesellschaftId`), ADD KEY `contextId` (`contextId`); ALTER TABLE `RequestLog` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`), ADD KEY `logtype` (`logtype`), ADD KEY `efpId` (`efpId`); ALTER TABLE `Salutation` ADD PRIMARY KEY (`id`); ALTER TABLE `Sammelmappe` ADD PRIMARY KEY (`id`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `SeminarAttendance` ADD PRIMARY KEY (`id`), ADD KEY `beraterId` (`beraterId`), ADD KEY `eventId` (`eventId`); ALTER TABLE `ServerMessage` ADD PRIMARY KEY (`id`), ADD KEY `loginId` (`loginId`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Steuern` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `mandantId` (`mandantId`); ALTER TABLE `UserAnalyse` ADD PRIMARY KEY (`userId`,`analyseId`), ADD KEY `analyseId` (`analyseId`); ALTER TABLE `Verlauf` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`), ADD KEY `loginId` (`loginId`); ALTER TABLE `Vorschaeden` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `Wiedervorlage` ADD PRIMARY KEY (`id`), ADD KEY `externeReferenz` (`externeReferenz`), ADD KEY `assetId` (`assetId`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ZielWunsch` ADD PRIMARY KEY (`id`), ADD KEY `mandantId` (`mandantId`); ALTER TABLE `ZielWunschAttribut` ADD PRIMARY KEY (`id`), ADD KEY `zielwunschId` (`zielwunschId`);