GUS Schema >> SRes::BibliographicReference

Each entry in this table represents a reference to an article, book, or other publication.

column nulls? type description
BIBLIOGRAPHIC_REFERENCE_ID no NUMBER(10,0) Primary key. Edit
BIB_REF_TYPE_ID no SRes::BibRefType (NUMBER(10,0) )FK to Sres.BibRefType. The id of the type of this bibliographic reference. Edit
TITLE no STRING(255) The title of the reference. Edit
AUTHORS STRING(500) The names of the authors. Edit
PUBLICATION STRING(255) The name of the journal in which this reference was published. Edit
EDITOR STRING(255) The name of the editor. Edit
YEAR NUMBER(5,0) The year this reference was published. Edit
VOLUME STRING(100) The volume number of the journal in which this reference was published. Edit
ISSUE STRING(100) The issue number of the journal in which this reference was published. Edit
PAGES STRING(100) The page numbers of this reference in the journal. Edit
URI STRING(250) The URI for this reference. Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) ) Edit
SOURCE_ID STRING(50) Edit
CONTACT_ID SRes::Contact (NUMBER(12,0) )FK to Contact. The id of the person to contact regarding this reference. Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Protocols
     RAD::Protocol
Experimental Design
     Study::Study
Bibliographic
     SRes::Abstract
     SRes::BibRefAuthor
     SRes::SequenceReference

Subclasses: