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

Comments are closed.