RF_Gap |
Logical Entity Name | Radio Frequency Gap |
Default Table Name | RF_Gap |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | RF Gap: |
Note | |
PreSQL | |
DDL Code | CREATE TABLE RF_Gap(      DVC_ID             VARCHAR2(50)      NOT NULL,      "RF Gap Id"        VARCHAR2(50)      NOT NULL,      "Dist From Strt"   NUMBER(14, 7),      "Ampl Tilt"        NUMBER(12, 6)     NOT NULL,      TTF                NUMBER(12, 6)     NOT NULL,      "Gap Lngth"        NUMBER(12, 6)     NOT NULL,      "Phase Offset"     NUMBER(12, 6)     NOT NULL,      "Elec Cntr Off"    NUMBER(12, 9),      "End Cell Ind"     CHAR(1)           DEFAULT 'N' NOT NULL,      CONSTRAINT rf_gap_pk PRIMARY KEY (DVC_ID, "RF Gap Id")      USING INDEX          LOGGING,      CONSTRAINT rf_cav_dvc_rf_gap_rf FOREIGN KEY (DVC_ID)      REFERENCES RF_Cav_Dvc(DVC_ID) ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
RF_Gap Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DVC_ID | Device Id | VARCHAR2(50) | NO | Device Identifier: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
RF Gap Id | VARCHAR2(50) | NO | RF Gap Identifier: The unique identifier for the RF Gap. |
|
Dist From Strt | NUMBER(14, 7) | YES | Distance From Start: Distance from the start of the RF cavity in meters(m). |
|
Ampl Tilt | NUMBER(12, 6) | NO | Amplitude Tilt |
|
TTF | NUMBER(12, 6) | NO | Transit Time Factor |
|
Gap Lngth | NUMBER(12, 6) | NO | Gap Length |
|
Phase Offset | NUMBER(12, 6) | NO | Phase Offset |
|
Elec Cntr Off | NUMBER(12, 9) | YES | Electrical Center Offset: The electric center offset from the gap center = S_electric_center = S_gap_center(m)*. |
|
End Cell Ind | Indicator | CHAR(1) | NO | End Cell Indicator: Indicates whether this gap is an end cell of a cavity. |
RF_Gap Primary and Unique Keys |
Key Name | Key Type | Keys |
rf_gap_pk | PrimaryKey | DVC_ID, RF Gap Id |
RF_Gap Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
RF_Cav_Dvc | Identifying | One To Zero or More | rf_cav_dvc_rf_gap_rf | DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
RF_Gap Check Constraints |
Check Constraint Name | CheckConstraint |
RF_Gap 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 |
RF_Gap Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RF_Gap 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 |
RF_Gap Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
RF_Gap Security Types |
Name | Current Value |
RF_Gap Bound Attachments |
Name | Current Value |
RF_Gap Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Radio Frequency Gap |
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) RF_Gap |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
RF_Gap Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | EPICS |
Logical | XAL Optics |
XAL_OPTICS (Oracle) | Main Model |
RF_Gap Data Movement Rules |
Name | Type | Rule Text/Value |