Concepts → Column
In traditional entity modeling, an entity is a distinguishable object such as a person, place, or thing. An attribute describes an elementary feature of an entity in the same way that an adjective describes a noun. In the physical schema of a database, an entity manifests as a table with each attribute represented as a table column with a defined data type. Each row stored in the table represents an instance of an entity, typically with both unique and similar values for various attributes.
A similar representation exists for a logical representation captured in subset of the physical schema known as a business schema in Incorta. For business schema, the entity manifest as a view with each attribute represented as a view column.
There are several types of columns such as:
- Physical schema table column
- Physical schema Incorta Analyzer Table column
- Business schema view column
- Business schema Incorta Analyzer View column
- Insight column
You can also create a formula column.
A column has a least three properties:
- Data Type