GeneX-2.0 DB: ProtocolStepApplication Table
GeneX-2.0 DB: ProtocolStepApplication Table
Table TypeInheritsComment
DATASecurable The ProtocolStepApplication table describes the concrete use in time by a person of a protocol step.

Column Information
Column NameFull NameData TypeNot NULLComment
activity_dateActivity Datedatetimetrue the date when the protocol step was performed
outputOutputtextfalseThe output from a computational procedure
performer_con_fkProtocol Step Performerinttrue the person who performed the protocol step
proto_app_fkProtocol ApplicationinttrueThe protocol application that this step is part of
proto_step_app_pkAccession Numberserialfalse
proto_step_fkProtocol StepinttrueThe protocol step that was performed
statusStatuschar128trueA CV term that indicates what the current status of the step - primarily useful for computational methods that take some time to finish executing. Applications can poll this table to discover when an given step is finished.

Primary Key Information
Column Name
proto_step_app_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
performer_con_fkContactcon_pkMANY_TO_ONE
proto_app_fkProtocolApplicationproto_app_pkMANY_TO_ONE
proto_step_fkProtocolStepproto_step_pkMANY_TO_ONE

Unique Column Information
Column Names
proto_app_fk proto_step_fk

Index Information
NameColumn Name