Table slot9.WORLD.TSTA.DS_ICR_PROPERTY_DRUGS_GTT
DS_ICR_PROPERTY_DRUGS_GTT

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
HEADERID number 0
DS_ICR_HEADERS.HEADERID Implied Constraint R
UNIQUE_KEY varchar2 255
REC_NUM varchar2 255
PLOSSTYPE varchar2 2000  √  null
PDRUGTYPE varchar2 2000  √  null
PDRUGQTY varchar2 2000  √  null
PDRUGMSR varchar2 2000  √  null
PDESCR varchar2 2000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRPDGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRPDGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRPDGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRPDGTT_UNIQUE_KEY_NN


Close relationships: