PWR_SPLY |
Logical Entity Name | Pwr Sply |
Default Table Name | PWR_SPLY |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Power Supply: A type of equipment used to generate electrical power. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE PWR_SPLY(      EQUIP_ID      VARCHAR2(30)      NOT NULL,      MOD_DTE       DATE              DEFAULT sysdate NOT NULL,      CISETASLO     NUMBER(14, 6)     DEFAULT 1,      CISETAOFF     NUMBER(14, 6)     DEFAULT 0,      ISETASLO      NUMBER(14, 6)     DEFAULT 0,      ISETAOFF      NUMBER(14, 6)     DEFAULT 1,      IASLO         NUMBER(14, 6)     DEFAULT 0,      IAOFF         NUMBER(14, 6)     DEFAULT 1,      CONSTRAINT PWR_SPLY_PK PRIMARY KEY (EQUIP_ID, MOD_DTE)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE EQUIP_INDEX_TS          LOGGING          STORAGE(INITIAL 64K                  NEXT 64K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ),      CONSTRAINT RefEQUIP784 FOREIGN KEY (EQUIP_ID)      REFERENCES EQUIP(EQUIP_ID) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EQUIP_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 64K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; |
PostSQL |
PWR_SPLY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EQUIP_ID | Asset Identifier | VARCHAR2(30) | NO | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
MOD_DTE | Date | DATE | NO | Date: Date and time to seconds. |
CISETASLO | Standard Number | NUMBER(14, 6) | YES | Voltage Gain: EPICS gain calibration coefficients. |
CISETAOFF | Standard Number | NUMBER(14, 6) | YES | Voltage Offset: EPICS offset calibration coefficients. |
ISETASLO | Standard Number | NUMBER(14, 6) | YES | Current Readback Gain: EPICS gain calibration coefficients. |
ISETAOFF | Standard Number | NUMBER(14, 6) | YES | Current Readback Offset: EPICS offset calibration coefficients. |
IASLO | Standard Number | NUMBER(14, 6) | YES | Current Setpoint Gain: EPICS gain calibration coefficients. |
IAOFF | Standard Number | NUMBER(14, 6) | YES | Current Set Point Offset: EPICS offset calibration coefficients. |
PWR_SPLY Primary and Unique Keys |
Key Name | Key Type | Keys |
PWR_SPLY_PK | PrimaryKey | EQUIP_ID, MOD_DTE |
PWR_SPLY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
EQUIP | Identifying | One To Zero or More | EQUIP_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
PWR_SPLY Check Constraints |
Check Constraint Name | CheckConstraint |
PWR_SPLY Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_TS |
PctFree | 10 |
PCTUSED | 40 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
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 |
PWR_SPLY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PWR_SPLY Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
PWR_SPLY Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
PWR_SPLY Security Types |
Name | Current Value |
PWR_SPLY Bound Attachments |
Name | Current Value |
PWR_SPLY Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical Does Not Exist |
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) PWR_SPLY |
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 |
PWR_SPLY Where Used - Submodel Usage |
Model | Submodel Usage |
EQUIP (Oracle) | Main Model |
PWR_SPLY Data Movement Rules |
Name | Type | Rule Text/Value |