Column
No edit summary
No edit summary
Line 1: Line 1:
==== Definition ====
==== Definition ====
A '''column''' is a specific piece of information associated with a data entity (real-world objects, concepts, or entities within a system). It represents a single data point or property.
A '''column''' is a specific piece of information associated with a data entity in a database. It represents a single data point or property and is usually equivalent to an [[Documentation:Attribute|attribute]]. When creating a [[Documentation:Class|class]], it's [[Documentation:Attribute|attributes]] become columns in a database table.


For example:
For example:
Line 6: Line 6:
* In a '''customer''' data entity, columns might include CustomerID, Name, Email, and Phone.
* In a '''customer''' data entity, columns might include CustomerID, Name, Email, and Phone.
* In a '''product''' data entity, columns might include ProductID, Name, Price, and Category.
* In a '''product''' data entity, columns might include ProductID, Name, Price, and Category.
==== Purpose of Columns ====
# Columns define the structure of data entities.
# They determine what information can be stored and retrieved.
# Columns are essential for querying, sorting, and filtering data.


==== Customization ====
==== Customization ====
In model-driven apps, you can customize columns by defining their data type, validation rules, and display format.
In model-driven apps, you can customize columns (attributes) by defining their data type, validation rules, and display format.


Columns can be added, modified, or removed based on the specific requirements of your application.
Columns can be added, modified, or removed based on the specific requirements of your application.


Columns (fields or attributes) play a vital role in defining the structure and properties of data entities within a model-driven development environment.
Columns (fields or attributes) play a vital role in defining the structure and properties of data entities within a model-driven development environment.

Revision as of 19:58, 21 May 2024

This page was created by Stephanie@mdriven.net on 2024-05-17. Last edited by Edgar on 2025-01-20.

Definition

A column is a specific piece of information associated with a data entity in a database. It represents a single data point or property and is usually equivalent to an attribute. When creating a class, it's attributes become columns in a database table.

For example:

  • In a customer data entity, columns might include CustomerID, Name, Email, and Phone.
  • In a product data entity, columns might include ProductID, Name, Price, and Category.

Customization

In model-driven apps, you can customize columns (attributes) by defining their data type, validation rules, and display format.

Columns can be added, modified, or removed based on the specific requirements of your application.

Columns (fields or attributes) play a vital role in defining the structure and properties of data entities within a model-driven development environment.