MACH_SNAPSHOT |
Logical Entity Name | Machine Snapshot |
Default Table Name | MACH_SNAPSHOT |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Machine Snapshot: Defines a point in time view of the accelerator operation from an Application Physics standpoint. An AP user may decide they want to save the state of the machine (i.e. save the present PV values). |
Note | |
PreSQL | |
DDL Code | CREATE TABLE MACH_SNAPSHOT(      SNAPSHOT_ID          NUMBER(8, 0)       NOT NULL,      SNAPSHOT_DTE         DATE               DEFAULT sysdate NOT NULL,      SNAPSHOT_SCORE       NUMBER(1, 0)       DEFAULT 0,      SNAPSHOT_TYPE_NM     VARCHAR2(120),      CMNT                 VARCHAR2(2000),      CONSTRAINT SYS_C008827 CHECK (snapshot_score < 6),      CONSTRAINT MACH_SNAPSHOT_PK PRIMARY KEY (SNAPSHOT_ID)      USING INDEX          LOGGING,      CONSTRAINT MACH_SNAPSHOT_TYPE_FK FOREIGN KEY (SNAPSHOT_TYPE_NM)      REFERENCES EPICS.MACH_SNAPSHOT_TYPE(SNAPSHOT_TYPE_NM) ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
MACH_SNAPSHOT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SNAPSHOT_ID | NUMBER(8, 0) | NO | Snapshot Identifier: A unique numeric value generated from an Oracle sequence object to identify the snapshot. |
|
SNAPSHOT_DTE | Date | DATE | NO | Date: Date and time to seconds. |
SNAPSHOT_SCORE | NUMBER(1, 0) | YES | Snapshot Score: A scale from 0 - 5 that indicates the quality of the snapshot data. |
|
SNAPSHOT_TYPE_NM | Name | VARCHAR2(120) | YES | Name: A long description name usually accompanied by an abbreviated code. |
CMNT | Comment | VARCHAR2(2000) | YES | Comment: General comments. |
MACH_SNAPSHOT Primary and Unique Keys |
Key Name | Key Type | Keys |
MACH_SNAPSHOT_PK | PrimaryKey | SNAPSHOT_ID |
MACH_SNAPSHOT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
MACH_SNAPSHOT_TYPE | Non-Identifying | Zero or One to Zero or More | MACH_SNAPSHOT_TYPE_FK | SNAPSHOT_TYPE_NM | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MACH_SNAPSHOT_SGNL | Identifying | One To Zero or More | MACH_SNAPSHOT_SGNL_MACH_FK | NO | NO | NO |
MACH_SNAPSHOT Check Constraints |
Check Constraint Name | CheckConstraint |
MACH_SNAPSHOT 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 |
Row Movement | Disabled |
MACH_SNAPSHOT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MACH_SNAPSHOT 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 |
MACH_SNAPSHOT Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
MACH_SNAPSHOT Security Types |
Name | Current Value |
MACH_SNAPSHOT Bound Attachments |
Name | Current Value |
MACH_SNAPSHOT Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical PVLOG.Machine Snapshot |
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) MACH_SNAPSHOT |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.MACH_SNAPSHOT |
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) MACH_SNAPSHOT |
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 |
MACH_SNAPSHOT Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Diagnostics |
Logical | EPICS |
Logical | PV Logger |
DIAG (Oracle) | Main Model |
EPICS (Oracle) | Main Model |
PV_LOGGER (Oracle) | Main Model |
MACH_SNAPSHOT Data Movement Rules |
Name | Type | Rule Text/Value |