ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Directives

Describes the directive or purpose under which actions are made. Dire...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	DirectiveID	Integer				Unique identifier.
	DirectiveTypeCV	VarChar(255)				Directive type, such as project, intended analyte/analysis for a Specimen, etc.
	DirectiveDescription	VarChar(5000)				Text description of the directive or purpose under which the action was taken.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Directives_CV_DirectiveType	ODM2CV.CV_DirectiveType	ODM2LabAnalyses.Directives	Name	DirectiveTypeCV

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ActionDirectives_Directives	ODM2LabAnalyses.Directives	ODM2LabAnalyses.ActionDirectives	DirectiveID	DirectiveID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2LabAnalyses