IOC_DVC |
Logical Entity Name | IOC_DVC |
Default Table Name | IOC_DVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Input/Output Controller Device: |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EPICS.IOC_DVC(      DVC_ID                    VARCHAR2(40)      NOT NULL,      IP_ADDR                   VARCHAR2(50),      ETHER_ADDR                VARCHAR2(50),      NET_DOMAIN                VARCHAR2(50),      NET_MASK                  VARCHAR2(50),      IOC_NET_NM                VARCHAR2(50),      VLAN_NBR                  VARCHAR2(30),      SW_DVC_ID                 VARCHAR2(40),      SW_PORT_NBR               NUMBER(2, 0),      TSRV_DVC_ID               VARCHAR2(40),      TSRV_PORT_NBR             VARCHAR2(50),      RPC_DVC_ID                VARCHAR2(40),      RPC_ADDR                  VARCHAR2(30),      IOC_SER_NBR               VARCHAR2(50),      TTY_NM                    VARCHAR2(50),      CPU_TYPE                  VARCHAR2(50),      BOOT_PARAMS               VARCHAR2(50),      EPICS_VERSION             VARCHAR2(50),      STATUS                    VARCHAR2(50),      RESET_ID                  NUMBER(12, 6),      DSGN_CAB_SLOT_BGN         NUMBER(3, 0),      DSGN_CAB_SLOT_END         NUMBER(3, 0),      DSGN_CAB_SLOT_POS_IND     CHAR(1)           DEFAULT 'F' NOT NULL,      POS_WITHIN_SLOTS          NUMBER(3, 0),      DIAG_CONFIG_FILE_NM       VARCHAR2(100),      DIAG_CONFIG_FILE_LOC      VARCHAR2(128),      DIAG_CONFIG_FILE_CONT     CLOB,      BOOT_DTE                  DATE,      BOOT_SRV                  VARCHAR2(128),      BOOT_FILE                 VARCHAR2(256),      VXWORKS_BSP_VER           VARCHAR2(25),      GATEWAY_ADR               VARCHAR2(50),      LOGIN_NM                  VARCHAR2(64),      PARSE_IND                 CHAR(1)           DEFAULT 'Y' NOT NULL,      VXWORKS_OS_VER            VARCHAR2(25),      APP_MOD_NM                VARCHAR2(25),      APP_MOD_VER               VARCHAR2(25),      APP_MOD_LOC               VARCHAR2(256),      IOC_CONFIG_TYPE_ID        VARCHAR2(25),      SOFT_IOC_IND              CHAR(1)           DEFAULT 'N' NOT NULL,      CONSTRAINT IOC_DVC_ZERO_CK CHECK (dsgn_cab_slot_bgn > 0),      CONSTRAINT IOC_DVC_SLOT_END_CK CHECK (dsgn_cab_slot_end < 46),      CONSTRAINT IOC_DVC_POS_CK CHECK (dsgn_cab_slot_pos_ind in ('F','B','L','R')),      CONSTRAINT IOC_DVC_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 FK_IOC_DVC_DVC FOREIGN KEY (DVC_ID)      REFERENCES EPICS.DVC(DVC_ID) ON DELETE CASCADE,      CONSTRAINT FK_IOC_DVC_ICT FOREIGN KEY (IOC_CONFIG_TYPE_ID)      REFERENCES EPICS.IOC_CONFIG_TYPE(IOC_CONFIG_TYPE_ID),      CONSTRAINT IOC_DVC_RPC_DVC_ID_DVC_FK FOREIGN KEY (RPC_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT IOC_DVC_TSRV_DVC_ID_DVC_FK FOREIGN KEY (TSRV_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT IOC_SW_DVC_ID_DVC_FK FOREIGN KEY (SW_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 LOB(DIAG_CONFIG_FILE_CONT) STORE AS   (TABLESPACE EPICS_TS STORAGE (INITIAL 64K NEXT 64K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS UNLIMITED FREELISTS 1 FREELIST GROUPS 1) CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING) NOCOMPRESS ; CREATE UNIQUE INDEX EPICS.IDX_IOC_NET_NM ON EPICS.IOC_DVC(IOC_NET_NM)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EPICS_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
PostSQL |
IOC_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. |
|
IP_ADDR | VARCHAR2(50) | YES | Internet Protocol Address: The internet protocol address assigned to the input/output controller. |
|
ETHER_ADDR | VARCHAR2(50) | YES | Ethernet Address: The ethernet address for the IOC. |
|
NET_DOMAIN | VARCHAR2(50) | YES | Net Domain: Network Domain Name. |
|
NET_MASK | VARCHAR2(50) | YES | Network Mask: The network mask for the device. |
|
IOC_NET_NM | VARCHAR2(50) | YES | Integrated Control Systems Network Name: Internal name for controls devices attached to the network. |
|
VLAN_NBR | VARCHAR2(30) | YES | Virtual Local Area Network Number: |
|
SW_DVC_ID | VARCHAR2(40) | YES | Switch Device Id: The device id of the switch to which the IOC is connected. |
|
SW_PORT_NBR | NUMBER(2, 0) | YES | Switch Port: The switch port to which the IOC connects. |
|
TSRV_DVC_ID | VARCHAR2(40) | YES | Terminal Server Device Identifer: The terminal server to which the device is connected. |
|
TSRV_PORT_NBR | VARCHAR2(50) | YES | Terminal Server Port: The device port to which the terminal server connects. |
|
RPC_DVC_ID | VARCHAR2(40) | YES | Remote Power Controller Device Identifer: The RPC that will reboot the device. |
|
RPC_ADDR | VARCHAR2(30) | YES | Remote Power Controller Address: The address in the chain where the RPC is located. |
|
IOC_SER_NBR | VARCHAR2(50) | YES | Input Output Controller Serial Number: The serial of the IOC, as opposed to the IOC chassis serial number tracked in the Equipment Tracking System. |
|
TTY_NM | VARCHAR2(50) | YES | Tty Name: |
|
CPU_TYPE | VARCHAR2(50) | YES | Central Processing Unit Type: The central processing unit type of the input/output device. |
|
BOOT_PARAMS | VARCHAR2(50) | YES | Boot Parameters: The systems settings for the input / output controller used when initializing the device. |
|
EPICS_VERSION | VARCHAR2(50) | YES | EPICS Version: |
|
STATUS | VARCHAR2(50) | YES | Status: The status of the input/output device. |
|
RESET_ID | NUMBER(12, 6) | YES | Reset Identifier: When sending this identifier via the SNS "reset" RTDL frame, the IOC will reboot (via the utility module.) |
|
DSGN_CAB_SLOT_BGN | NUMBER(3, 0) | YES | Design Cabinet Beginning Slot Number: The first slot the equipment occupies in the cabinet. |
|
DSGN_CAB_SLOT_END | NUMBER(3, 0) | YES | Design Cabinet Ending Slot Number: If more than one slot is required for equipment, this field indicates the last slot number used. |
|
DSGN_CAB_SLOT_POS_IND | CHAR(1) | NO | Design Cabinet Slot Indicator: Used to indicate how the device is installed into the cabinet. Valid values include "F - Front" or "B-Back". |
|
POS_WITHIN_SLOTS | NUMBER(3, 0) | YES | Position Within Slots: Indicates the relative position of the device in a slot where more than one device is used. |
|
DIAG_CONFIG_FILE_NM | VARCHAR2(100) | YES | Diagnostics Configuration File Name: The name the diagnostics IOC configuration file cotents should be stored as on the IOC. |
|
DIAG_CONFIG_FILE_LOC | VARCHAR2(128) | YES | Diagnostics Configuration File Location: The directory location where the contents of the Diagnostics Configuratin FIle will be stored. |
|
DIAG_CONFIG_FILE_CONT | CLOB | YES | Diagnostics Configuration File Contents: The acutal configuration file for the diagnostics IOC. |
|
BOOT_DTE | DATE | YES | Boot Date: The date the last time the IOC was booted. |
|
BOOT_SRV | VARCHAR2(128) | YES | Boot Server: The server from which the IOC derived it's boot information. |
|
BOOT_FILE | VARCHAR2(256) | YES | Boot File: The file from which the IOC derived it's boot information. |
|
VXWORKS_BSP_VER | VARCHAR2(25) | YES | ||
GATEWAY_ADR | VARCHAR2(50) | YES | ||
LOGIN_NM | VARCHAR2(64) | YES | ||
PARSE_IND | CHAR(1) | NO | Parse Indicator: Indicates whether or not the PV Crawler should crawl this IOC. |
|
VXWORKS_OS_VER | VARCHAR2(25) | YES | ||
APP_MOD_NM | VARCHAR2(25) | YES | Application Module Name: The application module loaded into the IOC parsed from the TOP variable in the cdCommands file. |
|
APP_MOD_VER | VARCHAR2(25) | YES | Application Module Version: The application module version loaded into the IOC parsed from the TOP variable in the cdCommands file. |
|
APP_MOD_LOC | VARCHAR2(256) | YES | Application Module Location: The directory path for this version of the IOC application module. |
|
IOC_CONFIG_TYPE_ID | VARCHAR2(25) | YES | ||
SOFT_IOC_IND | CHAR(1) | NO |
IOC_DVC Primary and Unique Keys |
Key Name | Key Type | Keys |
IDX_IOC_NET_NM | Index | IOC_NET_NM |
IOC_DVC_PK | PrimaryKey | DVC_ID |
IOC_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 More | FK_IOC_DVC_DVC | DVC_ID | NO | NO | NO | ||
IOC_CONFIG_TYPE | Non-Identifying | Zero or One to Zero or More | FK_IOC_DVC_ICT | IOC_CONFIG_TYPE_ID | NO | NO | NO | ||
DVC | Non-Identifying | Zero or One to Zero or More | IOC_DVC_RPC_DVC_ID_DVC_FK | RPC_DVC_ID | NO | NO | NO | ||
DVC | Non-Identifying | Zero or One to Zero or More | IOC_DVC_TSRV_DVC_ID_DVC_FK | TSRV_DVC_ID | NO | NO | NO | ||
DVC | Non-Identifying | Zero or One to Zero or More | IOC_SW_DVC_ID_DVC_FK | SW_DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
SGNL_FLD | Identifying | One To Zero or More | FK_SGNL_FLD_IOC_DVC | NO | NO | NO |
IOC_DVC Check Constraints |
Check Constraint Name | CheckConstraint |
IOC_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 |
IOC_DVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IOC_DVC Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 632 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
IOC_DVC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
IOC_DVC Security Types |
Name | Current Value |
IOC_DVC Bound Attachments |
Name | Current Value |
IOC_DVC Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Input Output Controller 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) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.IOC_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) 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 |
IOC_DVC Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Diagnostics |
Logical | EPICS |
EPICS (Oracle) | Main Model |
IOC_DVC Data Movement Rules |
Name | Type | Rule Text/Value |