Difference between revisions of "WormBase Model:Person"
From WormBaseWiki
Jump to navigationJump to search (Created page with '__TOC__ WormBase Models == Curator Comments/Description == == Model == <pre> </pre> == Proposed Changes ==') |
|||
| Line 11: | Line 11: | ||
== Model == | == Model == | ||
<pre> | <pre> | ||
| + | /////////////////// | ||
| + | // ?Person class // | ||
| + | /////////////////// | ||
| + | |||
| + | ?Person PostgreSQL_id UNIQUE Text // for linking to internal RDB | ||
| + | // Text instead of Int so it says WBperson#### | ||
| + | Name First_name UNIQUE Text // prefered first name | ||
| + | Middle_name Text // middle name(s) | ||
| + | Last_name UNIQUE ?Person_name XREF Last_name_of // prefered last name | ||
| + | Standard_name UNIQUE ?Person_name XREF Standard_name_of // name to be used for displays | ||
| + | // default is "First_name Last_name" | ||
| + | Full_name UNIQUE ?Person_name XREF Full_name_of // field for storing long name [030321 krb] | ||
| + | Also_known_as ?Person_name XREF Other_name_of // new XREF added [030310 krb] | ||
| + | CGC_representative_for ?Laboratory XREF Representative | ||
| + | Laboratory ?Laboratory XREF Registered_lab_members | ||
| + | Conducted ?Analysis XREF Conducted_by | ||
| + | Address #Address | ||
| + | Tracking Old_laboratory ?Laboratory XREF Past_lab_members // Lab(s) the person previously worked in | ||
| + | Last_verified UNIQUE DateType // Last time the name/contact information in this record was actively verified | ||
| + | Last_attempt_to_contact UNIQUE DateType UNIQUE Text // Text is method of attempt to contact | ||
| + | Old_address DateType #Address // for history | ||
| + | Left_the_field Text | ||
| + | History Merged_into UNIQUE ?Person XREF Acquires_merge | ||
| + | Acquires_merge ?Person XREF Merged_into | ||
| + | Status Valid | ||
| + | Invalid | ||
| + | Comment Text | ||
| + | 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 // confirmed author names (curated) can't XREF because of paper model | ||
| + | Possibly_publishes_as ?Author XREF Possible_person | ||
| + | // curated for Author->Paper->Person | ||
| + | // connection but not yet verified by | ||
| + | // the Person | ||
</pre> | </pre> | ||
== Proposed Changes == | == Proposed Changes == | ||
| + | |||
| + | ==Unused tags== | ||
| + | PostgreSQL_id | ||
| + | |||
| + | Publishes_as | ||
Latest revision as of 16:10, 4 October 2010
Curator Comments/Description
Model
///////////////////
// ?Person class //
///////////////////
?Person PostgreSQL_id UNIQUE Text // for linking to internal RDB
// Text instead of Int so it says WBperson####
Name First_name UNIQUE Text // prefered first name
Middle_name Text // middle name(s)
Last_name UNIQUE ?Person_name XREF Last_name_of // prefered last name
Standard_name UNIQUE ?Person_name XREF Standard_name_of // name to be used for displays
// default is "First_name Last_name"
Full_name UNIQUE ?Person_name XREF Full_name_of // field for storing long name [030321 krb]
Also_known_as ?Person_name XREF Other_name_of // new XREF added [030310 krb]
CGC_representative_for ?Laboratory XREF Representative
Laboratory ?Laboratory XREF Registered_lab_members
Conducted ?Analysis XREF Conducted_by
Address #Address
Tracking Old_laboratory ?Laboratory XREF Past_lab_members // Lab(s) the person previously worked in
Last_verified UNIQUE DateType // Last time the name/contact information in this record was actively verified
Last_attempt_to_contact UNIQUE DateType UNIQUE Text // Text is method of attempt to contact
Old_address DateType #Address // for history
Left_the_field Text
History Merged_into UNIQUE ?Person XREF Acquires_merge
Acquires_merge ?Person XREF Merged_into
Status Valid
Invalid
Comment Text
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 // confirmed author names (curated) can't XREF because of paper model
Possibly_publishes_as ?Author XREF Possible_person
// curated for Author->Paper->Person
// connection but not yet verified by
// the Person
Proposed Changes
Unused tags
PostgreSQL_id
Publishes_as
