-
Notifications
You must be signed in to change notification settings - Fork 0
Term_Usage Table
Peter Midford edited this page Aug 12, 2015
·
3 revisions
This table is leftover from an earlier representation of claims and is obsolete.
The term_usage table has 6 rows.
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| id | int | NO | NULL | primary key, auto increments |
| behavior_term | varchar(255) | YES | NULL | |
| publication_taxon | varchar(255) | YES | NULL | |
| direct_source | int | YES | NULL | foreign key to publication table |
| evidence | varchar(255) | YES | NULL | |
| secondary_source | int | YES | NULL | foreign key to publication table |
| anatomy | varchar(255) | YES | NULL | |
| participant_list | varchar(255) | YES | NULL | |
| obo_term_name | varchar(255) | YES | NULL | |
| obo_term_id | varchar(255) | YES | NULL | |
| nbo_term_name | varchar(255) | YES | NULL | |
| nbo_term_id | varchar(255) | YES | NULL | |
| abo_term | varchar(255) | YES | NULL | |
| description | longtext | YES | NULL | |
| resolved_taxon_id | int | YES | NULL | foreign key to taxon table |
| generated_behavior_id | varchar(255) | YES | NULL | |
| generated_anatomy_id | varchar(255) | YES | NULL | |
| resolved_taxon_name | varchar(255) | YES | NULL |