ResultAnnotations - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: ResultAnnotations

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

Columns

PKNameData TypeNULLAutoDefaultCommentFK

BridgeIDInteger

nextval('"ODMXAnnotations"."ResultAnnotations_BridgeID_seq"'::regclass)Primary key for a bridge table, enabling many-to-many joins.
ResultIDBigInt Foreign key of the result being annotated

AnnotationIDInteger Foreign key of the annotation added to the result

BeginDateTimeDateTime Beginning date/time of the annotation
EndDateTimeDateTime Ending date/time of the annotation

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_ResultAnnotations_AnnotationsODMXAnnotations.AnnotationsODMXAnnotations.ResultAnnotationsAnnotationIDAnnotationID
fk_ResultAnnotations_ResultsODMXCore.ResultsODMXAnnotations.ResultAnnotationsResultIDResultID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXAnnotations