4GL Patterns - #11 Custom Data Types
Tuesday, 30 September 2008
Rapid application development usually require data types beyond the simple INT, FLOAT and VARCHAR found in databases.
Here are some examples gleaned from existing frameworks:
- Compiere/ADempiere - Account, Amount, Assignment, Binary, Button, Color, Costs+Prices, Date, Date+Time, FileName, FilePath, ID, Image, List, Location (Address), Memo, Product Attribute, Quantity, Row ID, Table, TableDirect, Text, Text Long, Time, URL, Yes-No, Number, Printer Name, Product Attribute, Quantity, Search
- Plone Archetypes - CMFObjectField, ComputedField, ImageField, FilesField, LinesField
- CodeIgniter/Django - URL, Email
- UDEF - Amount, Code, Graphic, Measure (Unit of…), Percent, Picture, Rate, Document
- Miscellaneous - tag