Collection Editor

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Developing the Physical Model

The collection editor is used to create and edit collections within a physical model for MongoDB models.

Within a MongoDB database, a collection holds a set of documents. Documents are sets of key-value pairs. You can think of a collection as being similar to a table in a 'normal' database, however because documents have a dynamic schema, this means that documents in the same collection do not need to have the same set of fields or structure.

Notepad blue icon 2.pngNote: To work with collections, your physical database platform must be MongoDB.

To create a new collection

  1. On the Data Model Explorer, click the Data Model tab.
    192 Data Model Tab.png
  2. On the model tree, select the Physical model.
    192 Physical Model.png
  3. From the ribbon menu, choose Insert > Collection.
    192 Insert Collection.png
  4. The cursor changes to a square icon. Square Cursor.png
  5. With your mouse cursor, left-click anywhere in the main model window to insert your new collection.
  6. Once you have finished adding collections, right-click to return the cursor to normal.

To open the Collection Editor

  1. Select your collection from the main window or the model explorer.
  2. Right-click, and then choose Edit Collection.
    The collection editor opens for you to edit your selected collection.

192 Collection Editor.png

See Also