-
Notifications
You must be signed in to change notification settings - Fork 0
Authorship Table
Peter Midford edited this page Aug 10, 2015
·
5 revisions
This table links a author row to a publication row, imposing an order, which would otherwise be lost, apart from the publication's raw author_string field.
The authorship table has 0 rows. It has been filled in previous versions, and a tool existing within the web app to generate it.
| Field | Type | Null | Default | Extra |
|---|---|---|---|---|
| id | int | NO | NULL | primary key, auto increments |
| publication | int | YES | NULL | foreign key to publication table |
| author | int | YES | NULL | foreign key to author table |
| position | int | YES | NULL | where the author appears in the list of authors |