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.
    Data Model Tab.png
  2. On the model tree, select the Physical model.
    Physical Model.png
  3. From the Application Menu choose Insert > Collection.
    Insert Collection.png
  4. The cursor will change 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.
    Selected Collection.png
  2. From the Application Menu choose Edit > Edit Collection.
    This will open the collection editor, so you can edit your selected collection.


Collectioneditor.png

See Also