pcrperson

Table info.

Title Pcr Persons
Description Pcr Persons

Fields

Name Type Required Index Hidden On form Title Pick list Description
PcrPersonID int(11) PRI
TimestampCreated datetime Timestamp Created Timestamp Created
TimestampModified datetime Timestamp Modified Timestamp Modified
Version int(11) Version Version
OrderNumber int(11) Order Number Order Number
Remarks text Remarks Remarks
Text1 text Text1 Text1
Text2 text Text2 Text2
YesNo1 bit(1) Yes No1 Yes No1
YesNo2 bit(1) Yes No2 Yes No2
ModifiedByAgentID int(11) MUL
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
DNASequenceID int(11) MUL

Indexes

Name Fields Unique Nullable
AgentID AgentID, DNASequenceID
FK5D6EE8F4265FB168 DNASequenceID
FK5D6EE8F4384B3622 AgentID
FK5D6EE8F45327F942 ModifiedByAgentID
FK5D6EE8F47699B003 CreatedByAgentID
PRIMARY PcrPersonID

Many-to-one relationships

Name Field Related table Related field
FK5D6EE8F4265FB168 DNASequenceID dnasequence DnaSequenceID
FK5D6EE8F4384B3622 AgentID agent AgentID
FK5D6EE8F45327F942 ModifiedByAgentID agent AgentID
FK5D6EE8F47699B003 CreatedByAgentID agent AgentID