materialsample

Table info.

Title Material Sample
Description Material Sample

Fields

Name Type Required Index Hidden On form Title Pick list Description
MaterialSampleID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
GGBNAbsorbanceRatio260_230 float
GGBNAbsorbanceRatio260_280 float
GGBNRAbsorbanceRatioMethod varchar(64)
GGBNConcentration float
GGBNConcentrationUnit varchar(64)
GGBNMaterialSampleType varchar(64)
GGBNMedium varchar(64)
GGBNPurificationMethod varchar(64)
GGBNQuality varchar(64)
GGBNQualityCheckDate date
GGBNQualityRemarks text
GGBNSampleDesignation varchar(128) MUL
GGBNSampleSize float
GGBNVolume float
GGBNVolumeUnit varchar(64)
GGBNWeight float
GGBNWeightMethod varchar(64)
GGBNWeightUnit varchar(64)
GUID varchar(128) Guid guid
Integer1 int(11) Integer1 integer1
Integer2 int(11) Integer2 integer2
Number1 float Number1 number1
Number2 float Number2 number2
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
SRABioProjectID varchar(64) SRA Bio Project ID sraBioProjectID
SRABioSampleID varchar(64) SRA Bio Sample ID sraBioSampleID
SRAProjectID varchar(64) SRA Project ID sraProjectID
SRASampleID varchar(64) SRA Sample ID sraSampleID
Text1 text Text1 text1
Text2 text Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
ModifiedByAgentID int(11) MUL
PreparationID int(11) MUL
CreatedByAgentID int(11) MUL
ExtractionDate date Extraction Date extractionDate
ExtractorID int(11) MUL

Indexes

Name Fields Unique Nullable
DesignationIDX GGBNSampleDesignation
FKD5CE219118627F06 PreparationID
FKD5CE21915327F942 ModifiedByAgentID
FKD5CE21917699B003 CreatedByAgentID
FKD5CE2191E43B7581 ExtractorID
PRIMARY MaterialSampleID

One-to-many relationships

Name Field Related table Related field
FK9F42F5D8A1F7C080 MaterialSampleID dnasequence MaterialSampleID

Many-to-one relationships

Name Field Related table Related field
FKD5CE219118627F06 PreparationID preparation PreparationID
FKD5CE21915327F942 ModifiedByAgentID agent AgentID
FKD5CE21917699B003 CreatedByAgentID agent AgentID
FKD5CE2191E43B7581 ExtractorID agent AgentID