Table refs

This table lists all field names & column types for the MySQL database table 'refs' that's used in conjunction with refbase 0.8.0:

Field	Type	Example	Comment
author	text	Clough, LM; de Broyer, H-C; Ambrose Jr., WG	The author(s) of a publication. Separate family and given names with a comma & a space (', '). Multiple authors are separated with a semicolon & a space ('; ').
address	text	School of Environmental Sciences, University of East Anglia, Norwich, Norfolk, NR4 7TJ, UK, mailto:author@geos.com	The author's address or any other contact information like the email of the corresponding author. Separate multiple addresses with a semicolon & a space ('; ').
corporate_author	varchar(255)	University of California	Use this field when the author of a particular publication is not a person, but an organization, government agency, company or other group. The personal author (if there is one) is subordinate to the organisation. In the case of a thesis, the student's institution (or university) can be regarded as the corporate author of the student's work. Sometimes, the corporate author is identical to the publisher of a publication.
first_author	varchar(100)	Clough, LM	This field holds the family and given name of the first author. It is required for proper sorting of references when citing. On edit refbase will automatically extract the first author from the author field and copy it to this field.
author_count	tinyint(3) unsigned	3	The number of authors of a publication. It is required for proper sorting of references when citing. On edit refbase will automatically assign the correct author count to this field.
title	text	Life and benthic environment in the Barents Sea	The title of a publication; don't append any dot to the title.
orig_title	text	Zhizn' i usloviya ee sushchestvovaniya v bentali Barentseva morya	Use this field for the original title of a publication if the title given in the title field is a translated or transliterated version of the original title.
publication	varchar(255)	Marine Ecology Progress Series	The full title of the journal or the book title.
abbrev_journal	varchar(100)	Mar Ecol Prog Ser	In case of journals, the abbreviated journal title.
year	smallint(6)	1998	The publication year; specify years in 4-digit format.
volume	varchar(50)	56A	The volume of a publication.
volume_numeric	smallint(5) unsigned	56	The number part of the publication volume. refbase uses this field when sorting by volume. While the volume field accepts any text the field volume_numeric is of numeric type and can only contain numbers. On edit refbase will automatically extract the first number from field volume and copy it to this field.
issue	varchar(50)	4	The issue (i.e. number) of a publication.
pages	varchar(50)	12-18	The page range (or total number of pages) of a publication. For journal articles & book chapters use the page range like in '12-18' (no 'pp'), for whole books enter the total no. of pages like in '316 pp' (i.e. append 'pp')
first_page	mediumint(8) unsigned	12	The first page of a publication (for journal articles or book chapters) or the total no. of pages in case of whole books. refbase uses this field when sorting by pages. On edit refbase will automatically extract the first number from field pages and copy it to this field.
keywords	text	sea ice; flooding; primary productivity; PS, Antarctic Ocean; PSW, Weddell Sea	Any keywords given by the authors of the publication. A user's personal keywords should be entered in the user-specific field user_keys (MySQL table 'user_data'). Separate multiple (unrelated) keywords with a semicolon & a space ('; '), if some keywords are somehow related, you may optionally separate them with a comma & a space (', ') instead.
abstract	text	Organic matter displayed a pronounced seasonal variation in carbon isotopes (expressed as [delta][super:13]C_[sub:OM]_).	The abstract or summary of the publication. The title, address, keywords and abstract fields support a markup language to provide rich text capabilities (i.e. italics, super/sub-script, greek letters, etc). E.g., the markup in the example would display as δ13COM. See Refbase markup syntax as well as the file initialize/ini.inc.php for further information.
edition	tinyint(3) unsigned	2	The edition number of a publication.
editor	text	Ackley, SF; Weeks, WF	The editor(s) of a publication. Format names as described for field author.
publisher	varchar(255)	American Geophysical Union	The publisher of a publication.
place	varchar(100)	Washington, DC	The place of publication.
medium	varchar(50)	CD-ROM	Contains the medium type of a publication if not paper (e.g. CD-ROM, cassettes, disks, transparencies, negatives, slides, etc.)
series_editor	text	Strelkov, A	The series editor(s). Format names as described for field author.
series_title	text	UNESCO Monographs on Oceanographic Methodology	If the publication is part of a series, this field holds the full title of the series.
abbrev_series_title	varchar(100)	UNESCO Monogr Oceanogr Methodol	The abbreviated series title.
series_volume	varchar(50)	6	The series volume of a publication.
series_volume_numeric	smallint(5) unsigned	6	The number part of the series volume. refbase uses this field when sorting by series_volume. While the series_volume field accepts any text the field series_volume_numeric is of numeric type and can only contain numbers. On edit refbase will automatically extract the first number from field series_volume and copy it to this field.
series_issue	varchar(50)	II	The issue (i.e. number) of the series volume.
issn	varchar(100)	0148-0227	If the publication is (part of) a journal or a dissertation, specify it's ISSN number in this field.
isbn	varchar(100)	0-12-026143-X	If the publication is a book (chapter), specify it's ISBN number in this field.
language	varchar(100)	Russian	The language of the body text.
summary_language	varchar(100)	English; Russian	The language of the summary or abstract. Separate multiple language identifiers with a semicolon & a space ('; ').
area	varchar(255)	Antarctic; McMurdo Sound	The area of investigation this publication deals with. Multiple items should be separated with a semicolon & a space ('; ').
type	varchar(100)	Journal Article	The reference type of a publication. By default refbase recognizes 'Journal Article', 'Book Chapter', 'Book Whole', 'Journal', 'Manuscript' and 'Map'.
thesis	enum("Bachelor's thesis","Master's thesis","Ph.D. thesis","Diploma thesis","Doctoral thesis","Habilitation thesis")	Ph.D. thesis	If the publication is a thesis, specify the degree in this field. By default refbase recognizes 'Bachelor’s thesis', 'Master’s thesis', 'Ph.D. thesis', 'Diploma thesis', 'Doctoral thesis' and 'Habilitation thesis'.
expedition	varchar(255)	Norwegian Antarctic Research Expedition (NARE) 2000/2001	The name of the expedition where sampling took place.
doi	varchar(100)	10.1007/s00300-004-0674-5	The unique Digital Object Identifier (DOI) of this publication.
conference	varchar(255)	International Symposium on Polar Aspects of Global Change, Tromsø (Norway), 24-28 Aug 1998	The conference this publication was initially presented at.
url	varchar(255)	https://www.int-res.com/abstracts/meps/v251/p37-47/	The web address providing more information for this publication.
call_number	text	IPÖ @ msteffens @ 83; IPÖ @ mschmid @ Be 100; AWI @ tmock @ Ice-23	Contains a user's identifier tag & personal reference number that uniquely identifies this record for the user. Multiple items should be separated with a semicolon & a space ('; '). This field is controlled (and automatically filled) by refbase on edit. Syntax: institutional abbreviation @ email user name @ personal reference number
location	text	Matthias Steffens (msteffens@ipoe.de); Michael Schmid (mschmid@ipoe.de); Thomas Mock (tmock@awi.ac.uk)	Contains all users who have added this record to their personal literature data set. Multiple users should be separated with a semicolon & a space ('; '). Like the call_number field, this field is controlled (and automatically filled) by refbase on edit. Syntax: user name (email address)
contribution_id	varchar(100)	IPÖ; AWI	Holds the institutional abbreviation of a database user if this publication was published by this user or a member of his institution. Multiple items must be separated with a semicolon & a space ('; '). Information in this field can be used to generate a dynamic web page of all publications that were published by a particular institution. See here for more information.
online_publication	enum("no","yes")	no	Set to 'yes' if this publication is an online publication that has no print equivalent (yet). Must be either 'yes' or 'no'.
online_citation	varchar(255)	L09402	Contains any additional information that's required to locate the online location of the publication. If online_publication is 'yes', the contents of this field will be printed (together with the doi number) in place of pages when citing.
file	varchar(255)	Science295p641.pdf	The name of (or path to) a file that's associated with this publication (e.g. a PDF file). The file field accepts full URLs (which must start with either 'http://' or 'ftp://') as well as relative or absolute paths to the file (if it's located on your server). Any string that's not a full URL will be prefixed with the string given in $filesBaseURL (file initialize/ini.inc.php).
notes	text	Species identification book; richly illustrated keys with 135 tables with b/w morphological drawings	Any generic notes for this publication. Multiple items should be separated with a semicolon & a space ('; '). A user's personal notes should be entered in the user-specific field user_notes (MySQL table 'user_data').
serial	mediumint(8) unsigned	1297	The unique database serial number of the publication (i.e. the MySQL primary key). The serial number is automatically filled in by MySQL when importing/adding records and is used to uniquely identify a particular database entry.
orig_record	mediumint(9)	-1297	In the case of duplicates, this field indicates whether this record is considered as the original record or as a duplicate entry. If it's an original record, the orig_record field contains the record's own serial number prefixed with a minus ('-') sign. If this record is a duplicate entry, orig_record will contain the serial number of the original record. By this, the orig_record field can be used to flag or hide any duplicates and point to the original record instead. Currently, refbase will only flag original/duplicate records using appropriate icons.
approved	enum("no","yes")	yes	Set to 'yes' if you've verified this record for correctness, otherwise set to 'no'. Must be either 'yes' or 'no'.
created_date	date	2004-12-31	The creation date of this record. This field is controlled (and automatically filled) by refbase when adding a record. Date format must be YYYY-MM-DD.
created_time	time	19:08:44	The creation time of this record. This field is controlled (and automatically filled) by refbase when adding a record. Time format must be HH:MM:SS.
created_by	varchar(100)	Matthias Steffens (msteffens@ipoe.de)	Contains the name and email address of the person who created this record. This field is controlled (and automatically filled) by refbase when adding a record. Syntax: user name (email address).
modified_date	date	2005-03-22	The modification date of this record. This field is controlled (and automatically filled) by refbase when editing a record. Date format must be YYYY-MM-DD.
modified_time	time	23:50:52	The modification time of this record. This field is controlled (and automatically filled) by refbase when editing a record. Time format must be HH:MM:SS.
modified_by	varchar(100)	Michael Schmid (mschmid@ipoe.de)	Contains the name and email address of the last person who modified this record. This field is controlled (and automatically filled) by refbase when editing a record. Syntax: user name (email address).