PANEL_ASSAY 
Logical Entity Name  PANEL_ASSAY 
Default Table Name  PANEL_ASSAY 
Physical Only  NO 
Do Not Generate  False 
Owner  BARD_CAP_PROD 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE PANEL_ASSAY(
     PANEL_ASSAY_ID     NUMBER(19, 0)     NOT NULL,
     ASSAY_ID           NUMBER(19, 0)     NOT NULL,
     PANEL_ID           NUMBER(19, 0)     NOT NULL,
     VERSION            NUMBER(38, 0)     DEFAULT 0 NOT NULL,
     DATE_CREATED       TIMESTAMP(6)      DEFAULT sysdate NOT NULL,
     LAST_UPDATED       TIMESTAMP(6)      DEFAULT sysdate NOT NULL,
     MODIFIED_BY        VARCHAR2(40),
     CONSTRAINT PK_PANEL_ASSAY PRIMARY KEY (PANEL_ASSAY_ID),
     CONSTRAINT UK_PANEL_ASSAY   UNIQUE (ASSAY_ID, PANEL_ID),
     CONSTRAINT FK_PANEL_ASSAY_PANEL FOREIGN KEY (PANEL_ID)
     REFERENCES PANEL(PANEL_ID) ON DELETE CASCADE,
     CONSTRAINT FK_PANEL_ASSAY_ASSAY FOREIGN KEY (ASSAY_ID)
     REFERENCES ASSAY(ASSAY_ID) ON DELETE CASCADE
)
;



CREATE INDEX FK_PANEL_ASSAY_ASSAY ON PANEL_ASSAY(ASSAY_ID)
;
CREATE INDEX FK_PANEL_ASSAY_PANEL ON PANEL_ASSAY(PANEL_ID)
;
 
PostSQL   

PANEL_ASSAY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PANEL_ASSAY_ID(PK)    NUMBER(19, 0)  NO 
 
ASSAY_ID(FK)  Identifier  NUMBER(19, 0)  NO 
 
PANEL_ID(FK)    NUMBER(19, 0)  NO 
 
VERSION    NUMBER(38, 0)  NO 
 
DATE_CREATED    TIMESTAMP(6)  NO 
 
LAST_UPDATED    TIMESTAMP(6)  NO 
 
MODIFIED_BY    VARCHAR2(40)  YES 
 

PANEL_ASSAY Primary and Unique Keys 
Key Name  Key Type  Keys 
UK_PANEL_ASSAY  Index  ASSAY_ID, PANEL_ID 
PK_PANEL_ASSAY  PrimaryKey  PANEL_ASSAY_ID 

PANEL_ASSAY Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
ASSAY  Non-Identifying  One To Zero or More  FK_PANEL_ASSAY_ASSAY      ASSAY_ID  NO  NO  NO 
PANEL  Non-Identifying  One To Zero or More  FK_PANEL_ASSAY_PANEL      PANEL_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

PANEL_ASSAY Check Constraints 
Check Constraint Name  CheckConstraint 

PANEL_ASSAY Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  BARD_CAP_PROD 
PctFree  10 
PCTUSED   0 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  1024 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool  DEFAULT 
Table Compression  NO 
Row Movement  Disabled 

PANEL_ASSAY Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

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