| Business Data Model Data Model |
| Description | An alternative form of a gene that results in different gene products and thus different phenotypes. There can be many alternative forms for a gene. Alternative forms of a genetic locus; a single allele for each locus is inherited separately from each parent. For example: At a locus for eye color the allele might result in blue or brown eyes |
| Attributes | |
Allele Cnt |
|
Allele Descr |
|
Allele Frequency Rt |
|
Allele Name |
|
| Relationship | |
Allele_Sequence Variation_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Allele Cnt
| Description | A particular microsatellite value (or count) identified at a sequence variation position. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allele Descr
| Description | A description of the allele. |
| 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 |
Allele Frequency Rt
| Description | The frequency that the allele has been found in individual or general populations. An allele frequency is calculated by dividing the number of times the allele of interest is observed in an individual or population by the total number of copies of all the alleles at that particular genetic locus in the individual or population. Allele frequencies can be represented as a decimal, a percentage, or a fraction. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allele Name
| Description | A particular SNP value identified at a sequence variation position. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Allele_Sequence Variation_FK
| Is Identifying Relationship | false |
| Child Table | Allele |
| 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 | Sequence Variation |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |