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 (2) | ||||||
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 |