Chromosome Hits CntChromosome NumContiguous Hits CntGenotype IndMap Weight CntSNP Publication DateSNP Type NumSNP Variation ClassValidation Status Txt
| Business Data Model Data Model |
| Description | A remote entity at the National Center for Biotechnology Information (NCBI) that contains information on Single Nucleotide Polymorphisms (SNP). Database of single nucleotide polymorphisms (SNPs) and multiple small-scale variations that include insertions/deletions, microsatellites, and non-polymorphic variants and haplotypes. |
| Attributes | |
| Chromosome Hits Cnt |
|
| Chromosome Num |
|
| Contiguous Hits Cnt |
|
| Genotype Ind |
|
| Map Weight Cnt |
|
| SNP Publication Date |
|
| SNP Type Num |
|
| SNP Variation Class |
|
| Validation Status Txt |
|
| Relationship | |
 NCBI Entrez SNP_Sequence Variation_FK |
|
| NCBI Entrez dbSNP_Haplotype_FK |
|
| NCBI Entrez dbSNP_Allele_FK |
|
| NCBI Entrez dbSNP_Genotype_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Chromosome Hits Cnt
| Description | Number of hits associated to the SNP aligning to multiple chromosomes. |
| 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 |
Chromosome Num
| Description | The mapped chromosome number. |
| 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 |
Contiguous Hits Cnt
| Description | Number of hits that the SNP aligns with different contigs. |
| 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 |
Genotype Ind
| Description | Indicates where the SNP was submitted as an observed genotype. |
| 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 |
Map Weight Cnt
| Description | The number of times an SNP can map to the genome contig (range 1-10). For example: 1 = snp aligns at exactly one locus 2 = snp aligns at two locus on same chromosome 3 = snp aligns at less than 10 locus 10= snp aligns at more than 10 locations |
| 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 |
SNP Publication Date
| Description | The date upon which the Single Nucleotide Polymorphism (SNP) is published. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
SNP Type Num
| Description | The type of SNP i.e. Type, i.e. 1, 2 or 3 |
| 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 |
SNP Variation Class
| Description | Single Nucleotide Polymorphism Variation Class. Classification of SNP. For example: Heterozygous Insertion deletion Microsatellite |
| 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 |
Validation Status Txt
| Description | Status of the validation of this SNP. For example: By cluster By frequency By submitter |
| 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 |
NCBI Entrez SNP_Sequence Variation_FK
| Is Identifying Relationship | false |
| Child Table | NCBI Entrez dbSNP |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
NCBI Entrez dbSNP_Haplotype_FK
| Is Identifying Relationship | false |
| Child Table | NCBI Entrez dbSNP |
| 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 | Haplotype |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
NCBI Entrez dbSNP_Allele_FK
| Is Identifying Relationship | false |
| Child Table | NCBI Entrez dbSNP |
| 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 | Allele |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
NCBI Entrez dbSNP_Genotype_FK
| Is Identifying Relationship | false |
| Child Table | NCBI Entrez dbSNP |
| 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 | Genotype |
| 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 |