Table: SpecimenBatchPositions

Extends the FeatureActions table with a foreign key when the optional LabAnalyses schema is implemented. In a database implementation, we would not implement this as a separate table from FeatureActions, but rather just add the additional field(s).

Columns

PK	Name	Data Type	NULL	Auto	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()				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	ODMXCore.FeatureActions	ODMXLabAnalyses.SpecimenBatchPositions	FeatureActionID	FeatureActionID

Triggers

(none)

Used in Diagrams

ODMXLabAnalyses