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,      OWNER_CAT_ID        VARCHAR2(10),      OWNER_BN            VARCHAR2(10),      ORNL_PROP_NBR       VARCHAR2(10),      "Dvc Drw Nbr"       VARCHAR2(50),      "Drw Dvc Id"        VARCHAR2(50),      "Mod Dte"           DATE,      "Mod By Uid"        VARCHAR2(64),      CONSTRAINT Device_pk PRIMARY KEY (DVC_ID)      USING INDEX          LOGGING,      CONSTRAINT PARENT_DVC_ID_DVC_RF FOREIGN KEY (PARENT_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID) ) LOGGING NOPARALLEL 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 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. |
OWNER_CAT_ID | VARCHAR2(10) | YES | Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories. |
|
OWNER_BN | Badge Number | VARCHAR2(10) | YES | |
ORNL_PROP_NBR | VARCHAR2(10) | YES | ORNL Property Number: The property number assigned to ORNL porperty which falls into certain categories and which are above a certain value . This attribute rightly belongs to the equipment entity but has been added to the Device as a concession. |
|
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 Dte | DATE | YES | Modify Date: The date the record was created or modified. |
|
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. |
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 | 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 |
MAG_DVC | Non-Identifying | One To Zero or More | NO | NO | YES | ||||
BEAM_LINE_DVC_LOC | Identifying | One To Zero or More | BEAM_LINE_DVC_DVC_RF | NO | NO | NO | |||
DVC_SETTING | Identifying | One To Zero or More | dvc_dvc_setting_rf | NO | NO | NO | |||
Sgnl_Rec | Non-Identifying | One To Zero or More | dvc_sgnl_rec_rf | NO | NO | NO | |||
Equip_Dvc_Asgn | Identifying | One to One or More | equip_dvc_asgn_rf | is involved in | requires a | NO | NO | NO | |
Func_Dvc_Grp_Item | Identifying | One To Zero or More | func_dvc_grp_item2_rf | NO | NO | NO | |||
Func_Dvc_Grp_Item | Identifying | One To Zero or More | func_dvc_grp_item_rf | NO | NO | NO | |||
MAG_DVC | Identifying | One to Zero or One | MAG_DVC_DVC_RF | NO | NO | NO | |||
DVC | Non-Identifying | One To Zero or More | PARENT_DVC_ID_DVC_RF | NO | NO | NO | |||
RF_Cav_Dvc | Identifying | One to Zero or One | RF_CAV_DVC_DVC_RF | NO | NO | NO |
DVC Check Constraints |
Check Constraint Name | CheckConstraint |
DVC Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
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 |