ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ResultAnnotations

Notes for or groups of one or more Results [sets].

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	ResultID	BigInt				Foreign key of the result being annotated
	AnnotationID	Integer				Foreign key of the annotation added to the result
	BeginDateTime	DateTime				Beginning date/time of the annotation
	EndDateTime	DateTime				Ending date/time of the annotation

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ResultAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ResultAnnotations	AnnotationID	AnnotationID
fk_ResultAnnotations_Results	ODM2Core.Results	ODM2Annotations.ResultAnnotations	ResultID	ResultID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2Annotations