-
Notifications
You must be signed in to change notification settings - Fork 0
Term Table
Peter Midford edited this page Aug 12, 2015
·
4 revisions
This table holds rows that represent class terms (e.g., spider, legI, not individuals). These are mostly loaded from source ontologies.
The term table contains 132245 rows.
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| id | int | NO | NULL | primary key, auto increments |
| domain | int | YES | NULL | foreign key to domain table |
| authority | int | YES | NULL | foreign key to authority table |
| comment | varchar(512) | YES | NULL | rdf:comment from source ontology |
| generated_id | varchar(512) | YES | NULL | rarely used, likely deprecated by uidset |
| label | varchar(512) | YES | NULL | rdf:label from source ontology |
| source_id | varchar(512) | YES | NULL | URI from source ontology |
| uidset | int | YES | NULL | foreign key to uidset table |