Power Device |
EntityType | Dependent |
Logical Entity Name | Power Device |
Default Table Name | PWR_DVC |
Logical Only | NO |
Owner | EPICS |
Definition | Power Device: A device such as a power strip that supplies power to another device. This will exclude power supplies whos due to their unique function wihtin the facility have their own table. A database trigger will enforce the types of devices that can be in this table such that the table entites will consist of the powering device, the device that is plugged into that device and the port it is plugged into. |
Note |
Power Device Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Device Identifer | Device Id | VARCHAR(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. |
Pwr To Dvc Id | Device Id | VARCHAR(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. |
Port Nbr | Port Number | VARCHAR(4) | NO | Port Number: The number of the power port into which the device is plugged in. |
Power Device Keys |
Key Name | Key Type | Keys |
pwr_dvc_pk | PrimaryKey | Device Identifer, Pwr To Dvc Id |
Power Device Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Device | Identifying | One To Zero or More | pwr_dvc_dvc_rf | Device Identifer | YES | ||
Device | Non-Identifying | One To Zero or More | pwr_to_dvc_dvc_rf | Pwr To Dvc Id | YES |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Power Device Check Constraints |
Check Constraint Name | CheckConstraint |
Power Device Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Power Device Security Types |
Name | Current Value |
Power Device Bound Attachments |
Name | Current Value |
Power Device Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Power 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 |
Power Device Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | EPICS |
Power Device Data Movement Rules |
Name | Type | Rule Text/Value |