DVC |
Logical Entity Name | Device |
Default Table Name | DVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Device: A collection of one or more types of equipment used to perform a function. A device is "generic" in that it's parameters are static. Equipment components may be swapped in and out without changing the overall device parameters. A device may consist of one equipment component or be composed of multiple pieces of equipment. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EPICS.DVC(      DVC_ID              VARCHAR2(50)      NOT NULL,      DVC_INST            VARCHAR2(25),      PARENT_DVC_ID       VARCHAR2(50),      DVC_DESC            VARCHAR2(255),      BL_DVC_IND          CHAR(1)           DEFAULT 'N' NOT NULL,      VIRTUAL_DVC_IND     CHAR(1)           DEFAULT 'N' NOT NULL,      INVALID_ID_IND      CHAR(1)           DEFAULT 'N' NOT NULL,      DVC_ID_ALIAS        VARCHAR2(75),      ACT_DVC_IND         CHAR(1)           DEFAULT 'Y',      MPS_DVC_IND         CHAR(1)           DEFAULT 'N' NOT NULL,      DVC_DRW_NBR         VARCHAR2(50),      DRW_DVC_ID          VARCHAR2(50),      MOD_BY_UID          VARCHAR2(64),      MOD_DTE             DATE,      OWNER_CAT_ID        VARCHAR2(10),      CONSTRAINT DEVICE_PK PRIMARY KEY (DVC_ID)      USING INDEX TABLESPACE EPICS_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ),      CONSTRAINT PARENT_DVC_ID_DVC_RF FOREIGN KEY (PARENT_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 ; CREATE UNIQUE INDEX EPICS.DVC_ID_ALIAS_IDX ON EPICS.DVC(DVC_ID_ALIAS) TABLESPACE EPICS_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PostSQL |
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. |
DVC_INST | VARCHAR2(25) | YES | Device Instance |
|
PARENT_DVC_ID | Device Id | VARCHAR2(50) | YES | Parent Device Identifier: If the device is part of another device this field will contain the device identifier for the parent device. |
DVC_DESC | Description | VARCHAR2(255) | YES | Device Description: A free form text field used to describe a device. |
BL_DVC_IND | Indicator | CHAR(1) | NO | Beam Line Device Indicator: Default is "N" |
VIRTUAL_DVC_IND | CHAR(1) | NO | ||
INVALID_ID_IND | Indicator | CHAR(1) | NO | Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards. |
DVC_ID_ALIAS | VARCHAR2(75) | YES | Device Identifier Alias: This field is used to the "to-be" device identifier. Currently non-standard device identifiers are stored in the device identifier field. The alias field is used to store the device identifier that will later become the actual identifier for the device. |
|
ACT_DVC_IND | Indicator | CHAR(1) | YES | Active Device Indicator: Indicates that the device is in active use. (i.e. If device is still in design and not yet functional the indicator will be set to N) |
MPS_DVC_IND | Indicator | CHAR(1) | NO | Machine Protection System Device Inidcator: Indicates the device is part of the MPS or is protected by the MPS. |
DVC_DRW_NBR | VARCHAR2(50) | YES | Device Drawing Number: The number of the drawing for which the device is documented. |
|
DRW_DVC_ID | Device Id | VARCHAR2(50) | YES | Drawing Device Id: The device id as it was specified on the drawing. The device very well may have been renamed since it was defined on a drawing. |
MOD_BY_UID | Mod By Uid | VARCHAR2(64) | YES | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
MOD_DTE | DATE | YES | Modify Date: The date the record was created or modified. |
|
OWNER_CAT_ID | VARCHAR2(10) | YES | Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories. |
DVC Primary and Unique Keys |
Key Name | Key Type | Keys |
DEVICE_PK | PrimaryKey | DVC_ID |
DVC_ID_ALIAS_IDX | Index | DVC_ID_ALIAS |
DVC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
DVC | Non-Identifying | Zero or One to Zero or More | PARENT_DVC_ID_DVC_RF | PARENT_DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BLM_DVC | Identifying | One to Zero or One | NO | NO | NO | ||||
ND_DVC | Identifying | One to Zero or One | NO | NO | NO | ||||
HVPS_DVC | Identifying | One to Zero or One | NO | NO | YES | ||||
MPS_INTFC_DVC | Identifying | One to Zero or One | NO | NO | YES | ||||
SSA_DVC | Identifying | One to Zero or One | NO | NO | YES | ||||
DIGIO_DVC | Identifying | One to Zero or One | NO | NO | NO | ||||
ADC_DVC | Identifying | One to Zero or One | NO | NO | YES | ||||
AFE_DVC | Identifying | One to Zero or One | NO | NO | NO | ||||
DAC_DVC | Identifying | One to Zero or One | NO | NO | NO | ||||
IP_CARR_DVC | Identifying | One to Zero or One | NO | NO | YES | ||||
BLM_DVC | Non-Identifying | One To Zero or More | NO | NO | NO | ||||
MPS_INTFC_DVC | Non-Identifying | One To Zero or More | NO | NO | NO | ||||
ADC_DVC | Non-Identifying | One To Zero or More | FK_ADC_AFE_DVC | NO | NO | NO | |||
ADC_DVC | Non-Identifying | One To Zero or More | FK_ADC_BLM_IOC_DVC | NO | NO | NO | |||
AFE_DVC | Non-Identifying | One To Zero or More | FK_AFE_BLM_IOC_DVC | NO | NO | NO | |||
BLM_DVC | Non-Identifying | One To Zero or More | FK_BLM_ADC_DVC | NO | NO | NO | |||
BLM_DVC | Non-Identifying | One To Zero or More | FK_BLM_HVPS_DVC | NO | NO | NO | |||
BLM_DVC | Non-Identifying | One To Zero or More | FK_BLM_MPS_INTFC_DVC | NO | NO | NO | |||
BLM_DVC | Non-Identifying | One To Zero or More | FK_BLM_SSA_DVC | NO | NO | NO | |||
DAC_DVC | Non-Identifying | One To Zero or More | FK_DAC_AFE_DVC | NO | NO | NO | |||
DAC_DVC | Non-Identifying | One To Zero or More | FK_DAC_IP_CARR_DVC | NO | NO | NO | |||
DIGIO_DVC | Non-Identifying | One To Zero or More | FK_DIGIO_AFE_DVC | NO | NO | NO | |||
DIGIO_DVC | Non-Identifying | One To Zero or More | FK_DIGIO_BLM_DVC | NO | NO | NO | |||
MPS_INTFC_DVC | Non-Identifying | One To Zero or More | FK_MPS_INFRC_IOC_DVC | NO | NO | NO | |||
MPS_INTFC_DVC | Non-Identifying | One To Zero or More | FK_MPS_INTFC_AFE_DVC | NO | NO | NO | |||
MPS_INTFC_DVC | Non-Identifying | One To Zero or More | FK_MPS_INTFC_MIOC_DVC | NO | NO | NO | |||
ND_DVC | Non-Identifying | One To Zero or More | FK_ND_ADC_FAST_DVC | NO | NO | NO | |||
ND_DVC | Non-Identifying | One To Zero or More | FK_ND_ADC_SLOW_DVC | NO | NO | NO | |||
ND_DVC | Non-Identifying | One To Zero or More | FK_ND_HVPD_DVC | NO | NO | NO | |||
ND_DVC | Non-Identifying | One To Zero or More | FK_ND_MPS_INTFC_DVC | NO | NO | NO | |||
ND_DVC | Non-Identifying | One To Zero or More | FK_ND_SSA_DVC | NO | NO | NO | |||
SSA_DVC | Non-Identifying | One To Zero or More | FK_SSA_AFE_DVC | NO | NO | NO | |||
SSA_DVC | Non-Identifying | One To Zero or More | FK_SSA_MPS_INTFC_DVC | NO | NO | NO | |||
MACHINE_MODE | Non-Identifying | One To Zero or More | MACHINE_MODE_DVC_FK | NO | NO | NO | |||
MPS_SGNL_PARAM | Identifying | One To Zero or More | MPS_SGNL_PARAM_DVC_RF | NO | NO | NO | |||
DVC | Non-Identifying | One To Zero or More | PARENT_DVC_ID_DVC_RF | NO | NO | NO |
DVC Check Constraints |
Check Constraint Name | CheckConstraint |
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 |
DVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
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 |
DVC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
DVC Security Types |
Name | Current Value |
DVC Bound Attachments |
Name | Current Value |
DVC Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.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.DVC |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.DVC |
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) EPICS.DVC |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) DVC |
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) EPICS.DVC |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
DVC Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Diagnostics |
Logical | Diagnostics MPS |
Logical | EPICS |
Logical | Machine Mode |
Logical | Power Supply |
Logical | XAL Optics |
DIAG_MPS (Oracle) | Main Model |
EPICS (Oracle) | Main Model |
IRMISBase (Oracle) | Main Model |
MPS (Oracle) | Main Model |
XAL_OPTICS (Oracle) | Main Model |
DVC Data Movement Rules |
Name | Type | Rule Text/Value |