GeneX Development Supported By
|
GeneX-2.0 DB: ProtocolApplication Table
|
GeneX-2.0 DB: ProtocolApplication Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The ProtocolApplication table describes the concrete use in time by a person of a protocol. |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| activity_date | Activity Date | datetime | true | the date when the protocol was performed |
| performer_con_fk | Protocol Performer | int | true | the person who performed the protocol |
| proto_app_pk | Accession Number | serial | false | |
| protocol_fk | Protocol | int | true | The protocol that was performed |
| Primary Key Information |
| Column Name |
| proto_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 |
| protocol_fk | Protocol | protocol_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| Index Information |
| Name | Column Name |
|