Prev Next

Database Table Columns

In a relational database, a Table column (sometimes referred to as a field) stores a single data value of a particular type in each row of the Table. Table columns can have various individual properties such as a default value or whether the field accepts Null values.

A Database Table Column is represented in the UML Data Modeling Profile as a stereotyped attribute; that is, an attribute with the <<column>> stereotype. In Enterprise Architect you define and maintain Table Columns using the purpose-designed 'Columns' page of the Database Builder, or the 'Columns and Constraints' dialog.

Learn more