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.
- pk:uuid
- A string primary key field. If no value is passed for the field on insert, then it will be set to a new UUID value (uses DataMgr's UUID Special - requires DataMgr 2.5 or better).
- 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.
- UUID
- A string field. If no value is passed for the field on insert, then it will be set to a new UUID value (uses DataMgr's UUID Special - requires DataMgr 2.5 or better).
- relation
- A DataMgr relation field.