DVC |
Logical Entity Name | Dvc |
Default Table Name | DVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
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 DVC(      DVC_ID             VARCHAR2(50)      NOT NULL,      DVC_TYPE_ID        VARCHAR2(50),      SUBSYS_ID          VARCHAR2(10)      NOT NULL,      SYS_ID             VARCHAR2(10)      NOT NULL,      DVC_INST           VARCHAR2(25),      DVC_ID_ALIAS       VARCHAR2(50),      DRW_DVC_ID         VARCHAR2(50),      PARENT_DVC_ID      VARCHAR2(50),      DVC_DESC           VARCHAR2(255),      BL_DVC_IND         CHAR(1)           DEFAULT 'N' NOT NULL,      INVALID_ID_IND     CHAR(1)           DEFAULT 'N' NOT NULL,      VITUAL_DVC_IND     CHAR(1)           DEFAULT 'N' NOT NULL,      ACT_DVC_IND        CHAR(1)           DEFAULT 'N' NOT NULL,      MPS_DVC_IND        CHAR(1)           DEFAULT 'N' NOT NULL,      DVC_DRW_NBR        VARCHAR2(50),      MOD_BY_UID         VARCHAR2(64),      MOD_DTE            DATE,      CONSTRAINT DEVICE_PK PRIMARY KEY (DVC_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE OPER_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 50                  ),      CONSTRAINT DVC_PARENT_RF FOREIGN KEY (PARENT_DVC_ID)      REFERENCES 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 50          ) NOCACHE NOCOMPRESS ; |
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_TYPE_ID | Device Id | VARCHAR2(50) | YES | 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. |
SUBSYS_ID | VARCHAR2(10) | NO | 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". |
|
SYS_ID | System Id | VARCHAR2(10) | NO | |
DVC_INST | VARCHAR2(25) | YES | Device Instance |
|
DVC_ID_ALIAS | Device Id | VARCHAR2(50) | 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. |
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. |
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" |
INVALID_ID_IND | Indicator | CHAR(1) | NO | Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards. |
VITUAL_DVC_IND | Indicator | CHAR(1) | NO | Virtual Device Indicator: Indicates that the device identifier is used for a purpose other than the traditional device id where the device is associated with a piece of equipment. (e.g. MEB_Mag:PS_QH05a10. This virtual device is used to indicate that a signal is being sent to more than one device. In this case more than one power suppliy) |
ACT_DVC_IND | Indicator | CHAR(1) | NO | 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. |
|
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 | Modify Date | DATE | YES | Modify Date: The date the entity values were were created or modified. |
DVC Primary and Unique Keys |
Key Name | Key Type | Keys |
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 | DVC_PARENT_RF | PARENT_DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MACHINE_MODE | Identifying | One To Zero or More | NO | NO | NO | ||||
EPICS_DVC_GRP_ITEM | Non-Identifying | One To Zero or More | DVC_EPICS_DVC_GRP_ITEM_RF | NO | NO | NO | |||
DVC | Non-Identifying | One To Zero or More | DVC_PARENT_RF | NO | NO | NO | |||
SGNL_REC | Non-Identifying | One To Zero or More | DVC_SGNL_REC_RF | NO | NO | NO | |||
MACHINE_MODE | Non-Identifying | One To Zero or More | MPS_DVC_ID_DVC_FK | NO | NO | NO | |||
MPS_SGNL_PARAM | Identifying | One To Zero or More | MPS_SGNL_PARAM_DVC_RF | NO | NO | NO | |||
SGNL | Identifying | One To Zero or More | SGNL_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 | 50 |
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 |
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 |