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

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.

This page was edited 95 days ago on 06/17/2024. What links here