BLM_DVC |
Logical Entity Name | Beam Loss Monitor Device |
Default Table Name | BLM_DVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Beam Loss Monitor Device: |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EPICS.BLM_DVC(      DVC_ID                   VARCHAR2(50)      NOT NULL,      SSA_DVC_ID               VARCHAR2(50)      NOT NULL,      SSA_CHANNEL_NBR          NUMBER(2, 0),      HVPS_DVC_ID              VARCHAR2(50)      NOT NULL,      HVPS_CHANNEL_NBR         NUMBER(2, 0),      MPS_INTFC_DVC            VARCHAR2(50)      NOT NULL,      ADC_SLOW_DVC_ID          VARCHAR2(50)      NOT NULL,      ADC_SLOW_CHANNEL_NBR     NUMBER(2, 0),      ADC_FAST_DVC_ID          VARCHAR2(50)      NOT NULL,      ADC_FAST_CHANNEL_NBR     NUMBER(2, 0),      TEST_CHAIN_NBR           NUMBER(2, 0),      IOC_NBR                  NUMBER(38, 0),      NOM_LOSS                 VARCHAR2(50),      HVLO                     VARCHAR2(50),      HVHI                     VARCHAR2(50),      HVLOLO                   VARCHAR2(50),      HVLOW                    VARCHAR2(50),      HVHIGH                   VARCHAR2(50),      HVHIHI                   VARCHAR2(50),      HVIHIHI                  VARCHAR2(50),      HVIHIGH                  VARCHAR2(50),      HVILOW                   VARCHAR2(50),      HVILOLO                  VARCHAR2(50),      HGAIN                    VARCHAR2(50),      LGAIN                    VARCHAR2(50),      HHLOSS                   VARCHAR2(50),      LLLOSS                   VARCHAR2(50),      HLOSS                    VARCHAR2(50),      LLOSS                    VARCHAR2(50),      MPSHIHI                  VARCHAR2(50),      MPSLOLO                  VARCHAR2(50),      MPS600HI                 VARCHAR2(50),      MPS600LO                 VARCHAR2(50),      NTRIPHI                  VARCHAR2(50),      NTRIPLO                  VARCHAR2(50),      TTRIPHI                  VARCHAR2(50),      TTRIPLO                  VARCHAR2(50),      UTRIPHI                  VARCHAR2(50),      UTRIPLO                  VARCHAR2(50),      ASG                      VARCHAR2(50),      CONSTRAINT PK_BLM_DVC PRIMARY KEY (DVC_ID)      USING INDEX TABLESPACE EPICS_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ),      CONSTRAINT RefDVC910 FOREIGN KEY (DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT FK_BLM_SSA_DVC FOREIGN KEY (SSA_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT FK_BLM_HVPS_DVC FOREIGN KEY (HVPS_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT FK_BLM_MPS_INTFC_DVC FOREIGN KEY (MPS_INTFC_DVC)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT FK_BLM_ADC_DVC FOREIGN KEY (ADC_SLOW_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT RefDVC963 FOREIGN KEY (ADC_FAST_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID) ) TABLESPACE EPICS_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 64K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; |
PostSQL |
BLM_DVC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
SSA_DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
SSA_CHANNEL_NBR | NUMBER(2, 0) | YES | ||
HVPS_DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
HVPS_CHANNEL_NBR | NUMBER(2, 0) | YES | ||
MPS_INTFC_DVC | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
ADC_SLOW_DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
ADC_SLOW_CHANNEL_NBR | NUMBER(2, 0) | YES | ||
ADC_FAST_DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
ADC_FAST_CHANNEL_NBR | NUMBER(2, 0) | YES | ||
TEST_CHAIN_NBR | NUMBER(2, 0) | YES | ||
IOC_NBR | NUMBER(38, 0) | YES | IOC Number: |
|
NOM_LOSS | VARCHAR2(50) | YES | Nomiinal Loss: Allow loss in Rads. |
|
HVLO | VARCHAR2(50) | YES | HV DRVLO: |
|
HVHI | VARCHAR2(50) | YES | HV DRVH: |
|
HVLOLO | VARCHAR2(50) | YES | Low Alarm: |
|
HVLOW | VARCHAR2(50) | YES | Low Warning: |
|
HVHIGH | VARCHAR2(50) | YES | High Warning: |
|
HVHIHI | VARCHAR2(50) | YES | High Alarm: |
|
HVIHIHI | VARCHAR2(50) | YES | Bias I Alarm: |
|
HVIHIGH | VARCHAR2(50) | YES | Bias Current Warning: |
|
HVILOW | VARCHAR2(50) | YES | Bias Current Warning: |
|
HVILOLO | VARCHAR2(50) | YES | Bias I Alarm: |
|
HGAIN | VARCHAR2(50) | YES | Gain High Alarm: |
|
LGAIN | VARCHAR2(50) | YES | Gain Low Alarm: |
|
HHLOSS | VARCHAR2(50) | YES | Slow Loss Alarm: |
|
LLLOSS | VARCHAR2(50) | YES | Slow Loss Warning: |
|
HLOSS | VARCHAR2(50) | YES | High Loss Warning: |
|
LLOSS | VARCHAR2(50) | YES | Slow Loss Warning: |
|
MPSHIHI | VARCHAR2(50) | YES | MPS HIGH Trip Level Alarm: |
|
MPSLOLO | VARCHAR2(50) | YES | MPS Low Trip Level Warning: |
|
MPS600HI | VARCHAR2(50) | YES | 10 Second Ave Alarm: |
|
MPS600LO | VARCHAR2(50) | YES | 10 Second Ave Warning: |
|
NTRIPHI | VARCHAR2(50) | YES | Nominal Trip Level DRVH: |
|
NTRIPLO | VARCHAR2(50) | YES | Nominal Trip Level Low: |
|
TTRIPHI | VARCHAR2(50) | YES | Tune Trip Level High: |
|
TTRIPLO | VARCHAR2(50) | YES | Tune Trip Level Low: |
|
UTRIPHI | VARCHAR2(50) | YES | User Trip Level High: |
|
UTRIPLO | VARCHAR2(50) | YES | User Trip Level Low: |
|
ASG | VARCHAR2(50) | YES | Access Security Group: |
BLM_DVC Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_BLM_DVC | PrimaryKey | DVC_ID |
BLM_DVC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
DVC | Identifying | One to Zero or One | DVC_ID | NO | NO | NO | |||
DVC | Non-Identifying | One To Zero or More | ADC_FAST_DVC_ID | NO | NO | NO | |||
DVC | Non-Identifying | One To Zero or More | FK_BLM_ADC_DVC | ADC_SLOW_DVC_ID | NO | NO | NO | ||
DVC | Non-Identifying | One To Zero or More | FK_BLM_HVPS_DVC | HVPS_DVC_ID | NO | NO | NO | ||
DVC | Non-Identifying | One To Zero or More | FK_BLM_MPS_INTFC_DVC | MPS_INTFC_DVC | NO | NO | NO | ||
DVC | Non-Identifying | One To Zero or More | FK_BLM_SSA_DVC | SSA_DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BLM_DVC Check Constraints |
Check Constraint Name | CheckConstraint |
BLM_DVC Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EPICS_TS |
PctFree | |
PCTUSED | |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
BLM_DVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BLM_DVC 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 |
BLM_DVC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
BLM_DVC Security Types |
Name | Current Value |
BLM_DVC Bound Attachments |
Name | Current Value |
BLM_DVC Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Beam Loss Monitor Device |
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) EPICS.BLM_DVC |
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) 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) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
BLM_DVC Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Diagnostics MPS |
Logical | EPICS |
DIAG_MPS (Oracle) | Main Model |
BLM_DVC Data Movement Rules |
Name | Type | Rule Text/Value |