GeneX-2.0 DB: Contact Table
GeneX-2.0 DB: Contact Table
Table TypeInheritsComment
DATAnone The Contact table provides information that can be used to contact either data providers or suppliers of particular technologies, e.g. arrays, hardware and software. The meanings of the fields are generally self-evident.

Column Information
Column NameFull NameData TypeNot NULLComment
audit_fkAuditinttrueThe audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger.
con_pkAccession Numberserialfalse
contact_personContact Personchar128false will be non-null for data providers
contact_person_emailContact Person Emailchar128false will be non-null for data providers
contact_person_phoneContact Person Phonechar128false will be non-null for data providers
org_emailOrganization Emailchar128false will be non-null for technology providers
org_faxOrganization Faxchar128false
org_mail_addressOrganization Mail Addresstextfalse
org_phoneOrganization Phonechar128false will be non-null for technology providers
org_toll_free_phoneOrganization Toll Free Phonechar128false
organizationOrganizationchar128false
ro_groupnameRead-Only Group NamenametrueThe group with permission to view this data
rw_groupnameRead/Write Group NamenametrueThe group with permission to modify this data
urlURLchar128false

Primary Key Information
Column Name
con_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
audit_fkAuditaudit_pkONE_TO_ONE
ro_groupnameGroupSecnameONE_TO_ONE
rw_groupnameGroupSecnameONE_TO_ONE

Unique Column Information
Column Names
organization contact_person

Index Information
NameColumn Name