-
Notifications
You must be signed in to change notification settings - Fork 0
Database Summary
Pending a full schema diagram, the arachadmin database is documented here. Each table is documented on its own wiki page. The page includes a description, a breakdown of the columns, and a snapshot count (which may not be completely current) of the number of rows. Not every table is currently populated - some are leftover experiments that haven't been removed yet, others support features that aren't fully implemented yet (e.g., the evidence_codes table).
Note that all tables use an integer id column as their primary index (even when unique global identifiers, such as URI's are available). This is a requirement of the web2py platform used for the arachadmin application. Note that foreign keys (currently without exception) always refer to the integer key of the linked table - thus this is not mentioned in the key column's description.
- author
- author_merge
- authority
- authorship
- claim
- domain
- evidence_code
- individual
- individual2narrative
- narrative
- ontology_processing
- ontology_source
- participant
- participant2claim
- participant_element
- participant_link
- participant_type
- pelement2individual
- pelement2term
- property
- publication
- publication_curation
- synonym
- taxon
- taxonomy_authority
- term
- term_synonym
- term_usage
- uidset