The table t_refdb
Prev Chapter 16. Reference database design Next

The table t_refdb

This table is the main table of the database and holds all fields which are unique to one reference entry and not different between users.

This table contains the following columns:

refdb_id

This unique identifier for entries in t_refdb is automatically generated by refdb and is stored as a BIGINT value (INTEGER for SQLite).

refdb_citekey

This is a user-supplied unique identifier for entries in t_refdb. If not supplied by the user, RefDB will create a unique identifier when the entry is added.

refdb_type

This indicates the type of the document. This six-character string must be one of the following:

  • ABST (abstract reference)

  • ADVS (audiovisual material)

  • ART (art work)

  • BILL (bill/resolution)

  • BOOK (whole book reference)

  • CASE (case)

  • CHAP (book chapter reference)

  • COMP (computer program)

  • CONF (conference proceeding)

  • CTLG (catalog)

  • DATA (data file)

  • ELEC (electronic citation)

  • GEN (generic)

  • ICOMM (internet communication)

  • INPR (in press reference)

  • JFULL (journal - full)

  • JOUR (journal reference)

  • MAP (map)

  • MGZN (magazine article)

  • MPCT (motion picture)

  • MUSIC (music score)

  • NEWS (newspaper)

  • PAMP (pamphlet)

  • PAT (patent)

  • PCOMM (personal communication)

  • RPRT (report)

  • SER (serial - book, monograph)

  • SLIDE (slide)

  • SOUND (sound recording)

  • STAT (statute)

  • THES (thesis/dissertation)

  • UNBILL (unenacted bill/resolution)

  • UNPB (unpublished work reference)

  • VIDEO (video recording)

refdb_pubyear

This numerical value (SMALLINT) indicates the publication year.

refdb_secyear

This numerical value (SMALLINT) indicates the secondary year information.

refdb_startpage

This alphanumeric string (up to 255 characters) contains the start page information.

refdb_endpage

This alphanumeric string (up to 255 characters) contains the end page information.

refdb_abstract

This variable-length string contains the abstract or table of contents of the entry.

refdb_title

This alphanumeric field of variable length contains the title of the entry.

refdb_volume

This alphanumeric field (up to 255 characters) contains the volume number or identifier of the periodical.

refdb_issue

This alphanumeric field (up to 255 characters) contains the issue number or specifier.

refdb_booktitle

This alphanumeric field of variable length contains the book title (book chapter or whole book reference).

refdb_city

This alphanumeric field (up to 255 characters) contains the city where the periodical or book was published.

refdb_publisher

This alphanumeric field (up to 255 characters) contains the name of the publisher.

refdb_title_series

This alphanumerical field of variable length contains the title of a series of books or publications.

refdb_address

This alphanumeric field of variable length holds the address of the corresponding author and other contact information.

refdb_url

This alphanumeric field (up to 255 characters) holds a URL related to the entry, e.g. the homepage of an author or a link to an electronic reprint.

refdb_issn

This alphanumeric field with a maximum of 255 characters stores the ISSN or ISBN number of the publication.

refdb_pyother_info

This alphanumeric field with a maximum of 255 characters stores the additional information of a PY field after the publication year. The format is “/MM/DD/otherinfo”, with MM being the month and DD being the day of the publication. If either of these is missing, the corresponding slash “/” still has to be entered. The other information is free alphanumeric information.

refdb_secother_info

This alphanumeric field with a maximum of 255 characters provides the same additional information for the refdb_secyear field as the refdb_pyother_info field for refdb_pubyear.

refdb_periodical_id

This BIGINT (INTEGER for SQLite) variable points to the periodical_id in t_periodical which corresponds to the periodical the given article appeared in.

refdb_user1 through refdb_user5

These alphanumeric fields with a maximum of 255 characters provide space for user-defined information.

refdb_typeofwork

This alphanumeric field with a maximum of 255 characters stores tye type of work of some reference types.

refdb_area

This alphanumeric field with a maximum of 255 characters stores the area information of MAP entries.

refdb_ostype

This alphanumeric field with a maximum of 255 characters stores the type of the operating system of a computer program.

refdb_degree

This alphanumeric field with a maximum of 255 characters stores the type of the degree of a THES reference..

refdb_runningtime

This alphanumeric field with a maximum of 255 characters stores the running time of several multimedia reference types.

refdb_classcodeintl

This alphanumeric field with a maximum of 255 characters stores the international class code of PAT references.

refdb_classcodeus

This alphanumeric field with a maximum of 255 characters stores the US class code of PAT references.

refdb_senderemail

This alphanumeric field with a maximum of 255 characters stores the email address of the sender of an ICOMM reference.

refdb_recipientemail

This alphanumeric field with a maximum of 255 characters stores the email address of the recipient of an ICOMM reference.

refdb_mediatype

This alphanumeric field with a maximum of 255 characters stores the type of the medium of a reference.

refdb_numvolumes

This alphanumeric field with a maximum of 255 characters stores the total number of volumes of a monographic item which is part of a limited series.

refdb_edition

This alphanumeric field with a maximum of 255 characters stores the edition of a monographic item.

refdb_computer

This alphanumeric field with a maximum of 255 characters stores the type of computer of a COMP reference.

refdb_conferencelocation

This alphanumeric field with a maximum of 255 characters stores the location of a conference of a CONF entry.

refdb_registrynum

This alphanumeric field with a maximum of 255 characters stores the registry number of JFULL entries.

refdb_classification

This alphanumeric field with a maximum of 255 characters stores the classification of multimedia entries.

refdb_section

This alphanumeric field with a maximum of 255 characters stores the section of a NEWS entry.

refdb_pamphletnum

This alphanumeric field with a maximum of 255 characters stores the number of the pamphlet of a PAMP entry.

refdb_chapternum

This alphanumeric field with a maximum of 255 characters stores the number of the chapter of a CHAP entry.

Prev Up Next
Chapter 16. Reference database design Home The table t_author