Classifies samples collected during a darting into specific categories, e.g. blood, skin, etc.
DART_SAMPLE_CATS defines values for DART_SAMPLE_TYPES.DS_Cat. This column cannot be changed.
The different types of samples that are collected during dartings.
This table contains data that are special values used by the DSAMPLES view. Because of this, only administrators are allowed to INSERT, UPDATE, or DELETE from this table.
DART_SAMPLE_TYPES defines values for DART_SAMPLES.DS_Type. This column cannot be changed.
The values in DS_Type are used in the definition of the DSAMPLES view.
The DART_SAMPLE_CATS.DS_Cat to which each sample type belongs.
Some sample types may be sex-specific. Vaginal and cervical swabs, for example, can only be collected from females. If a sample type has any such specificity, the correct sex is indicated here.
This column may be NULL when the darting sample is
not sex-specific.
The minimum number of samples of this type that can be
collected. This column may not be NULL.
The different anesthetics used when darting.
The different conditions a lymph node can be found in when darting.
The different kinds of parasites, kinds of parasites in varying developmental stages, or kinds of parasite indicators counted when darting.
The different tooth conditions, degrees of wear, chipping, etc., observed when darting.
The condition of the tooth is a property distinct from the degree to which the tooth is present or absent. The latter property is described by the codes in the TSTATES table.
TCONDITIONS defines values for TEETH.Tcondition.
The classifications of parasite count useful in analysis.
TICKSTATUSES defines values for TICKS.Tickstatus.
The following special codes can only be altered by suitably privileged individuals. See Special Values.
Special TICKSTATUSES codes
0
A count was performed and no parasites were
found. This code can only be used when the number of
parasites counted is 0, in which
case it must be used.
1
A count was performed and parasites were found.
This code must be used when the number of parasites
counted is any non-zero positive integer. The code may
be used when parasites are found but were not counted
(TICKS.Tickcount is NULL).
A set of codes describing the dentition of a baboon, one code for each tooth.
Deciduous[243] teeth have different codes than, are considered different from, adult teeth.
Every toothcode value is special, although there are no restrictions placed upon making changes to these “special” values as there are on the special rows in other tables. Each of the TOOTHCODES.Tooth values are written into[244]the DENT_CODES and DENT_SITES views. Adding or deleting rows from TOOTHCODES requires re-writing the DENT_CODES and DENT_SITES views to ensure the alterations are present in the views.
Boolean value indicating whether the tooth is a canine or not.
Morphologically this column should be on TOOTHSITES, be associated with tooth location. Placement on this table allows control over whether canine data may be collected on decidious teeth -- control which is not needed at this time.
This column may not be NULL.
Boolean value indicating whether the tooth is
deciduous or adult. TRUE indicates the tooth is
deciduous. FALSE indicates the tooth is adult.
This column may not be NULL.
I am inclined to make the name of this column be Adult rather than Deciduous for reasons of brevity, but I believe that Susan prefers it as-is. I would like feedback from the folks who are likely to be doing the typing. (KOP)
The site of the tooth within the mouth. Legal values for this column are defined by the TOOTHSITES table.
This column may be used to correlate the locations of deciduous teeth with their adult counterparts.
This column may not be NULL.
I am inclined to make the name of this column be Site, but I believe that Susan prefers it as-is. I would like feedback from the folks who are likely to be doing the typing. (KOP)
The locations of a baboon's teeth within the mouth. This table is used to correlate adult with deciduous teeth. Any given TOOTHSITES code cannot be used in two TOOTHCODES rows having the same TOOTHCODES.Deciduous value -- at most one adult and one deciduous tooth can have the same location within the mouth.
TOOTHSITES defines values for TOOTHCODES.Toothsite.
Codes describing the degree to which a tooth is present or absent in the mouth.
The degree to which the tooth is present or absent is a property distinct from the condition of the tooth. The latter property is described by the codes in the TCONDITIONS table.
The value M
(missing) has a special meaning to the system. TEETH rows that describe missing teeth must have
NULL TEETH.Tcondition values.