eprints_cchange.eprints_cchange contains 209 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
eprint	abstract	mediumtext	16777215	√		null
user	address	mediumtext	16777215	√		null
subject_ancestors	ancestors	varchar	255	√		null
document	category	varchar	255	√		null
eprint	commentary	int	10	√		null
eprint	contact_email	varchar	255	√		null
document	content	varchar	255	√		null
user	country	varchar	255	√		null
document	date_embargo_day	smallint	5	√		null
document	date_embargo_month	smallint	5	√		null
document	date_embargo_year	smallint	5	√		null
eprint	datestamp_day	smallint	5	√		null
eprint	datestamp_hour	smallint	5	√		null
eprint	datestamp_minute	smallint	5	√		null
eprint	datestamp_month	smallint	5	√		null
eprint	datestamp_second	smallint	5	√		null
eprint	datestamp_year	smallint	5	√		null
subject	depositable	set	10	√		null
user	dept	varchar	255	√		null
eprint	dir	varchar	255	√		null
document	docid	int	10
eprint	edit_lock_since	int	10	√		null
eprint	edit_lock_until	int	10	√		null
eprint	edit_lock_user	int	10	√		null
user	email	varchar	255	√		null
eprint	eprint_status	varchar	255	√		null
document	eprintid	int	10	√		null
eprint	eprintid	int	10
eprint_mmc_conp	eprintid	int	10
eprint_mmc_cp	eprintid	int	10
eprint_mmc_form_research_links_desc	eprintid	int	10
eprint_mmc_form_research_links_href	eprintid	int	10
eprint_mmc_kwm	eprintid	int	10
eprint_mmc_la	eprintid	int	10
eprint_mmc_mf	eprintid	int	10
eprint_mmc_pretesting_links_desc	eprintid	int	10
eprint_mmc_pretesting_links_href	eprintid	int	10
eprint_mmc_prod	eprintid	int	10
eprint_mmc_produceremail	eprintid	int	10
eprint_mmc_summative_eval_links_desc	eprintid	int	10
eprint_mmc_summative_eval_links_href	eprintid	int	10
eprint_mmc_tgt	eprintid	int	10
eprint_mmc_videoaudio_desc	eprintid	int	10
eprint_mmc_videoaudio_href	eprintid	int	10
eprint_mmc_website	eprintid	int	10
eprint_mmc_yr	eprintid	int	10
eprint	fileinfo	mediumtext	16777215	√		null
document	format	varchar	255	√		null
document	formatdesc	varchar	255	√		null
saved_search	frequency	varchar	255	√		null
user	frequency	varchar	255	√		null
eprint	full_text_status	varchar	255	√		null
user	hideemail	set	10	√		null
saved_search	id	int	10
eprint	importid	int	10	√		null
eprint	item_issues_count	int	10	√		null
user	joined_day	smallint	5	√		null
user	joined_hour	smallint	5	√		null
user	joined_minute	smallint	5	√		null
user	joined_month	smallint	5	√		null
user	joined_second	smallint	5	√		null
user	joined_year	smallint	5	√		null
user	lang	varchar	255	√		null
document	language	varchar	255	√		null
eprint	lastmod_day	smallint	5	√		null
eprint	lastmod_hour	smallint	5	√		null
eprint	lastmod_minute	smallint	5	√		null
eprint	lastmod_month	smallint	5	√		null
eprint	lastmod_second	smallint	5	√		null
eprint	lastmod_year	smallint	5	√		null
eprint	latitude	float	12	√		null
user	latitude	float	12	√		null
document	license	varchar	255	√		null
eprint	longitude	float	12	√		null
user	longitude	float	12	√		null
saved_search	mailempty	set	10	√		null
user	mailempty	set	10	√		null
document	main	varchar	255	√		null
eprint	metadata_visibility	varchar	255	√		null
eprint	mmc_add	varchar	255	√		null
eprint	mmc_adp	varchar	255	√		null
eprint	mmc_cat	varchar	255	√		null
eprint	mmc_cnd	varchar	255	√		null
eprint	mmc_cnp	varchar	255	√		null
eprint	mmc_cond	varchar	255	√		null
eprint_mmc_conp	mmc_conp	varchar	255	√		null
eprint	mmc_conp_name	varchar	255	√		null
eprint	mmc_cost	varchar	255	√		null
eprint_mmc_cp	mmc_cp	varchar	255	√		null
eprint	mmc_ctyd	varchar	255	√		null
eprint	mmc_ctyp	varchar	255	√		null
eprint	mmc_dist	varchar	255	√		null
eprint	mmc_dupformat	varchar	255	√		null
eprint	mmc_ed	varchar	255	√		null
eprint	mmc_em_day	smallint	5	√		null
eprint	mmc_em_month	smallint	5	√		null
eprint	mmc_em_year	smallint	5	√		null
eprint	mmc_faxd	varchar	255	√		null
eprint	mmc_faxp	varchar	255	√		null
eprint	mmc_featured_day	smallint	5	√		null
eprint	mmc_featured_month	smallint	5	√		null
eprint	mmc_featured_year	smallint	5	√		null
eprint_mmc_form_research_links_desc	mmc_form_research_links_desc	varchar	255	√		null
eprint_mmc_form_research_links_href	mmc_form_research_links_href	varchar	255	√		null
eprint	mmc_formative_research	mediumtext	16777215	√		null
eprint_mmc_kwm	mmc_kwm	varchar	255	√		null
eprint_mmc_la	mmc_la	varchar	255	√		null
eprint	mmc_lo	varchar	255	√		null
eprint_mmc_mf	mmc_mf	varchar	255	√		null
eprint	mmc_nt	mediumtext	16777215	√		null
eprint	mmc_pd	mediumtext	16777215	√		null
eprint	mmc_phd	varchar	255	√		null
eprint	mmc_php	varchar	255	√		null
eprint	mmc_pretesting	mediumtext	16777215	√		null
eprint_mmc_pretesting_links_desc	mmc_pretesting_links_desc	varchar	255	√		null
eprint_mmc_pretesting_links_href	mmc_pretesting_links_href	varchar	255	√		null
eprint_mmc_prod	mmc_prod	varchar	255	√		null
eprint_mmc_produceremail	mmc_produceremail	varchar	255	√		null
eprint	mmc_sn	mediumtext	16777215	√		null
eprint	mmc_stat	mediumtext	16777215	√		null
eprint	mmc_std	varchar	255	√		null
eprint	mmc_stp	varchar	255	√		null
eprint_mmc_summative_eval_links_desc	mmc_summative_eval_links_desc	varchar	255	√		null
eprint_mmc_summative_eval_links_href	mmc_summative_eval_links_href	varchar	255	√		null
eprint	mmc_summative_evaluation	mediumtext	16777215	√		null
eprint_mmc_tgt	mmc_tgt	varchar	255	√		null
eprint	mmc_to	mediumtext	16777215	√		null
eprint	mmc_ud_day	smallint	5	√		null
eprint	mmc_ud_month	smallint	5	√		null
eprint	mmc_ud_year	smallint	5	√		null
eprint_mmc_videoaudio_desc	mmc_videoaudio_desc	varchar	255	√		null
eprint_mmc_videoaudio_href	mmc_videoaudio_href	varchar	255	√		null
eprint_mmc_website	mmc_website	varchar	255	√		null
eprint_mmc_yr	mmc_yr_day	smallint	5	√		null
eprint_mmc_yr	mmc_yr_month	smallint	5	√		null
eprint_mmc_yr	mmc_yr_year	smallint	5	√		null
eprint	mmc_zipd	varchar	255	√		null
eprint	mmc_zipp	varchar	255	√		null
saved_search	name	varchar	255	√		null
user	name_family	varchar	255	√		null
user	name_given	varchar	255	√		null
user	name_honourific	varchar	255	√		null
user	name_lineage	varchar	255	√		null
subject_name_name	name_name	varchar	255	√		null
user	newemail	varchar	255	√		null
user	newpassword	varchar	255	√		null
user	org	varchar	255	√		null
user	os	varchar	255	√		null
subject_parents	parents	varchar	255	√		null
user	password	varchar	255	√		null
user	pin	varchar	255	√		null
user	pinsettime	int	10	√		null
document	placement	int	10	√		null
document	pos	int	10	√		null
eprint_mmc_conp	pos	int	10			0
eprint_mmc_cp	pos	int	10			0
eprint_mmc_form_research_links_desc	pos	int	10			0
eprint_mmc_form_research_links_href	pos	int	10			0
eprint_mmc_kwm	pos	int	10			0
eprint_mmc_la	pos	int	10			0
eprint_mmc_mf	pos	int	10			0
eprint_mmc_pretesting_links_desc	pos	int	10			0
eprint_mmc_pretesting_links_href	pos	int	10			0
eprint_mmc_prod	pos	int	10			0
eprint_mmc_produceremail	pos	int	10			0
eprint_mmc_summative_eval_links_desc	pos	int	10			0
eprint_mmc_summative_eval_links_href	pos	int	10			0
eprint_mmc_tgt	pos	int	10			0
eprint_mmc_videoaudio_desc	pos	int	10			0
eprint_mmc_videoaudio_href	pos	int	10			0
eprint_mmc_website	pos	int	10			0
eprint_mmc_yr	pos	int	10			0
saved_search	pos	int	10	√		null
subject_ancestors	pos	int	10			0
subject_name_name	pos	int	10			0
subject_parents	pos	int	10			0
user	preference	blob	65535	√		null
saved_search	public	set	10	√		null
eprint	replacedby	int	10	√		null
document	rev_number	int	10	√		null
eprint	rev_number	int	10	√		null
saved_search	rev_number	int	10	√		null
subject	rev_number	int	10	√		null
user	rev_number	int	10	√		null
user	review_filters	text	65535	√		null
document	security	varchar	255	√		null
eprint	source	varchar	255	√		null
saved_search	spec	mediumtext	16777215	√		null
eprint	status_changed_day	smallint	5	√		null
eprint	status_changed_hour	smallint	5	√		null
eprint	status_changed_minute	smallint	5	√		null
eprint	status_changed_month	smallint	5	√		null
eprint	status_changed_second	smallint	5	√		null
eprint	status_changed_year	smallint	5	√		null
subject	subjectid	varchar	255
subject_ancestors	subjectid	varchar	255
subject_name_name	subjectid	varchar	255
subject_parents	subjectid	varchar	255
eprint	succeeds	int	10	√		null
eprint	sword_depositor	int	10	√		null
eprint	sword_slug	varchar	255	√		null
eprint	title	mediumtext	16777215	√		null
eprint	type	varchar	255	√		null
user	url	varchar	255	√		null
eprint	userid	int	10	√		null
saved_search	userid	int	10	√		null
user	userid	int	10
user	username	varchar	255	√		null
user	usertype	varchar	255	√		null