HMMIS_MSDS |
Logical Entity Name | HMMIS Material Safety Data Sheet |
Default Table Name | HMMIS_MSDS |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | SMPL |
Definition | Contains the collection of all of the Material Safety Data Sheets (MSDS) that are stored in the system. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE SMPL.HMMIS_MSDS(      MSDS_RECID                    VARCHAR2(6)       NOT NULL,      msdsID                        NUMBER(38, 0)     NOT NULL,      manufacturerNumber            VARCHAR2(6),      productName                   VARCHAR2(256),      productNumber                 VARCHAR2(500),      preparationDate               TIMESTAMP(6),      technicalDataModification     NUMBER(1, 0)      DEFAULT ((0)) NOT NULL,      fileShare                     NUMBER(18, 0),      rowguid                       RAW(16)           DEFAULT (newid()) NOT NULL,      dateReceived                  TIMESTAMP(6),      changedBy                     VARCHAR2(10),      plantCode                     CHAR(1),      currentAsOfDate               TIMESTAMP(6),      CONSTRAINT PK_HMMIS_MSDS PRIMARY KEY (MSDS_RECID)      USING INDEX          LOGGING ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
HMMIS_MSDS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MSDS_RECID | VARCHAR2(6) | NO | The chemical with which this MSDS is associated |
|
msdsID | NUMBER(38, 0) | NO | Unique identifier for the MSDS |
|
manufacturerNumber | VARCHAR2(6) | YES | The manufacturer that provided this MSDS |
|
productName | VARCHAR2(256) | YES | The product name, if any, directly associated with this MSDS |
|
productNumber | VARCHAR2(500) | YES | The product number directly associated with this MSDS |
|
preparationDate | TIMESTAMP(6) | YES | The date that the MSDS was prepared |
|
technicalDataModification | NUMBER(1, 0) | NO | ***Indicates if modifications were made to the technical data (chemical classification |
|
fileShare | NUMBER(18, 0) | YES | The file share where this MSDS is stored |
|
rowguid | RAW(16) | NO | ||
dateReceived | TIMESTAMP(6) | YES | ||
changedBy | VARCHAR2(10) | YES | ||
plantCode | CHAR(1) | YES | ||
currentAsOfDate | TIMESTAMP(6) | YES |
HMMIS_MSDS Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_HMMIS_MSDS | PrimaryKey | MSDS_RECID |
HMMIS_MSDS 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 |
HMMIS_MSDS Check Constraints |
Check Constraint Name | CheckConstraint |
HMMIS_MSDS 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_MSDS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
HMMIS_MSDS 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_MSDS Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
HMMIS_MSDS Security Types |
Name | Current Value |
HMMIS_MSDS Bound Attachments |
Name | Current Value |
HMMIS_MSDS Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical SMPL.HMMIS Material Safety Data Sheet |
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_MSDS |
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_MSDS Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Sample |
SMPL (Oracle) | Main Model |
HMMIS_MSDS Data Movement Rules |
Name | Type | Rule Text/Value |