Static Entities

Create Static Entity

Create an Espace named CityManager and a Static Entity Named CitySize with two Integer Attribute: MinSize and MaxSize. Add four Records Small, Medium, Big, and Huge like in the following table:

After publishing the Espace you can search for the created Entity info:

SELECT 
    OSSYS_ENTITY.NAME,
    OSSYS_ENTITY.DATA_KIND,
    OSSYS_ENTITY.PHYSICAL_TABLE_NAME
FROM OSSYS_ENTITY
WHERE OSSYS_ENTITY.NAME = 'CitySize' 
    AND OSSYS_ENTITY.ESPACE_ID = (
        SELECT ID FROM OSSYS_ESPACE WHERE NAME = 'CityManager'
    )

And in the physical table we get the physical attributes info:

SELECT
    Id,
    Name,
    Order,
    Is_Active,
    MinSize,
    MaxSize
FROM OSUSR_5Z9_CITYSIZE 
ORDER BY [ORDER]

Remove Static Entity Records

Remove the Small record from the CitySize Entity.

This is only possible to do if the Record to delete is not yet being used as a foreign key in another entity. If it is, all the dependencies have to be deleted before doing this operation or it will only be possible to set the record has inactive.

If it is possible to delete the record, the Entity_Record changes the attribute Is_Active to False (0) since it is no longer active.

And then, in the physical table, the corresponding row is deleted.

Create Static Entity Record with the Same Name as Previous Deleted Record

Create a record named Small, which is the same name as the record that was deleted before. Its size parameters are from 101 to 5000. After publishing the Espace, the information on the Entity Record is:

A new record has been created, and the previously deleted record has not been activated. The static entity physical table has a new record related with the new entity record:

Entity Record

Proceed to the next section