com.sebtools Build 8 Documentation: Types

Types

Manager.cfc has several built in field types:

pk:integer
An integer primary key field. If it is the only primary key field for a table, it will auto-increment.
fk:integer
Ab integer foreign key field (without foreign key contraint in the database).
pk:text
A character primary key field.
fk:text
A character foreign key field (without foreign key contraint in the database).
text
A character field (Length attribute is required).
pk:idstamp
A primary key field with a CF_SQL_TYPE of CF_SQL_IDSTAMP (for unique identifiers)
fk:idstamp
A foreign key field with a CF_SQL_TYPE of CF_SQL_IDSTAMP (for unique identifiers)
idstamp
A field with a CF_SQL_TYPE of CF_SQL_IDSTAMP (for unique identifiers)
string
A character field (Length attribute is required).
boolean
A boolean (yes/no,true/false) field.
integer
An integer field.
decimal
A decimal field.
money
A money field.
float
A float field.
date
A date field.
CreationDate
A date field that will default to the date/time that the record is created.
LastUpdatedDate
A date field that will default to the date/time that the record is last created or updated.
time
A time field.
file
A file field, which will store the name of a file in the database (folder attribute is required for file location).
image
An image field, which will store the name of an image in the database (folder attribute is required for file location). Accepts only image files and allows for image constraints and resizing.
thumb
An scaled down version (with size constraints provided) of an image field referenced by the required "original" attribute.
memo
A long text field.
html
A long text field that indicates a wysisyg as the means of input.
email
A text field that should only accept a valid email address.
password
A text field that should be entered using a password input.
Sorter
An integer field used for storing manual ordering data. Default to the next highest integer value.
DeletionDate
A date field used for logical deletes. Stores the date a record was deleted to indicate a deleted record.
DeletionMark
A boolean field used for logical deletes. Has a value of true to indicate a deleted record.
relation
A DataMgr relation field.