conservdescription

Table info.

Title Conservator Description
Description Conservator Description

Fields

Name Type Required Index Hidden On form Title Pick list Description
ConservDescriptionID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
BackgroundInfo text Event type Event type
  • Destructive sampling
  • Damage to specimen
 Type of event - destructive sampling, or damage to specimen.
Composition text Composition composition
Description text Description description
DisplayRecommendations text Display Recommendations displayRecommendations
Height float(20,10) Height The height of the object.
LightRecommendations text Light Recommendations lightRecommendations
ObjLength float(20,10) Object Length The length of the object.
OtherRecommendations text Other Recommendations otherRecommendations
Remarks text Remarks Additional Comments
ShortDesc varchar(128) MUL Preparation Consrvator preparation
  • Sheet
  • Spirit
  • Carpological
  • Packet
  • Photographic slide
  • Microscope slide
  • Cibachrome
  • Photograph of specimen
  • Fungal culture
  • Display Set
  • Silica gel sample
 The preparation of the collection object that the conservator event relates to.
Source text Source source
Units varchar(16) Units The units for the measurements (`feet` or `meters`).
Width float(20,10) Width The width of the object.
DivisionID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
CatalogedDate date
determinedDatePrecision tinyint(4)
PreparationID int(11) MUL

Indexes

Name Fields Unique Nullable
ConservDescShortDescIDX ShortDesc
FKC040F46418627F06 PreparationID
FKC040F4645327F942 ModifiedByAgentID
FKC040F46475E37458 CollectionObjectID
FKC040F4647699B003 CreatedByAgentID
FKC040F46497C961D8 DivisionID
PRIMARY ConservDescriptionID

One-to-many relationships

Name Field Related table Related field
FK1EED20878FF9CFA6 ConservDescriptionID conservdescriptionattachment ConservDescriptionID
FK74A851028FF9CFA6 ConservDescriptionID conservevent ConservDescriptionID

Many-to-one relationships

Name Field Related table Related field
FKC040F46418627F06 PreparationID preparation PreparationID
FKC040F4645327F942 ModifiedByAgentID agent AgentID
FKC040F46475E37458 CollectionObjectID collectionobject CollectionObjectID
FKC040F4647699B003 CreatedByAgentID agent AgentID
FKC040F46497C961D8 DivisionID division UserGroupScopeId