Skip to content

Entity Manager

Overview

The Mythradon Entity Manager is used to customise the Entities available in Mythradon.

Entities define the database tables that are used to store data in Mythradon. They define the fields and relationships between other entities.

The Entity Manager allows you to:

  • Create new Entities
  • Customise existing Entities: Change Labels, default order in list view, etc
  • Configure fields: Add new, customise existing ones
  • Configure relationships: Add new, change labels of existing ones.

All customisations made via the Entity Manager are stored in the system meta data.

This article details how to:

  • Create new Entities
  • Create new Fields
  • Audit Track Fields
  • Create Relationships

Top


Create a New Entity

To create a new Entity:

  • Select Administration | Entity Manager from the Menu Button
  • Click the Create Entity button
  • Set the appropriate properties and click the Save button.

Entity Manager

Properties

The following properties for creating a new Entity are as follows:

Property Description
Name Unique name of the entity.
Type The type of entity is used to provide pre-built functionality.

The options are:
  • Base
  • Base Plus
  • Event
  • Person
  • Company.

Refer to Mythradon Entity Types for details on each of the supported Entity Types.
Label Singular Display label for the Entity. This is the 'singular' version of the label that is used in labels and headings when referring to a single instance of a record of this entity type.
Label Plural Display label for the Entity. This is the 'plural' version of the label that is used in labels and headings when referring to multiple records such in a list.
Stream Controls if a Stream is enabled on the Entity.
Icon Icon to use for the Entity. This is displayed in Page Tabs. List of Icons
Color HTML code for the Icon Color.

Once you save the Entity you can access the following fields from the Edit Settings button show in the following image:

Entity Settings

Property Description
Disabled Disables the Entity from use. The entity and it's underlying table will still reside in the system, but can not be accessed regardless of the User's Role settings.
Default Order (field)
Default Order (direction)
Text Filter Fields Fields to index and include in the
Status Field
Full-Text Search
Disable record count

Note: When you create a new entity the name will be suffixed with the value 'Cust'. This indicates that the entity is a custom entity. This is to ensure that a new version of Mythradon doesn't introduce a new entity with the same name.



Note: Once you create an Entity and have defined the 'Entity Type' you are unable to change it. Your options would be to either remove the entity and start defining it again (Any data that you had in this entity would be lost if your took this option) or manually adding the additional functionality that is required.


Once an Entity has been created you can add your own Fields and Relationships to cater for your unique requirements. The following sections will describe how to add and change Fields and Relationships.

Top


Adding Fields to an Entity

To create add or modify fields on an Entity:

  • Select Administration | Entity Manager from the Menu Button
  • Select the appropriate entity from the list
  • Click the Fields button. Click Add Field button
  • Select the Field Type
  • Set the appropriate properties and click the Save button. See the Properties table below for more information.

From the Entity Manager, fields can be newly added or edited. Users can also click Reset to Default button to set the field configuration back to default.

Fields can be added to an existing Entity. Custom fields created by users can be removed from an entity. Only custom fields can be removed.

Top


Fields

Fields represent the elements of data that can be stored in an Entity. Each Field has a specific data type.

Mythradon supports many different data types. Data types define the type of field that you can use in a form.

i.e., Picklist field, Free Text field, Date field etc

Most data types are available for use in the Entity Manager for creating custom fields. There are several Special Data Types that are not available directly in the Entity Manager. If you need to use one of these additional types, please contact Mythradon Customer Support for assistance.

Standard Data Types

