Domů Procházet Nápověda
Přihlásit se
AIPlatform_SDK
/
AIPlatform
2
0
Rozštěpit 0
Soubory Úkoly 0 Pull Requesty 0 Wiki
Strom: 13f455dd61
Větve Značky
AIPlatform
/
CreateDBIndexes.txt

CreateDBIndexes.txt 10 KB
Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118 
  1. //ArchivedImage
    2. 

  2. db.getCollection("ArchivedImages").createIndex({ "IsDeleted": -1,"OrganizationId": 1,"HashCode": 1})
    3. 

  3. 

  4. //UltrasoundFile
    5. 

  5. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.IsLabeled": 1,"Labeled": -1,"IsAdoptable": 1,"GoldStandardLabeledFileId": 1})
    6. 

  6. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.IsLabeled": 1,"Labeled": -1,"Source.FileName": 1, "HasQuestioned": 1,"HasPendingConfirmed": 1,"CreateTime": -1})
    7. 

  7. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.HasSeen": 1,"HasSeen": 1,"Source.FileName": 1 })
    8. 

  8. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.IsSkipped": 1,"IsSkipped": 1,"Source.FileName": 1 })
    9. 

  9. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.IsLabeled": 1,"GoldStandardLabeledFileId": 1,"Source.FileName": 1, "CreateTime": -1})
    10. 

  10. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseInfos._id": 1,"ImageCaseInfos.IsLabeled": 1,"Assigned": 1,"GoldStandardLabeledFileId": 1, "CreateTime": 1})
    11. 

  11. db.getCollection("UltrasoundFiles").createIndex({ "_id": 1,"GoldStandardLabeledFileId": 1})
    12. 

  12. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageBatchId": 1, "UpdateTime": -1})
    13. 

  13. db.getCollection("UltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ArchivedImageId": 1})
    14. 

  14. 

  15. //LabeledUltrasoundFile
    16. 

  16. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseId": 1,"IsGoldStandard": -1,"Source.FileName": 1, "CreateTime": -1})
    17. 

  17. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseId": 1,"UltrasoundFileId": 1, "Labeler._id":1, "IsImportedFormOldData": -1})
    18. 

  18. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseId": 1,"IsRelabeled": 1,"UltrasoundFileId": 1,"Labeler._id": 1, "DeveloperItem.QuestionedState":1, "SourceLabeledUltrasoundFileId":1, "DeveloperItem.ConfirmedState":1})
    19. 

  19. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted":1, "ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseId": 1,"IsAdoptable": -1, "IsInvalid":1, "ReviewState":1})
    20. 

  20. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted":1, "Labeler._id": 1,"CreateTime": 1})
    21. 

  21. db.getCollection("LabeledUltrasoundFiles").createIndex({ "_id":1,"UltrasoundFileId":1})
    22. 

  22. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ArchivedImageId": 1})
    23. 

  23. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"UltrasoundFileId": 1,"IsAdoptable": -1})
    24. 

  24. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"UltrasoundGroupId": 1,"IsSkipped": -1})
    25. 

  25. db.getCollection("LabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1,"ImageBatchId": 1,"ImageCaseId": 1,"UltrasoundGroupId": 1, "IsSkipped":-1, "IsAdoptable": -1, "IsGoldStandard": -1})
    26. 

  26. 

  27. //DeveloperFolderFile
    28. 

  28. db.getCollection("DeveloperFolderFiles").createIndex({ "IsDeleted": -1,"DeveloperFolderId": 1,"Name": 1,"Index": 1})
    29. 

  29. db.getCollection("DeveloperFolderFiles").createIndex({ "IsDeleted": -1,"DeveloperFolderId": 1,"HasQuestioned": 1,"Index": 1})
    30. 

  30. db.getCollection("DeveloperFolderFiles").createIndex({ "IsDeleted": -1,"DeveloperFolderId": 1,"Name": 1,"HasQuestioned": 1,"Index": 1})
    31. 

  31. db.getCollection("DeveloperFolderFiles").createIndex({ "IsDeleted": -1,"UltrasoundFileId": 1,"DeveloperFolderId": 1})
    32. 

  32. db.getCollection("DeveloperFolderFiles").createIndex({ "IsDeleted": -1,"DeveloperLabeledUltrasoundInfoList.LabeledUltrasoundFileId": 1 })
    33. 

  33. 

  34. 

  35. //DeveloperLabeledUltrasoundFile
    36. 

  36. db.getCollection("DeveloperLabeledUltrasoundFiles").createIndex({ "IsDeleted": -1,"UltrasoundFileId": 1,"DeveloperFolderId": 1})
    37. 

  37. 

  38. //AssignedLabelCaseFile
    39. 

  39. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "HasSeen":-1, "IsLabeled":-1, "Index":1 })
    40. 

  40. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "IsReviewFailed":1, "Index":1 })
    41. 

  41. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "RelabelState":1, "QuestionedState":1, "Index":1 })
    42. 

  42. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "LabeledUltrasoundFileIds.k":1 })
    43. 

  43. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "MixedFileType":1 })
    44. 

  44. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"LabeledUltrasoundFileIds.k": 1, "IsRelabeled":-1 })
    45. 

  45. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"ImageCategoryId": 1, "UltrasoundFileId":1, "IsLabeled":-1 })
    46. 

  46. db.getCollection("AssignedLabelCaseFiles").createIndex({ "IsDeleted": -1,"AssignedLabelCaseId": 1, "UltrasoundFileId":1, "IsLabeled":-1 })
    47. 

  47. 

  48. //AssignedReviewCaseFile
    49. 

  49. db.getCollection("AssignedReviewCaseFiles").createIndex({ "IsDeleted": -1,"AssignedReviewCaseId": 1,"HasSeen": 1,"Index": 1 })
    50. 

  50. db.getCollection("AssignedReviewCaseFiles").createIndex({ "IsDeleted": -1,"AssignedReviewCaseId": 1,"ReAuditState": 1, "QuestionedState":1, "Index": 1 })
    51. 

  51. db.getCollection("AssignedReviewCaseFiles").createIndex({ "IsDeleted": -1,"LabeledItems.AssignedLabelCaseFileId": 1 })
    52. 

  52. 

  53. //SameBatchLabelCase
    54. 

  54. db.getCollection("SameBatchLabelCases").createIndex({ "IsDeleted": -1,"Organization._id": 1,"ImageCategoryId": 1, "Name": 1,"CreateTime": 1, "UpdateTime":1 })
    55. 

  55. db.getCollection("SameBatchLabelCases").createIndex({ "Labelers.AssignedLabelCaseId": 1 })
    56. 

  56. db.getCollection("SameBatchLabelCases").createIndex({ "Name": 1,"Labelers._id": 1 })
    57. 

  57. db.getCollection("SameBatchLabelCases").createIndex({ "IsDeleted": -1,"State": 1 })
    58. 

  58. 

  59. //AssignedLabelCase
    60. 

  60. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "ImageCaseId": 1 })
    61. 

  61. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "ImageCategoryId": 1, "SeenCount":1, "LabeledCount":1, "Count":1, "CaseIndex": 1 })
    62. 

  62. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "ImageCategoryId": 1, "RelabelState":1, "QuestionedState":1, "CaseIndex": 1 })
    63. 

  63. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "SeenCount":1, "LabeledCount":1,  "Count":1, "CaseIndex": 1 })
    64. 

  64. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "CreateTime": 1 })
    65. 

  65. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "LabelCaseStatisticsId": 1 })
    66. 

  66. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "SameBatchLabelCaseId": 1 })
    67. 

  67. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "SameBatchLabelCaseId": 1, "LabeledCount":1 })
    68. 

  68. db.getCollection("AssignedLabelCases").createIndex({ "IsDeleted": -1, "SameBatchLabelCaseId": 1, "RelabelState":1 })
    69. 

  69. 

  70. //AssignedReviewCase
    71. 

  71. db.getCollection("AssignedReviewCases").createIndex({ "IsDeleted": -1, "Reviewer._id": 1, "SameBatchLabelCaseId": 1 })
    72. 

  72. db.getCollection("AssignedReviewCases").createIndex({ "IsDeleted": -1, "Reviewer._id": 1, "IsReviewFinished": 1, "CaseIndex": 1 })
    73. 

  73. db.getCollection("AssignedReviewCases").createIndex({ "IsDeleted": -1, "Reviewer._id": 1, "ImageCategoryId": 1, "IsReviewFinished": 1, "CaseIndex": 1 })
    74. 

  74. 

  75. //ImageCategory
    76. 

  76. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "LabelPackageContentId": 1, "HasChildren": 1 })
    77. 

  77. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "Name": 1, "OrganizationId": 1 })
    78. 

  78. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "Developers": 1, "Sharers":1 })
    79. 

  79. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "Name": 1, "Parent._id": 1 })
    80. 

  80. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "Parent._id": 1, "Developers": 1 })
    81. 

  81. db.getCollection("ImageCategories").createIndex({ "IsDeleted": -1, "SameBatchLabelCaseId": 1, "Level":1 })
    82. 

  82. 

  83. //LabelerGroup
    84. 

  84. db.getCollection("LabelerGroups").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "ImageCategoryId": 1 })
    85. 

  85. db.getCollection("LabelerGroups").createIndex({ "IsDeleted": -1, "OrganizationId": 1, "Labeler.Name": 1, "ImageCategoryId": 1, "UpdateTime":1 })
    86. 

  86. 

  87. //LabelerGroupItem
    88. 

  88. db.getCollection("LabelerGroupItems").createIndex({ "IsDeleted": -1, "LabelerGroupId": 1, "AssignedLabelCaseId": 1, "AssignedReviewCaseId": 1, "CreateTime": -1 })
    89. 

  89. 

  90. //LabelCaseStatistic
    91. 

  91. db.getCollection("LabelCaseStatistics").createIndex({ "IsDeleted": -1, "AssignedLabelCaseId": 1 })
    92. 

  92. db.getCollection("LabelCaseStatistics").createIndex({ "IsDeleted": -1, "Labeler._id": 1, "CreateTime": -1 })
    93. 

  93. db.getCollection("LabelCaseStatistics").createIndex({ "IsDeleted": -1, "SameBatchLabelCaseId": 1 })
    94. 

  94. 

  95. //GoldStandardAssignedFile
    96. 

  96. db.getCollection("GoldStandardAssignedFiles").createIndex({ "UltrasoundFileId": 1 })
    97. 

  97. db.getCollection("GoldStandardAssignedFiles").createIndex({ "IsDeleted": -1, "ImageCategoryId": 1, "LabelerAssignedInfos.Labeler._id": 1 })
    98. 

  98. 

  99. //SelfCheckAssignedFile
    100. 

  100. db.getCollection("SelfCheckAssignedFiles").createIndex({ "UltrasoundFileId": 1 })
    101. 

  101. db.getCollection("SelfCheckAssignedFiles").createIndex({ "IsDeleted": -1, "ImageCategoryId": 1, "LabelerAssignedInfos.Labeler._id": 1 })
    102. 

  102. 

  103. --------------------------系统日志 端口号10011----------------------------------------------------------------------------------------------------------------------------------------
    104. 

  104. //LogItem
    105. 

  105. db.getCollection("LogItems").createIndex({ "IsDeleted": -1, "Message": 1, "CreateTime": -1 })
    106. 

  106. 

  107. --------------------------以下暂不添加--------------------------------------------------------------------------------------------------------------------------------------------------
    108. 

  108. 

  109. //TrainTask
    110. 

  110. db.getCollection("TrainTasks").createIndex({ "DeveloperId": 1})
    111. 

  111. db.getCollection("TrainTasks").createIndex({ "TaskName": 1})
    112. 

  112. db.getCollection("TrainTasks").createIndex({ "Result": 1})
    113. 

  113. 

  114. //TrainTaskStatus
    115. 

  115. db.getCollection("TrainTaskStatus").createIndex({ "TrainTaskId": 1,"IsDeleted": -1,})
    116. 

  116. 

  117. //TrainScriptPackage
    118. 

  118. db.getCollection("TrainScriptPackages").createIndex({ "DeveloperId": 1,"Name": 1,})
    119.