-
Notifications
You must be signed in to change notification settings - Fork 0
Narrative Table
Peter Midford edited this page Aug 10, 2015
·
2 revisions
This table holds rows representing narratives. A narrative is a (usually) ordered set of claims involving individuals. An example is a description of courtship, where the male and female are roles are filled by individuals (roles are not yet explicitly implemented yet). The narrative is in turn part of the publication. Claims that are not part of a narrative are directly part of the publication. Note that a narrative commonly involves more than one individual, but an individual may appear in more than one narrative. Narratives should be annotated by a behavior ontology term that describes the whole sequence.
The narrative table currently has 2 rows.
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| id | int | NO | NULL | primary key; auto increments |
| publication | int(11) | YES | NULL | foreign key to publication table |
| label | varchar(64) | YES | NULL | |
| description | varchar(512) | YES | NULL | |
| generated_id | varchar(512) | YES | NULL | may be obsolete |
| uidset | int(11) | YES | NULL | foreign key to uidset table |
| behavior_annotation | int(11) | YES | NULL | foreign key to term table |