dnaprimer

Table info.

Title DNA Primer
Description DNA Primer

Fields

Name Type Required Index Hidden On form Title Pick list Description
DNAPrimerID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Integer1 int(11) Integer1 integer1
Integer2 int(11) Integer2 integer2
Number1 float Number1 number1
Number2 float Number2 number2
PrimerDesignator varchar(64) MUL Primer Designator primerDesignator
PrimerNameForward varchar(64) Primer Name Forward primerNameForward
PrimerNameReverse varchar(64) Primer Name Rev primerNameReverse
PrimerReferenceCitationForward varchar(300) Primer Ref Cit Forward primerReferenceCitationForward
PrimerReferenceCitationReverse varchar(300) Primer Ref Cit Rev primerReferenceCitationReverse
PrimerReferenceLinkForward varchar(300) Primer Ref Link Forward primerReferenceLinkForward
PrimerReferenceLinkReverse varchar(300) Primer Ref Link Rev primerReferenceLinkReverse
PrimerSequenceForward varchar(128) Primer Seq Forward primerSequenceForward
PrimerSequenceReverse varchar(128) Primer Seq Rev primerSequenceReverse
purificationMethod varchar(255) Purification Method purificationMethod
Remarks text Remarks remarks
ReservedInteger3 int(11) Reserved Integer3 reservedInteger3
ReservedInteger4 int(11) Reserved Integer4 reservedInteger4
ReservedNumber3 float Reserved Number3 reservedNumber3
ReservedNumber4 float Reserved Number4 reservedNumber4
ReservedText3 text Reserved Text3 reservedText3
ReservedText4 text Reserved Text4 reservedText4
Text1 text Text1 text1
Text2 text Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
DesignatorIDX PrimerDesignator
FK5E4FB5AA5327F942 ModifiedByAgentID
FK5E4FB5AA7699B003 CreatedByAgentID
PRIMARY DNAPrimerID

One-to-many relationships

Name Field Related table Related field
FK2AF6F9D68C3587CC DNAPrimerID dnasequencingrun DNAPrimerID

Many-to-one relationships

Name Field Related table Related field
FK5E4FB5AA5327F942 ModifiedByAgentID agent AgentID
FK5E4FB5AA7699B003 CreatedByAgentID agent AgentID