EntityType

Entity Definition

Logical Name : EntityType
Physical Name : CO_ET_TYP

In the ARTS use of Entity-Attribute-Value pattern we need to identify the entity to make this a data model-wide pattern. An entity is a person, place, thing, idea, concept, transaction or anything else of interest to a retailer. An entity is generally equivalent to a table within the ARTS data model.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EntityTypeID (PK) Unique ID for an entity type ID_ET Identity integer
EntityName Entity type name NM_ET DescriptionShort varchar(255)
EntityDefinitionNarrative Entity type definition. NA_ET_DFN DescriptionNarrative varchar(4000)

Relationships

Parent Entity Verb Phrase Child Entity
EntityType is described by AttributeType

Logical Views containing EntityType

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07030 - Customer Segment Independent Characteristics