GeneX Development Supported By
|
GeneX-2.0 DB: Contact Table
|
GeneX-2.0 DB: Contact Table
|
| Table Type | Inherits | Comment |
| DATA | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| audit_fk | Audit | int | true | The 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_pk | Accession Number | serial | false | |
| contact_person | Contact Person | char128 | false | will be non-null for data providers |
| contact_person_email | Contact Person Email | char128 | false | will be non-null for data providers |
| contact_person_phone | Contact Person Phone | char128 | false | will be non-null for data providers |
| org_email | Organization Email | char128 | false | will be non-null for technology providers |
| org_fax | Organization Fax | char128 | false | |
| org_mail_address | Organization Mail Address | text | false | |
| org_phone | Organization Phone | char128 | false | will be non-null for technology providers |
| org_toll_free_phone | Organization Toll Free Phone | char128 | false | |
| organization | Organization | char128 | false | |
| ro_groupname | Read-Only Group Name | name | true | The group with permission to view this data |
| rw_groupname | Read/Write Group Name | name | true | The group with permission to modify this data |
| url | URL | char128 | false | |
| Primary Key Information |
| Column Name |
| con_pk |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| audit_fk | Audit | audit_pk | ONE_TO_ONE |
| ro_groupname | GroupSec | name | ONE_TO_ONE |
| rw_groupname | GroupSec | name | ONE_TO_ONE |
| Unique Column Information |
| Column Names |
| organization contact_person |
| Index Information |
| Name | Column Name |
|