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 (2) | ||||||
Comment | Text | |||||
Community_curation (2) | ||||||
Lineage (3) | ||||||
Publication | Paper | ?Paper | XREF | Person | #Evidence | |
Not_paper | ?Paper | XREF | Not_person | #Evidence | ||
Publishes_as | ?Author | |||||
Possibly_publishes_as | ?Author | XREF | Possible_person |