| Assay |
| EntityType | Independent |
| Logical Entity Name | Assay |
| Default Table Name | Assay |
| Logical Only | NO |
| Owner | |
| Definition | |
| Note |
| Assay Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| Assay_ID |
Identifier | BIGINT | NO | |
| Assay_Status | VARCHAR(20) | NO | ||
| Assay_Short_Name | VARCHAR(250) | NO | ||
| Assay_Name | VARCHAR(1000) | NO | ||
| Assay_Version | VARCHAR(10) | NO | ||
| Assay_Type | VARCHAR(20) | NO | ||
| DESIGNED_BY | VARCHAR(100) | YES | ||
| ready_for_extraction | dirty flag | VARCHAR(20) | NO | |
| Version | Version | INTEGER | NO | |
| Date_Created | Date_Created | TIMESTAMP/DATE | NO | |
| Last_Updated | Last_Updated | DATETIME | NO | |
| Modified_by | Modified_by | VARCHAR(40) | YES | |
| NCGC_WAREHOUSE_ID | NUMERIC(19, 0) | YES | ||
| OWNER_ROLE_ID |
NUMERIC(19, 0) | YES |
| Assay Keys |
| Key Name | Key Type | Keys |
| PK_Assay | PrimaryKey | Assay_ID |
| IDX_ASSAY_NAME_VERSION | Inversion Entry | Assay_Name, Assay_Version |
| FK_ASSAY_OWNER_ROLE_ID | Inversion Entry | OWNER_ROLE_ID |
| Assay Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Role | Non-Identifying | Zero or One to Zero or More | OWNER_ROLE_ID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| Assay_Context | Non-Identifying | One To Zero or More | NO | ||||
| Assay_document | Non-Identifying | One To Zero or More | NO | ||||
| Experiment | Non-Identifying | One To Zero or More | NO | ||||
| Measure | Non-Identifying | One To Zero or More | NO | ||||
| PANEL_ASSAY | Non-Identifying | One To Zero or More | NO |
| Assay Check Constraints |
| Check Constraint Name | CheckConstraint |
| Assay Security Types |
| Name | Current Value |
| Assay Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Assay |
NO | |||
| BARD - MySQL (MySQL) Assay |
NO | |||
| BARD_Dev (Oracle) ASSAY |
NO | |||
| Current Production (Oracle) Does Not Exist |
NO |
| Assay Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Assay Definition |
| Logical | Experiment Specification |
| Logical | Panels |
| Logical | Project Information |
| Logical | RI hierarchy |
| Logical | Security |
| BARD - MySQL (MySQL) | Main Model |
| BARD - MySQL (MySQL) | CAP |
| BARD - MySQL (MySQL) | Data Entry |
| BARD - MySQL (MySQL) | Project Management |
| BARD_Dev (Oracle) | Main Model |
| BARD_Dev (Oracle) | Assay Definition |
| BARD_Dev (Oracle) | Experiment Specification |
| BARD_Dev (Oracle) | Panels |
| BARD_Dev (Oracle) | Project Information |
| BARD_Dev (Oracle) | RI hierarchy |
| BARD_Dev (Oracle) | Security |