GUS Schema >> SRes::Contact

Holds contact information (e.g. name, email address, phone number).

column nulls? type description
CONTACT_ID no NUMBER(12,0) Primary key. Edit
AFFILIATION_ID SRes::Contact (NUMBER(12,0) )Pointer to SRes.Conact for the entry containing contact information for the affiliation of the contact. Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) )Foreign key to SRES.ExternalDatabaseRelease. Edit
SOURCE_ID STRING(255) the unique identifier of the entry in the external database Edit
NAME STRING(255) Complete name (first, middle initial and last name) of the Contact or the name of the Affiliation. Edit
FIRST STRING(255) First name of the Contact. If Affiliation, leave null. Edit
LAST STRING(255) Last name of the Contact. If Affiliation, leave null. Edit
CITY STRING(255) City used in the mailing address for the Contact or Affiliation. Edit
STATE STRING(255) State used in the mailing address for the Contact or Affiliation. Edit
COUNTRY STRING(255) Country used in the mailing address for the Contact or Affiliation. Edit
ZIP STRING(255) Zip code used in the mailing address for the Contact or Affiliation. Edit
ADDRESS1 STRING(255) Street address of the Contact or Affiliation. Edit
ADDRESS2 STRING(255) Additional street address information of the Contact or Affiliation. Edit
EMAIL STRING(255) Email address of the Contact or Affiliation. Edit
PHONE STRING(255) Phone number of the Contact or Affiliation. Edit
FAX STRING(255) Fax number of the Contact or Affiliation. 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:

NA Sequence
     DoTS::NASequence
Clones
     DoTS::CloneSet
     DoTS::EST
Data Transformations and Analyses
     RAD::Analysis
Platform
     RAD::ArrayDesign
Assay
     RAD::Assay
     RAD::Quantification
Experimental Design
     Study::Study
Bibliographic
     DoTS::Attribution
     SRes::BibliographicReference
     SRes::Contact
Enzymes Vocabulary
     DoTS::AASequenceEnzymeClass
Administration
     Core::UserInfo
Uncategorized
     Study::BioMaterial

Subclasses: