Public Interface Export Function › Public Interface Tables › Table Definitions

Table Definitions

Each table represents an object, such as an entity type or process, and consists of rows and columns. Each row of the table represents an occurrence of an object, such as an entity named CUSTOMER. Each column of the row represents either a property of that object or a foreign key. Foreign keys are discussed under the next heading.

Each row of each table contains a column called MODEL_ID that uniquely identifies the model that contains the object. Each row also contains a column called ID that uniquely identifies the object within the encyclopedia. Each row contains a column called ORG_ID that gives the Original Object ID of the object within the encyclopedia.

For example, the table ATTRIBUTE contains one row for every attribute of every entity type in every model that has been exported to the Public Interface. Each attribute has a MODEL ID, a unique object ID in the third column, and a foreign key (PARENT_ENTITY_ID) that identifies the entity type to which the attribute belongs. Each row also contains columns for the attribute's properties, such as NAME, LENGTH, and DOMAIN.