Communications Device |
EntityType | Dependent |
Logical Entity Name | Communications Device |
Default Table Name | COMM_DVC |
Logical Only | NO |
Owner | EPICS |
Definition | Communication Device: A device such as a network switch which has multiple connectionss to another device. This table will track these connections as opposed to the more facility specific parent device relationship that defines the functional approach. (i.e. magent ->power supply interfce->power supply->rack) A database trigger will enforce the types of devices that can be in this table such that the table entites will consist of the communications device, the device that is plugged into that device and the port it is plugged into. |
Note |
Communications Device Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Device Identifer | Device Id | VARCHAR(50) | NO | Device Identifier: The device identifier of the communications device. |
Comm To Dvc Id | Device Id | VARCHAR(50) | NO | Communication To Device Identifier: The device identifier of the device plugged into the communications device port.. |
Port Nbr | Port Number | VARCHAR(4) | NO | Port Number: The number of the communications port into which the device is plugged in. |
Communications Device Keys |
Key Name | Key Type | Keys |
pwr_dvc_pk_1 | PrimaryKey | Device Identifer, Comm To Dvc Id |
Communications Device Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Device | Identifying | One To Zero or More | Device Identifer | YES | |||
Device | Non-Identifying | One To Zero or More | Comm To Dvc Id | YES |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Communications Device Check Constraints |
Check Constraint Name | CheckConstraint |
Communications Device Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Communications Device Security Types |
Name | Current Value |
Communications Device Bound Attachments |
Name | Current Value |
Communications Device Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Communications 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) Does Not Exist |
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 |
Communications Device Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Communications Device Data Movement Rules |
Name | Type | Rule Text/Value |