| PANEL_ASSAY |
| EntityType | Independent |
| Logical Entity Name | PANEL_ASSAY |
| Default Table Name | PANEL_ASSAY |
| Logical Only | NO |
| Owner | BARD_CAP_PROD |
| Definition | |
| Note |
| PANEL_ASSAY Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
PANEL_ASSAY_ID |
NUMERIC(19, 0) | NO | ||
Assay_ID |
Identifier | BIGINT | NO | |
PANEL_ID |
NUMERIC(19, 0) | NO | ||
| VERSION | NUMERIC(38, 0) | NO | ||
| DATE_CREATED | DATETIME | NO | ||
| LAST_UPDATED | DATETIME | NO | ||
| MODIFIED_BY | VARCHAR(40) | YES |
| PANEL_ASSAY Keys |
| Key Name | Key Type | Keys |
| PK_PANEL_ASSAY | PrimaryKey | PANEL_ASSAY_ID |
| FK_PANEL_ASSAY_ASSAY | Inversion Entry | Assay_ID |
| FK_PANEL_ASSAY_PANEL | Inversion Entry | PANEL_ID |
| UK_PANEL_ASSAY | Alternate Key | Assay_ID, PANEL_ID |
| PANEL_ASSAY Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Assay | Non-Identifying | One To Zero or More | Assay_ID | NO | |||
| PANEL | Non-Identifying | One To Zero or More | PANEL_ID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| PANEL_ASSAY Check Constraints |
| Check Constraint Name | CheckConstraint |
| PANEL_ASSAY Security Types |
| Name | Current Value |
| PANEL_ASSAY Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical BARD_CAP_PROD.PANEL_ASSAY |
NO | |||
| BARD - MySQL (MySQL) Does Not Exist |
NO | |||
| BARD_Dev (Oracle) BARD_CAP_PROD.PANEL_ASSAY |
NO | |||
| Current Production (Oracle) Does Not Exist |
NO |
| PANEL_ASSAY Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Panels |
| Logical | RI hierarchy |
| BARD_Dev (Oracle) | Main Model |
| BARD_Dev (Oracle) | Panels |
| BARD_Dev (Oracle) | RI hierarchy |