WormBase Schema for Model: Person
expand all nodes | collapse all nodes
| ?Person | PostgreSQL_id | UNIQUE | Text | ||||
|---|---|---|---|---|---|---|---|
| DB_info | Database | ?Database | ?Database_field | ?Text | |||
| Name | First_name | UNIQUE | Text | ||||
| Middle_name | Text | ||||||
| Last_name | UNIQUE | ?Person_name | XREF | Last_name_of | |||
| Standard_name | UNIQUE | ?Person_name | XREF | Standard_name_of | |||
| Full_name | UNIQUE | ?Person_name | XREF | Full_name_of | |||
| Also_known_as | ?Person_name | XREF | Other_name_of | ||||
| Principal_investigator | |||||||
| CGC_representative_for | ?Laboratory | XREF | Representative | ||||
| Laboratory | ?Laboratory | XREF | Registered_lab_members | ||||
| Affiliation | Text | ||||||
| Conducted | ?Analysis | XREF | Conducted_by | ||||
| Address | #Address | ||||||
| Tracking | Old_laboratory | ?Laboratory | XREF | Past_lab_members | |||
| Last_verified | UNIQUE | DateType | |||||
| Last_attempt_to_contact | UNIQUE | DateType | UNIQUE | Text | |||
| Old_address | DateType | #Address | |||||
| Left_the_field | Text | ||||||
| History | Merged_into | UNIQUE | ?Person | XREF | Acquires_merge | ||
| Acquires_merge | ?Person | XREF | Merged_into | ||||
| Status | Valid | ||||||
| Invalid | |||||||
| Comment | Text | ||||||
| Community_curation | Author_first_pass_curation | ?Paper | XREF | Author_first_pass | |||
| Phenotype_curator_for | ?Paper | XREF | Phenotype_curation_by | ||||
| Lineage | Supervised | ?Person | XREF | Supervised_by | #Role | ||
| Supervised_by | ?Person | XREF | Supervised | #Role | |||
| Worked_with | ?Person | XREF | Worked_with | #Role | |||
| Publication | Paper | ?Paper | XREF | Person | #Evidence | ||
| Not_paper | ?Paper | XREF | Not_person | #Evidence | |||
| Publishes_as | ?Author | ||||||
| Possibly_publishes_as | ?Author | XREF | Possible_person |
