ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpecimenCollection

This has the specimen collection information

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	SpecimenCollectionID	Integer				Primary Key for the Specimen Collection
	SpecimenCollectionCV	VarChar(255)				A CV term defining the specimen collection
	SpecimenCollectionFile	VarChar(255)
	SpecimenCollectionName	VarChar(255)				The name of the specimen collection
	SpecimenCollectionNote	VarChar(5000)				Note describing details on the specimen collection
	ParentSpecimenCollectionID	Integer				The ID of the Parent Specimen Collection

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpecimenCollection_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	SpecimenCollectionID	ParentSpecimenCollectionID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpecimenCollection_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	SpecimenCollectionID	ParentSpecimenCollectionID
fk_Specimens_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.Specimens	SpecimenCollectionID	SpecimenCollectionID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2SamplingFeatures