v5:dictionary:column_attributes
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:dictionary:column_attributes [2016/04/03 01:28] – [UNSIGNED] mnewnham | v5:dictionary:column_attributes [2022/09/02 04:11] (current) – [Column Name] backticks mnewnham | ||
---|---|---|---|
Line 2: | Line 2: | ||
====== Description ====== | ====== Description ====== | ||
When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters. | When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters. | ||
- | -------------------------------- | + | |
- | <WRAP right info 300px> | + | |
- | $fields is a string, not an array | + | |
- | </ | + | |
====== Basic Syntax ====== | ====== Basic Syntax ====== | ||
The basic syntax of the attributes is as follows: | The basic syntax of the attributes is as follows: | ||
Line 41: | Line 38: | ||
======= | ======= | ||
===== Column Name ===== | ===== Column Name ===== | ||
- | * The column name must conform to any database specific standards related to naming and length. | + | * The column name must conform to any database specific standards related to naming and length. |
- | + | ||
===== Meta Attributes ===== | ===== Meta Attributes ===== | ||
* The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5: | * The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5: | ||
Line 60: | Line 56: | ||
</ | </ | ||
==== CONSTRAINT ==== | ==== CONSTRAINT ==== | ||
+ | Adds a constraint to column. The syntax for the constraint must be defined as required by the database. | ||
-------------------------- | -------------------------- | ||
<WRAP right box 150px> | <WRAP right box 150px> | ||
Line 84: | Line 80: | ||
</ | </ | ||
==== ENUM ==== | ==== ENUM ==== | ||
- | In databases that support the ENUM datatype, append a parenthesized, | + | In databases that support the //**ENUM**// datatype, append a parenthesized, |
ENUM(' | ENUM(' | ||
| |
v5/dictionary/column_attributes.1459639690.txt.gz · Last modified: 2017/04/21 11:28 (external edit)