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
Bookmark and Share

You should follow me on twitter here

Comments are closed.