conservevent

Table info.

Title Conservator Event
Description Conservator Event

Fields

Name Type Required Index Hidden On form Title Pick list Description
ConservEventID 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
AdvTestingExam text Verbatim date noticed The date the damage was noticed
AdvTestingExamResults text Cause of damage Cause of damage
  • beetle
  • cigarette beetle
  • fire
  • human
  • inadequate packaging
  • insect
  • mould
  • psocids
  • silverfish
  • unknown
  • water
  • wood-rot fungus
The organism, person or event that caused damage to the specimen. The value of this field must be one of the following: cigarette beetles, silverfish, psocids, human, fire, water, mould, wood-rot fungus, unknown.
CompletedComments text Results Statement of the results of destructive sampling (e.g. whether DNA was successfully extracted).
CompletedDate date MUL Sampling date Date destructive sampling was conducted.
ConditionReport text Severity Severity
  • minor
  • moderate
  • severe
The severity of the damage. The value of this field must be one of the following: minor, moderate, severe.
CuratorApprovalDate date Approval Date curatorApprovalDate
ExamDate date MUL Date noticed The date damage to a specimen was noticed.
PhotoDocs text Purpose The intended purpose of destructive sampling (e.g. DNA sequencing, obtaining pollen sample, leaf cuticle analysis).
Remarks text Comments Any additional information about sampling from or damage to the preparation.
Text1 varchar(64) Part of specimen The part of the MEL specimen that has been damaged or sampled from (e.g. flowers, leaves, roots).
Text2 varchar(64) Text2 text2
Number1 int(11) Date precison Date precision
  • day
  • month
  • year
Precision of the date damage to a specimen was noticed (day, month or year).
Number2 int(11) Date precision Date precision
  • day
  • month
  • year
Precision of the date of destructive sampling (day, month, year).
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
TreatmentCompDate date Date assessed The date when damage to a specimen was assessed by a curator.
TreatmentReport text Treatment report A description of the treatment provided.
TreatedByAgentID int(11) MUL
ConservDescriptionID int(11) MUL
CreatedByAgentID int(11) MUL
CuratorID int(11) MUL
ModifiedByAgentID int(11) MUL
ExaminedByAgentID int(11) MUL
CompletedDatePrecision tinyint(4) Completed Date Precision completedDatePrecision
CuratorApprovalDatePrecision tinyint(4) Curator Approval Date Precision curatorApprovalDatePrecision
ExamDatePrecision tinyint(4) Exam Date Precision examDatePrecision
TreatmentCompDatePrecision tinyint(4) Treatment Comp Date Precision treatmentCompDatePrecision

Indexes

Name Fields Unique Nullable
ConservCompletedDateIDX CompletedDate
ConservExamDateIDX ExamDate
FK74A8510227E00C28 ExaminedByAgentID
FK74A851025327F942 ModifiedByAgentID
FK74A8510271496BD2 TreatedByAgentID
FK74A851027699B003 CreatedByAgentID
FK74A85102828C4E73 CuratorID
FK74A851028FF9CFA6 ConservDescriptionID
PRIMARY ConservEventID

One-to-many relationships

Name Field Related table Related field
FKD3F7CFA5F849E7A2 ConservEventID conserveventattachment ConservEventID

Many-to-one relationships

Name Field Related table Related field
FK74A8510227E00C28 ExaminedByAgentID agent AgentID
FK74A851025327F942 ModifiedByAgentID agent AgentID
FK74A8510271496BD2 TreatedByAgentID agent AgentID
FK74A851027699B003 CreatedByAgentID agent AgentID
FK74A85102828C4E73 CuratorID agent AgentID
FK74A851028FF9CFA6 ConservDescriptionID conservdescription ConservDescriptionID