Concepts → Column

About a 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:

You can also create a formula column.

General properties of a column

A column has a least three properties:

  • Name
  • Label
  • Data Type

© Incorta, Inc. All Rights Reserved.