Factory Database

Publish an Espace with new Entities

To publish an Espace with new entities, create a new Espace called “People” and then create three new Entities:

1. City, with the Name attribute.
2. Icon, and the attributes are: 2.1. Name, Tex type. 2.1. BinaryInfo, BinaryData type.
3. Person
   • Name, Text type.
   • DateofBirth, Data type.
   • IsAlive, Boolean type.
   • City Id, City Identifier type.
   • IconId, Icon Identifier type.
   • Suggestion: right-click this Entity, click More options and choose wisely the:
     • Label Attribute
     • Order By Attribute
     • Is Active Attribute

After publishing the Espace, you can search for it and the newly created Entity details in the database:

SELECT * FROM OSSYS_ESPACE WHERE Name = ’People’

SELECT 
    ID,
    NAME,
    PHYSICAL_TABLE_NAME,
    ESPACE_ID,
    SS_KEY,
    PRIMARYKEY_SS_KEY,
    IS_ACTIVE_ATTRIBUTE,
    LABEL_ATTRIBUTE,
    ORDER_BY_ATTRIBUTE 
FROM OSSYS_ENTITY 
WHERE Espace_Id = (SELECT ID FROM OSSYS_ESPACE WHERE Name = ’People’)

The entities attribute details are stored in OS Platform entities and can be searched:

SELECT
    OSSYS_ENTITY.NAME ENTITY_NAME,
    OSSYS_ENTITY_ATTR.*
FROM OSSYS_ENTITY 
INNER JOIN OSSYS_ENTITY_ATTR 
    ON OSSYS_ENTITY.ID =  OSSYS_ENTITY_ATTR.ENTITY_ID
WHERE Espace_Id = (SELECT ID FROM OSSYS_ESPACE WHERE Name = ’People’)

Notice that the Attribute SS_Key is present in the database but is not shown above. Besides the normal basic types with a prefix rt (Run Time), you can see the relation types like the example bt2848df88-835f-427a-b0db-e29a1d8e9766*0f3b6288-e5b3-4804-97e2-9b1ea18fc12e.

The types starting with the prefix bt are composed with the Espace SS_Key and then after the * there’s the Entity SS_Key. The CityId and IconId are other type identifiers (City and Icons).

The SQL command below shows how to fetch Entities using the SS_Key:

SELECT OSSYS_ESPACE.NAME [ESPACE]
    ,OSSYS_ENTITY.NAME [ENTITY]
FROM OSSYS_ENTITY 
INNER JOIN OSSYS_ESPACE 
    ON OSSYS_ENTITY.ESPACE_Id = OSSYS_ESPACE.ID 
            AND OSSYS_ESPACE.SS_KEY = '2848df88-835f-427a-b0db-e29a1d8e9766'
WHERE OSSYS_ENTITY.SS_KEY = '0f3b6288-e5b3-4804-97e2-9b1ea18fc12e'
UNION ALL
SELECT 
    OSSYS_ENTITY.NAME
    ,OSSYS_ESPACE.NAME
FROM OSSYS_ENTITY 
INNER JOIN OSSYS_ESPACE 
    ON OSSYS_ENTITY.ESPACE_Id = OSSYS_ESPACE.ID 
            AND OSSYS_ESPACE.SS_KEY='2848df88-835f-427a-b0db-e29a1d8e9766'
WHERE OSSYS_ENTITY.SS_KEY = 'a280d501-0a34-4fe0-9626-0f825f10c999'

Use the Espace SS_Key when searching for other OS objects like Entities since the Entity SS_Key is only unique when combined with the Espace SS_Key. For example, if the Espace is cloned, every Entity generated in the clone Espace gets the same SS_Key as the other Entities in the original Espace.

The following table shows the Entities that belong to the People Espace that was previously created. If you focus your attention on Physical_Table_Name, you see that it is possible to display what is inside the City Entity by doing SELECT * FROM OSUSR_7i3_City.

SELECT * FROM OSUSR_7i3_City

In this case, OSUSR_7i3_City is the physical database name of the table that holds the information belonging to the City Entity.

Publish an Espace with new Entities

To find information about the Static Entities refer to the Static Entities for more details.

Proceed to the next section