ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpecimenBatchPostions

Extends the FeatureActions table with a foreign key when the optional ...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	FeatureActionID	Integer				Foriegn key identifer for the Specimen Preparation or Analysis Batch
	BatchPositionNumber	Integer				The position or line number of a specimen within a PreparationBatchAction or an InstrumentAnalysisAction.
	BatchPositionLabel	VarChar(255)				The label text for a specimen within a PreparationBatchAction or an InstrumentAnalysisAction.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpecimenBatchPostions_FeatureActions	ODM2Core.FeatureActions	ODM2LabAnalyses.SpecimenBatchPostions	FeatureActionID	FeatureActionID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2LabAnalyses