GeneX Development Supported By
|
GeneX-2.0 DB: ProtocolStepApplication Table
|
GeneX-2.0 DB: ProtocolStepApplication Table
|
| Table Type | Inherits | Comment |
| DATA | Securable | The ProtocolStepApplication table describes the concrete use in time by a person of a protocol step. |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| activity_date | Activity Date | datetime | true | the date when the protocol step was performed |
| output | Output | text | false | The output from a computational procedure |
| performer_con_fk | Protocol Step Performer | int | true | the person who performed the protocol step |
| proto_app_fk | Protocol Application | int | true | The protocol application that this step is part of |
| proto_step_app_pk | Accession Number | serial | false | |
| proto_step_fk | Protocol Step | int | true | The protocol step that was performed |
| status | Status | char128 | true | A 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 Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| performer_con_fk | Contact | con_pk | MANY_TO_ONE |
| proto_app_fk | ProtocolApplication | proto_app_pk | MANY_TO_ONE |
| proto_step_fk | ProtocolStep | proto_step_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| proto_app_fk proto_step_fk |
| Index Information |
| Name | Column Name |
|