#
# README.txt
#

First, see ERD in eprints_cchange.erviz-ie.pdf. For more details, see index.html
in "details" folder. 

Note that there are a few minor differences in markers in diagrams. The ERD in PDF 
should take precedence whenever there is a difference. 


The following tables are part of eprints_cchange schema but do not contain relevant data. 
A review may be warranted for eprint_mmc_* tables below, but the others can be savely 
ignored.


Tables with some data but not shown on public pages (EPrints multi-valued fields)

eprint_mmc_au: author
eprint_mmc_behav_chan_theories: behavior change theories
eprint_mmc_cdnumber
eprint_mmc_community_id
eprint_mmc_designator
eprint_mmc_dir
eprint_mmc_pdf
eprint_mmc_permissions
eprint_mmc_reg: region
eprint_mmc_rt: run-time of multimedia
eprint_mmc_se: series title

Auxiliary (internal) tables

access: access logs (similar to Apache access logs)
counters: stores highest identifier for various objects (eprint, user, savedsearch, etc)
document_permission_group: EMPTY table
document_relation_*: info about generated thumbnail image files
eprint_item_issues_*: info about items not meeting certain repository imposed requirements
eprint_relation_*: EMPTY tables
event_queue: scheduler queue
file: metadata about all files (various IDs, filename, filesize, MIME type, timestamp)
file_copies_*: related to file table
history: info about changes to any objects that have revisions
import: bulk imports logging
irstats_*: IRStats, package for viewing access statistics
loginticket: info about account activation requests
message: EMPTY table
mf: EMPTY table
mf_fields_*: info about metadata fields (mostly EMPTY tables)
mf_phrases_*: info about metadata fields (mostly EMPTY tables)
request: info about requests for full-texts by email
subject_name_lang: used with multilingual taxonomy terms
triple: RDF related
upload_progress: uploads-in-progress state
user_editperms: EMPTY table
user_items_fields: fields visible to users when browsing items in user workarea
user_permission_group: EMPTY table
user_review_fields: fields visible to editors when browsing submitted items
user_roles: EMPTY table
version: EPrints version number

Built-in free-text search related tables (based on MySQL MyISAM full-text search index)
[simple and advanced search use Sphinx search engine, though other areas of website still 
rely on built-in search engine]

cache<N>: (where N is some a 7-digit integer) cached searches
cachemap: stores IDs of temporary search results table IDs so they can be erased later
index_queue: related to scheduling of indexing runs as data changes
*__index: index codes
*__index_grep: filter codes
*__ordervalues_en: sort results
*__rindex: reverse index codes


