The Aptamer Database contains six tables:
The diagram below illustrates their connectivity.
c2a is a citation to author connector table. An author may publish more
than one paper and a paper may have more than one author. Citations and
authors are then kept in independent tables and are assigned unique IDs.
c2a table helps to determine who authored what paper. Each row in c2a
has the two IDs: the author ID and the ID of the paper he published.
c2a table
Field
Type
Null
Key
Default
Extra
cit_id int(10) unsigned 0
au_id int(10) unsigned 0