Creating Field Names

20/20 DataShed is designed to give priority to certain fields in the database. For example, certain fields are configured by default to be displayed in the search form and item templates. (Most of these options can be altered, but it's a good idea to follow the design when possible.) To understand these prioritized fields, a brief discussion of biology!? is in order.

Taxonomy

"Taxonomy" refers to the division of items or things into ordered groups and categories. It is a term normally used by biologists to describe the classification of plants or animals. However, 20/20 DataShed uses this type of terminology to describe the classification of any item.

Your own inventory can be organized into ordered categories -- like a hierarchy of groups or terms used to describe each item. Any "thing" can be identified by its characteristics, some of which may be shared by other things and some which may be unique.

Examples of prioritized fields:

In this manner, 20/20 DataShed's database fields can be renamed according to your own business model. If you're operating a biology web site, then perhaps your field names will in fact represent traditional terminology:

Or perhaps you operate a real estate firm and your field names reflect that marketplace:

Similarly, your field names may reflect automobiles:

Other Fields

When the prioritized fields are combined with others 20/20 DataShed provides the ability to organize a wide variety of information. Note that the table below does not include all available fields but this example clearly demonstrates how the variety of available fields can be used to store the necessary information about your inventory.

Field Name Friendly Name
itemID
date_entered
date_lastmodified
hits
transaction_type
status
species
genus
family
order
class
phylum
display_title
general_description
opening_date
closing_date
listing_price
sale_price
item_referencecode
UserDefinedCurrency1
UserDefinedCurrency2
UserDefinedCurrency3
UserDefinedNumber1
UserDefinedDoubleNumber1
UserDefinedDoubleNumber2
UserDefinedMemo1
UserDefinedText1
...and so on.

Our Advice

We recommend that you spend time in the 20/20 DataShed Options » "Item Field Names and Options Groups" panel to carefully create appopriate field names for your business model.

Note the following:

Related topics


© 2005 - 2007 20/20 Applications. All rights reserved.