| Business Data Model Data Model |
| Description | A location in the human genome where variations have been identified. A polymorphism such as an SNP, repetitive microsatellite, or other genomic variation. |
| Relationship | |
 Sequence Variation_Gene_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Base Quality Num
| Description | The base quality (RMS - Root Mean Square) of the sequence variation at this position. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Chromosome Num
| Description | The chromosome where the variant is located. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Chromosome Pos
| Description | The position of the variant on the chromosome. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Position [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Cigar String
| Description | Cigar string describing how to align an alternate allele to the reference allele. |
| 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 |
Dbsnp Link Txt
| Description | A link to dbSNP web URL that contains reference information on the SNP and other variations. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
dbSNP Membership Ind
| Description | Indicates the membership of the sequence variation in the database of single nucleotide polymorphisms (SNP). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Hapmap2 Membership Ind
| Description | Indicates the membership of the sequence variation in the Hapmap2 Genome Browser. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Hapmap3 Membership Ind
| Description | Indicates the membership of the sequence variation in the Hapmap3 Genome Browser. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
IUPAC Name
| Description | The International Union of Pure and Applied Chemistry (IUPAC) code for the Single Nucleotide Polymorphism (SNP). |
| 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 |
Membership 1000 Genomes Ind
| Description | Indicates the membership in 1000 Genomes Project. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Original Sequence Txt
| Description | Original DNA sequence of a gene. |
| 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 |
Sequence Type
| Description | Indicates whether sequence variation is one of the following: 1 - Single Nucleotide Polymorphism (SNP) 2 - Microsatellite (STR) 3 - Other Variation |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Somatic Mutation Ind
| Description | Indicates that the record is a somatic mutation, for cancer genomics. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Strand Bias
| Description | Strand bias at this 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 |
Validated Ind
| Description | Indicates that the record has been validated by follow-up experiment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Variation End Pos
| Description | The ending position of the variant. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Position [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Variation Region
| Description | Defines the variant to be in a coding region [Exon] or noncoding region [Intron] of the genome. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Variation Sequence Txt
| Description | Change in the DNA sequence of a gene due to sequence variations/polymorphisms. |
| 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 |
Variation Start Pos
| Description | The starting position of the variant. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Position [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Sequence Variation_Gene_FK
| Is Identifying Relationship | false |
| Child Table | Sequence Variation |
| 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 | Gene |
| 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 |