DATABASE FIELD HELP

First, some definitions: "RECORD" refers to the total sum of information on the database about a particular bunny. A record is sometimes called a "segment". A record is made up of a number of "FIELDS". A "FIELD" contains a piece of information about the rabbit. Fields are sometimes called "COLUMNS". "FREEFORM" fields will accept most any kind of text characters. Spaces and punctuation marks are considered "characters". If there is a suggested format for a freeform text field (to ensure consistency and correct search results) it is shown in the MAXIMUM SIZE/FORMAT area below. "SELECTABLE" fields REQUIRE a choice to be made from the dropdown box and WILL NOT accept any other data. The NAME field is the KEY field. This is the unique identifier that distinguishes one record from the other. It is shown in RED in the chart below. Each rabbit's name MUST be unique and different from all the others. Rabbits with the same name are numbered, for instance, "BONNIE #1" and "BONNIE #2".

Here is a chart detailing the database fields and their characteristics: FIELD NAME FIELD TYPE MAXIMUM SIZE/ FORMAT DEFAULT NAME FREEFORM TEXT 15 CHARACTERS (No default) GENDER SELECTABLE N/A "Male" BREED1 SELECTABLE N/A "American" BREED2 SELECTABLE N/A "none" COLOR1 SELECTABLE N/A "Agouti" COLOR2 SELECTABLE N/A "none" AGE DECIMAL NN.DD "0.00" CURRSTAT SELECTABLE N/A "Adoptable - Bunny Barn" INTAKEDT Date YYYY-MM-DD "0000-00-00" SPAYNEUT SELECTABLE N/A "Yes" SPAYNEUTDT Date YYYY-MM-DD "0000-00-00" FREEFORMNOTES FREEFORM TEXT 250 CHARACTERS (No default) WT2003 DECIMAL NN.DD "0.00" WT2004 DECIMAL NN.DD "0.00" WT2005 DECIMAL NN.DD "0.00" ADOPTIONDATE Date YYYY-MM-DD "0000-00-00" ADOPTERNAME FREEFORM TEXT 60 CHARACTERS (No default) ADOPTERADDR FREEFORM TEXT 250 CHARACTERS (No default) ADOPTERPHONE FREEFORM TEXT 15 CHARACTERS nnn-nnn-nnnn (No default) ADOPTERPHONE2 FREEFORM TEXT 15 CHARACTERS nnn-nnn-nnnn (No default) MICROCHIPNO FREEFORM TEXT 16 CHARACTERS AVID*nnn*nnn*nnn (No default) LSTUPDAT Date & Time Use "NOW" function "0000-00-00 00:00:00" LSTUPDID SELECTABLE N/A "steve"

To return to the main database help page click here.