Type Description
Address The Address data type is designed specifically for the entry of addresses. It is a multi field data type.
Array The Array data type is used to display a list of multiple values, similar to the Multi-Enum field.
Attachment Multiple The Attachment Multiple data type supports the attachment of multiple files.
Auto-increment The Auto-Increment data type is used to a generated read-only auto-incrementing integer number.
Barcode The Barcode data type is used for the display of Barcodes.
Boolean The Boolean data type is used to store a true/false value. It is displayed as a checkbox.
Checklist The Checklist data type is used to display a list of checkboxes.
Currency The Currency data type is used to store and display currency values.
Date The Date data type is used for the storage and display of date values without any time value.
Date Time The Date Time data type is used for the storage and display of date/time values.
Enum (Picklist) The Enum data type provides a picklist of values where only one value can be selected at a time.
File The File data type is used to add a single file to the form.
Float The Float data type is used to store decimal numbers.
Foreign The Foreign data type is used to provide a field/value from a related Entity/record. This field will always be read-only.
Header The Header data type is used to display a header. It can be used on a page layout to separate values with a nicely formatted heading.
Image The Image data type is used to store and display images. The images can be displayed in a variety of sizes.
Integer The Integer data type is used to store and display whole numbers.
Multi-Enum The Multi-Enum is used to display a list of multiple values that can be selected from a picklist.
Number The Number data type provides an auto-incrementing number that is of type string. Supports applying a prefix and setting a specific length.
Rich Text Label The Rich Text Label data type is used to display a label that supports HTML formatting such as font type, size and color.
Signature Pad The Signature Pad data type is used to store and display a hand written signature.
Text The Text data type is used to store multiline text with markdown support.
URL The Url data type is used to store links to web pages.
Varchar The Varchar data type is used to store and display a single-line text.
WYSIWYG The WYSIWYG (What you see is what you get) data type provides the user with a rich text multi line data entry field.
Link A Static link is used to pick a record from the defined entity. i.e., Select a specific Contact or Account.
Link Multiple A Static Link Multiple Data Type is used to pick one or more records from the defined entity. i.e., Select a specific Contact or Account.
Link Parent The Static Link Parent data type allows for the selection of a record from one or more different Entity Types.
Risk Matrix The Risk Matrix data type allows for the visualisation of risk rating.

Special Data Types

The following data types are supported in Mythradon, however you will need assistance from Mythradon Customer Service to create new fields of these types.

Type Description
Email The Email data type is designed specifically for the entry of email addresses.
Phone The Phone data type is designed specifically for the entry of phone numbers. The phone data type supports the entry of multiple phone numbers and allows the selection of phone type. i.e., Mobile, Office.

Properties of Fields

The following are the standard properties of fields. Note that some fields will have some specific properties that only apply for these fields.

Property Description
Name The name of the field that will be referred in code.
Label The label which the field will be displayed, it is different from the field's name.
Is Personal Data Mark if the field contains personal data. Please refer to Data Privacy for more information.
Disable Inline Edit Control if Inline Edit (edit without entering Edit View) is available for the field.
Tooltip Text A user-friendly piece of text that explains what the field is and what information it holds.

Note: In order to delete a field. The field must be removed from all layouts.


Top


Relationships

Relationships are associations between two entities. For example, an Account has one or more Contacts working for them. Relationships will be displayed as a field on Layout Manager. Please refer to Layout Manager.

Top


Types of Relationships

You can create new relationships between entities. This is supported for both standard and custom entities. Mythradon supports the following types of relationships:

Relationship Type Description
One-to-Many After you have created this relationship, you can put a link field to the detail layout of the right entity and add relationship panel to the left entity.
Many-to-One The same as One-to-Many but vice versa.
Many-to-Many Relationship panels on both sides.
One-to-One Right The Link field on one side, Link-One on another.
One-to-One Left The same as previous but vice versa.
Children-to-Parent Linking with multiple entity types through Link-Parent field.

Top


Right and Left Entity

In a One-to-Many relationship, one entity is called the Left Entity and the other is called the Right Entity. The Left Entity record has one or more related Right Entity records.

i.e.) A teacher teaches one or more lectures and one lecture has only one teacher. In this case, Teacher is the Left Entity and Lecture is the Right Entity

Top


Relationship Panel

Relationships are displayed as field, in a Relationship Pane view at the bottom of the Detail View. There is another name for this: Bottom Panel View. Please refer to Bottom Panel View.

Top


Create a Relationship

To create a new relationship between 2 entities:

  • Select Administration | Entity Manager from the Menu Button
  • Select the appropriate entity from the list
  • Click the Relationships button
  • Click the Click Link button
  • A modal page will be displayed to ask for necessary information to create the relationship
  • Set the appropriate properties and click the Save button.

Create Entity Relationship

Property Description
Foreign Entity The entity that will be related to the selected entity.
Link Type The type of relationships.
Name (Of the left entity) Display the name of the left entity in the relationship name.
Label (Of the left entity) Display the label of the left entity in the relationship name.
Name (Of the right entity) Display the name of the right entity in the relationship name.
Label (Of the right entity) Display the label of the right entity in the relationship name.
Link Multiple Field If checked the field of Link-Multiple type will be created along with the relationship. You can put such a field on the layout. It's convenient for quick picking of related records.
Audited If checked, then updates of the relationship will be logged in Stream..

Top


Layouts

The configuration of an entity layout is the same as the general configure in Layout Manager. Please refer to Mythradon Layout Manager for more details.

Top


See also


Top