Chromosome NameContiguation TxtFunction TxtGene NameGene Symbol TxtLocation TxtRelated Gene TxtSimilar Gene Txt
| Business Data Model Data Model |
| Description | Contains reference information related to genes. This information may be used in the evaluation of sequence variations which may impact the genes functionality. This information may be derived from various sources such as dbSNP. Genes are segments of DNA located on chromosomes. |
| Attributes | |
| Chromosome Name |
|
| Contiguation Txt |
|
| Function Txt |
|
| Gene Name |
|
| Gene Symbol Txt |
|
| Location Txt |
|
| Related Gene Txt |
|
| Similar Gene Txt |
|
| Relationship | |
 Gene_DNA Sample_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Chromosome Name
| Description | A word or a phrase used to identify the chromosome where the gene is located. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Contiguation Txt
| Description | A contig--from the word "contiguous"--is a series of overlapping DNA sequences used to make a physical map that reconstructs the original DNA sequence of a chromosome or a region of a chromosome. A contig can also refer to one of the DNA sequences used in making such a map. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Function Txt
| Description | The known function associated with the gene. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Gene Name
| Description | A word or phrase used to identify a gene. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Gene Symbol Txt
| Description | The symbol for the gene. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Location Txt
| Description | The location of the gene on the chromosome. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Related Gene Txt
| Description | Genes that are related. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Similar Gene Txt
| Description | Genes that are similar. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Gene_DNA Sample_FK
| Is Identifying Relationship | false |
| Child Table | Gene |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | DNA Sample |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |