HMMIS_CHEM |
Logical Entity Name | HMMIS Chemical |
Default Table Name | HMMIS_CHEM |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | SMPL |
Definition | Contains a list of all of the chemicals in the HMMS system |
Note | |
PreSQL | |
DDL Code | CREATE TABLE SMPL.HMMIS_CHEM(      CHEM_RECID                   VARCHAR2(6)       NOT NULL,      primaryName                  VARCHAR2(80)      NOT NULL,      casNumber                    VARCHAR2(50),      pure                         NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      carcinogen                   NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      specialCondition             NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      shelfLife                    NUMBER(38, 0),      shelfLifeComments            VARCHAR2(255),      trackInventory               NUMBER(1, 0)      DEFAULT ((1)) NOT NULL,      sortableName                 VARCHAR2(80),      rtecsNumber                  VARCHAR2(50),      rowguid                      RAW(16)           DEFAULT (newid()) NOT NULL,      hideFromQueries              NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      flammability                 VARCHAR2(2),      epaGroup                     CHAR(1),      classificationsCompleted     NUMBER(1, 0)      NOT NULL,      mistFormOnly                 NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      status                       CHAR(1),      CONSTRAINT PK_CHEMICAL PRIMARY KEY (CHEM_RECID)      USING INDEX          LOGGING ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
HMMIS_CHEM Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CHEM_RECID | VARCHAR2(6) | NO | The record ID for the chemical - uniquely identifies the entry |
|
primaryName | VARCHAR2(80) | NO | Primary or official name of the chemical |
|
casNumber | VARCHAR2(50) | YES | CAS number |
|
pure | NUMBER(1, 0) | NO | ***Indicates that the chemical is pure (not a mixture) |
|
carcinogen | NUMBER(1, 0) | NO | Indicates that the chemical is a carcinogen |
|
specialCondition | NUMBER(1, 0) | NO | Indicates that the chemical represents a special condition as defined by ORNL |
|
shelfLife | NUMBER(38, 0) | YES | Lists the default shelf life of the chemical (if any) |
|
shelfLifeComments | VARCHAR2(255) | YES | Comments about the shelf life. Often used to explain the value provided in the shelfLife field (i.e. units) |
|
trackInventory | NUMBER(1, 0) | NO | Indicates that inventory is to be tracked for this chemical |
|
sortableName | VARCHAR2(80) | YES | A sortable/comparable name for the chemical. Similar to primaryName however without spaces or any special characters |
|
rtecsNumber | VARCHAR2(50) | YES | RTECS number |
|
rowguid | RAW(16) | NO | ||
hideFromQueries | NUMBER(1, 0) | NO | ||
flammability | VARCHAR2(2) | YES | ||
epaGroup | CHAR(1) | YES | ||
classificationsCompleted | NUMBER(1, 0) | NO | ||
mistFormOnly | NUMBER(1, 0) | NO | ||
status | CHAR(1) | YES |
HMMIS_CHEM Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_CHEMICAL | PrimaryKey | CHEM_RECID |
HMMIS_CHEM Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
SMPL_CLASS | Non-Identifying | Zero or One to Zero or More | fk_smpl_class_to_hmmis_chem | NO | NO | NO |
HMMIS_CHEM Check Constraints |
Check Constraint Name | CheckConstraint |
HMMIS_CHEM Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
HMMIS_CHEM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
HMMIS_CHEM Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
HMMIS_CHEM Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
HMMIS_CHEM Security Types |
Name | Current Value |
HMMIS_CHEM Bound Attachments |
Name | Current Value |
HMMIS_CHEM Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical SMPL.HMMIS Chemical |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) SMPL.HMMIS_CHEM |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
HMMIS_CHEM Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Sample |
SMPL (Oracle) | Main Model |
HMMIS_CHEM Data Movement Rules |
Name | Type | Rule Text/Value |