Entities

Entities

Entities are the main building blocks of ER model. Entity is a persistent object that can be saved and restored to\from relational DB. Entity is transformed to a DB relational table containing several records each having a number of columns

Fields

Entity object is described with the following fields

Field	Type	Description	Example
UID	String	Unique identifier of entity throughout all models	abcd-1234-efgh-5678
System name	String	System name of the entity is a brief name used to address entity in code \ used for code generation. System name can have no whitespaces and usually is set in camel-case.	OrderItem
Name	String	Name of the entity is a human-readable logical (business) name . Name can include several words and is used in information model and business analysis	Order item
Description	String	Short text describing entity from business point of view	Single line of order that defines single SKU with its' price and quantity
Table	String	Name of the physical table which is mapped to an entity	SBT_ORDER_ITEM

Attributes

Each entity can have a number of attributes. Attributes define entity properties that are mapped to DB table column

Field	Type	Description	Example
UID	String	Unique identifier of attribute throughout all models	abcd-1234-efgh-5678
System name	String	System name of the attribute is a brief name used to address attribute in code \ used for code generation. System name can have no whitespaces and usually is set in camel-case.	ItemPrice
Name	String	Name of the attribute is a human-readable logical (business) name . Name can include several words and is used in information model and business analysis	Item price
Description	String	Short text describing attribute from business point of view	Price of the item in US dollars