Assay NameAssay Performed DateAssay Type
| Business Data Model Data Model |
| Description | A qualitative or quantitative analysis of a substance/sample to determine the components. A substance/DNA to be so analyzed using an experimental technique. Genotyping assay techniques also differ substantially. They differ in their technical complexity and in the type of raw data generated. Assay techniques range from single PCR amplification assays to various high throughput approaches. The type of raw data generated also varies, for example, from Sanger sequencing technique which generates one chromatogram read per sample, to next generation sequencing methods which generate large numbers of short reads, provided as fluorescent image files. |
| Attributes | |
| Assay Name |
|
| Assay Performed Date |
|
| Assay Type |
|
| Relationship | |
 Assay_Genotype_Experiment_FK |
|
| Assay_DNA Sample_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Assay Name
| Description | A word or a phrase used to identify the assay experiment. |
| 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 |
Assay Performed Date
| Description | The date upon which the assay was performed. |
| 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 |
Assay Type
| Description | Defines the type of assay and general method of analysis. |
| 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 |
| Relationship Details |
Assay_Genotype_Experiment_FK
| Is Identifying Relationship | false |
| Child Table | Assay |
| 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 Experiment |
| Parent Role Name | R/2 |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Assay_DNA Sample_FK
| Is Identifying Relationship | true |
| Child Table | Assay |
| 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 |