4GL Patterns – #11 Custom Data Types

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