DVC |
Logical Entity Name | DVC |
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(40)      NOT NULL,      SYS_ID              VARCHAR2(10),      SUBSYS_ID           VARCHAR2(10),      DVC_TYPE_ID         VARCHAR2(25),      DVC_INST            VARCHAR2(25),      DVC_DESC            VARCHAR2(255),      PARENT_DVC_ID       VARCHAR2(40),      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(40),      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(40),      MOD_BY_UID          VARCHAR2(64),      MOD_DTE             DATE,      OWNER_CAT_ID        VARCHAR2(10),      CONSTRAINT DEVICE_PK PRIMARY KEY (DVC_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE EPICS_INDEX_TS          NOLOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  FREELISTS 1                  FREELIST GROUPS 1                  BUFFER_POOL DEFAULT                  ),      CONSTRAINT PARENT_DVC_ID_DVC_RF FOREIGN KEY (PARENT_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 64K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          FREELISTS 1          FREELIST GROUPS 1          BUFFER_POOL DEFAULT          ) NOCACHE NOCOMPRESS ; CREATE UNIQUE INDEX EPICS.DVC_ID_ALIAS_IDX ON EPICS.DVC(DVC_ID_ALIAS)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_INDEX_TS      NOLOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
PostSQL |
DVC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DVC_ID | VARCHAR2(40) | NO | Device Identifier: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
|
SYS_ID | VARCHAR2(10) | YES | System Identifier: This System to which the device is assigned. This field is validated against the System table. If the value is not found then the Invalid Sys Ind field is set to "Y". |
|
SUBSYS_ID | VARCHAR2(10) | YES | Subsystem Identifier: This Subsystem to which the device is assigned. This field is validated against the Subsystem table. If the value is not found then the Invalid Sub Sys Ind field is set to "Y". |
|
DVC_TYPE_ID | VARCHAR2(25) | YES | Device Type Identifier: This Device Type to which the device is assigned. This field is validated against the Dvc Type table. If the value is not found then the Invalid Dvc Type Ind field is set to "Y". |
|
DVC_INST | VARCHAR2(25) | YES | Device Instance: |
|
DVC_DESC | VARCHAR2(255) | YES | Device Description: A free form text field used to describe a device. |
|
PARENT_DVC_ID | VARCHAR2(40) | YES | Parent Device Identifier: If the device is part of another device this field will contain the device identifier for the parent device. |
|
BL_DVC_IND | CHAR(1) | NO | Beam Line Device Indicator: Default is "N" |
|
VIRTUAL_DVC_IND | CHAR(1) | NO | ||
INVALID_ID_IND | CHAR(1) | NO | Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards. |
|
DVC_ID_ALIAS | VARCHAR2(40) | 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 i |
|
ACT_DVC_IND | 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 | CHAR(1) | NO | Machine Protection System Device Indicator: Indicates that the device is part of or 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 | VARCHAR2(40) | 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 | 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 |
DVC_ID_ALIAS_IDX | Index | DVC_ID_ALIAS |
DEVICE_PK | PrimaryKey | DVC_ID |
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 |
SGNL_REC | Non-Identifying | One To Zero or More | DVC_SGNL_REC_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 | 10 |
PCTUSED | 40 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
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 |
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 |