EQUIP |
Logical Entity Name | Equip |
Default Table Name | EQUIP |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Equipment: The list of equipment currently at the SNS site. Equipment includes items than may or may not be used in Devices (i.e. beam line). |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EQUIP(      EQUIP_ID                VARCHAR2(30)       NOT NULL,      MNFCTR_ID               NUMBER(4, 0)       NOT NULL,      MDL_NBR                 VARCHAR2(75)       NOT NULL,      EQUIP_NM                VARCHAR2(120),      EQUIP_CAT_ID            VARCHAR2(10)       NOT NULL,      EQUIP_SUBCAT_ID         VARCHAR2(10)       NOT NULL,      EQUIP_SUB_SUBCAT_ID     VARCHAR2(10)       NOT NULL,      PARENT_EQUIPMENT_ID     VARCHAR2(30),      ORNL_PROP_NBR           VARCHAR2(7),      DRW_NBR                 VARCHAR2(50),      SER_NBR                 VARCHAR2(50)       NOT NULL,      MNFCTR_DTE              DATE               DEFAULT sysdate,      CALIB_RQD_IND           CHAR(1)            DEFAULT 'N' NOT NULL,      CALIB_FREQ_ID           CHAR(2),      CALIB_METHOD_ID         CHAR(5),      LAST_CALIB_DTE          DATE               DEFAULT sysdate NOT NULL,      QUAL_GRADE_LVL          CHAR(1),      NOTE                    VARCHAR2(4000),      LEAD_ENG_BN             VARCHAR2(10),      MOD_DTE                 DATE               NOT NULL,      MOD_BY_UID              VARCHAR2(64)       NOT NULL,      CONSTRAINT EQUIP_PK PRIMARY KEY (EQUIP_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE EQUIP_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ),      CONSTRAINT PARENT_EQUIP_RF FOREIGN KEY (PARENT_EQUIPMENT_ID)      REFERENCES EQUIP(EQUIP_ID),      CONSTRAINT MNFCTR_MDL_RF FOREIGN KEY (MNFCTR_ID, MDL_NBR)      REFERENCES MNFCTR_MDL(MNFCTR_ID, MDL_NBR),      CONSTRAINT EQUIP_TYPE_RF FOREIGN KEY (EQUIP_CAT_ID)      REFERENCES EQUIP_CAT(EQUIP_CAT_ID),      CONSTRAINT EQUIP_LEAD_ENG_RF FOREIGN KEY (LEAD_ENG_BN)      REFERENCES LEAD_ENG(LEAD_ENG_BN),      CONSTRAINT EQUIP_CALIB_METHOD_RF FOREIGN KEY (CALIB_METHOD_ID)      REFERENCES CALIB_METHOD(CALIB_METHOD_ID),      CONSTRAINT EQUIP_CALIB_FREQ_RF FOREIGN KEY (CALIB_FREQ_ID)      REFERENCES CALIB_FREQ(CALIB_FREQ_ID),      CONSTRAINT EQUIP_EQUIP_SUBCAT_RF FOREIGN KEY (EQUIP_CAT_ID, EQUIP_SUBCAT_ID)      REFERENCES EQUIP_SUBCAT(EQUIP_CAT_ID, EQUIP_SUBCAT_ID),      CONSTRAINT EQUIP_EQUIP_SUB_SUBCAT_RF FOREIGN KEY (EQUIP_CAT_ID, EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID)      REFERENCES EQUIP_SUB_SUBCAT(EQUIP_CAT_ID, EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EQUIP_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 64K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; |
PostSQL |
EQUIP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EQUIP_ID | Asset Identifier | VARCHAR2(30) | NO | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
MNFCTR_ID | NUMBER(4, 0) | NO | Manufacturer Identifier: The unique identifier for the manufacturer. |
|
MDL_NBR | VARCHAR2(75) | NO | Model Number: The unique identifier for the manufacturer's model number. |
|
EQUIP_NM | Name | VARCHAR2(120) | YES | Equipment Name: The name associated with the piece of equipment. If a manufacturer model name is available this field will automatically be populated with the model name. The user may select a "standard" equipment name from the "equipment name" table. |
EQUIP_CAT_ID | Operation Group | VARCHAR2(10) | NO | Equipment Category Identifier: The unique identifier for a specific equipment category. |
EQUIP_SUBCAT_ID | VARCHAR2(10) | NO | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
|
EQUIP_SUB_SUBCAT_ID | VARCHAR2(10) | NO | Equipment Sub Subcategory Identifier: The unique identifer for an equipment sub subcategory. |
|
PARENT_EQUIPMENT_ID | Asset Identifier | VARCHAR2(30) | YES | Parent Equipment Identifier: If the current piece of equipment is a component of another piece of equipment, this field will contain the parent equipment identifier. |
ORNL_PROP_NBR | VARCHAR2(7) | YES | Oak Ridge National Laboratory Property Number: A unique number assigned by ORNL to the equipment for tracking and inventory purposes. |
|
DRW_NBR | Default Text | VARCHAR2(50) | YES | Drawing Number: The number assigned to the drawing depicting the configuration of the equipment. |
SER_NBR | Default Text | VARCHAR2(50) | NO | Serial Number: The manufacturer serial number of the equipment. |
MNFCTR_DTE | Date | DATE | YES | Manufacture Date: The day the item was created by the manufacturer. |
CALIB_RQD_IND | Indicator | CHAR(1) | NO | Calibration Required Indicator: When set to "Y" indicated the equipment requires calibration. Default is "N" |
CALIB_FREQ_ID | CHAR(2) | YES | Calibration Frequency Identifier: The unique identifier for a calibration frequency. |
|
CALIB_METHOD_ID | CHAR(5) | YES | Calibration Frequency Identifier: Indicates the periodic interval a piece of equipment must be calibrated. |
|
LAST_CALIB_DTE | Date | DATE | NO | Last Calibration Date: The date when the equipment was last calibrated. |
QUAL_GRADE_LVL | CHAR(1) | YES | Quality Grade Level: The quality grade level as defined in the Spallation Neutron Source Quality Assurance Plan: SNS-QA-P01 |
|
NOTE | Note | VARCHAR2(4000) | YES | Notes: A free form text field used to describe a piece of equipment. |
LEAD_ENG_BN | Badge Number | VARCHAR2(10) | YES | Lead Engineer Badge Number: The ORNL badge number of the lead engineer responsible for the equipment. |
MOD_DTE | Modify Date | DATE | NO | Modify Date: The day and time the Equipment record was modified. |
MOD_BY_UID | Mod By Uid | VARCHAR2(64) | NO | Modified By Userid: The userid of the person who modified the equipment record. |
EQUIP Primary and Unique Keys |
Key Name | Key Type | Keys |
EQUIP_PK | PrimaryKey | EQUIP_ID |
EQUIP Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
CALIB_FREQ | Non-Identifying | Zero or One to Zero or More | EQUIP_CALIB_FREQ_RF | CALIB_FREQ_ID | NO | NO | NO | ||
CALIB_METHOD | Non-Identifying | Zero or One to Zero or More | EQUIP_CALIB_METHOD_RF | CALIB_METHOD_ID | NO | NO | NO | ||
EQUIP_SUB_SUBCAT | Non-Identifying | One To Zero or More | EQUIP_EQUIP_SUB_SUBCAT_RF | EQUIP_CAT_ID, EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID | NO | NO | NO | ||
EQUIP_SUBCAT | Non-Identifying | One To Zero or More | EQUIP_EQUIP_SUBCAT_RF | EQUIP_CAT_ID, EQUIP_SUBCAT_ID | NO | NO | NO | ||
LEAD_ENG | Non-Identifying | Zero or One to Zero or More | EQUIP_LEAD_ENG_RF | LEAD_ENG_BN | NO | NO | NO | ||
EQUIP_CAT | Non-Identifying | One To Zero or More | EQUIP_TYPE_RF | describes | is assigned to | EQUIP_CAT_ID | NO | NO | NO |
MNFCTR_MDL | Non-Identifying | One To Zero or More | MNFCTR_MDL_RF | MNFCTR_ID, MDL_NBR | NO | NO | NO | ||
EQUIP | Non-Identifying | Zero or One to Zero or More | PARENT_EQUIP_RF | PARENT_EQUIPMENT_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EQUIP_USAGE | Identifying | One To Zero or More | NO | NO | NO | ||||
USER_INSTR | Identifying | One to Zero or One | NO | NO | NO | ||||
RF_CAV | Identifying | One To Zero or More | NO | NO | YES | ||||
PWR_SPLY | Identifying | One To Zero or More | NO | NO | YES | ||||
DIAG_EQUIP_HIST | Identifying | One To Zero or More | NO | NO | YES | ||||
EQUIP_DVC_ASGN | Identifying | One To Zero or More | EQUIP_DVC_ASGN2_RF | is involved in | uses | NO | NO | NO | |
EQUIP_LOC | Identifying | One To Zero or More | EQUIP_LOC_RF | resides at | stores | NO | NO | NO | |
EQUIP_STAT | Identifying | One To Zero or More | EQUIP_STAT_RF | NO | NO | NO | |||
EQUIP | Non-Identifying | One To Zero or More | PARENT_EQUIP_RF | NO | NO | NO |
EQUIP Check Constraints |
Check Constraint Name | CheckConstraint |
EQUIP Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_TS |
PctFree | 10 |
PCTUSED | 40 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
EQUIP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EQUIP Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
EQUIP Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
EQUIP Security Types |
Name | Current Value |
EQUIP Bound Attachments |
Name | Current Value |
EQUIP Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EQUIP.Equipment |
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) EQUIP |
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) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) EQUIP |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
EQUIP Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Equipment |
Logical | Equipment - Equip Rcpt |
Logical | Power Supply |
Logical | XAL Optics |
EQUIP (Oracle) | Main Model |
XAL_OPTICS (Oracle) | Main Model |
EQUIP Data Movement Rules |
Name | Type | Rule Text/Value |