MAG_DVC |
Logical Entity Name | Magnet Device |
Default Table Name | MAG_DVC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Magnet Device: |
Note | Magnet Device |
PreSQL | |
DDL Code | CREATE TABLE EPICS.MAG_DVC(      DVC_ID                         VARCHAR2(50)      NOT NULL,      "Path Lngth"                   NUMBER(12, 6),      Polarity                       CHAR(1),      DIPOLE_EXIT_POLE_CURV          NUMBER(12, 6),      "Dipole Entr Rotation Angle"   NUMBER(12, 6),      "Dipole Exit Rotation Angle"   NUMBER(12, 6),      "Dipole Entr Pole Curv"        NUMBER(12, 6),      "Dipole Bend Angle"            NUMBER(12, 6),      DIPOLE_QUAD_TERM               NUMBER(12, 7),      "PM Quad Strength"             NUMBER(12, 6),      "Beam Orient Ind"              NUMBER(1, 0),      "Pos Term Ind"                 NUMBER(1, 0),      "Term Lead Plus"               VARCHAR2(12),      "Term Lead Minus"              VARCHAR2(12),      "Trim Term Lead Plus"          VARCHAR2(12),      "Trim Term Lead Minus"         VARCHAR2(12),      "Mod By Uid"                   VARCHAR2(64),      "Mod Dte"                      DATE,      "V Reg"                        NUMBER(12, 6),      "I Reg"                        NUMBER(12, 6),      Accur                          NUMBER(12, 6),      "Max V"                        NUMBER(12, 6),      "Min V"                        NUMBER(12, 6),      MAX_I                          NUMBER(12, 6),      MIN_I                          NUMBER(12, 6),      PS_DVC_ID                      VARCHAR2(50),      CONSTRAINT BEAM_ORIENT_IND_CK CHECK (BEAM_ORIENT_IND = -1 or BEAM_ORIENT_IND = 1),      CONSTRAINT POS_TERM_IND_CK CHECK (POS_TERM_IND = 1 or POS_TERM_IND = 2),      CONSTRAINT mag_dvc_pk PRIMARY KEY (DVC_ID)      USING INDEX          LOGGING,      CONSTRAINT MAG_DVC_DVC_RF FOREIGN KEY (DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT RefDVC905 FOREIGN KEY (PS_DVC_ID)      REFERENCES EPICS.DVC(DVC_ID) ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
MAG_DVC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DVC_ID | Device Id | VARCHAR2(50) | NO | 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. |
Path Lngth | NUMBER(12, 6) | YES | Path Length: The reference trajectory path length in the element (m). |
|
Polarity | Polarity | CHAR(1) | YES | Polarity: Indicates if wiring is connected to the positive or negative pole. |
DIPOLE_EXIT_POLE_CURV | NUMBER(12, 6) | YES | Dipole Exit Pole Curvature |
|
Dipole Entr Rotation Angle | NUMBER(12, 6) | YES | Dipole Entrance Rotation Angle |
|
Dipole Exit Rotation Angle | NUMBER(12, 6) | YES | Dipole Exit Rotation Angle |
|
Dipole Entr Pole Curv | NUMBER(12, 6) | YES | Dipole Entrance Pole Curve |
|
Dipole Bend Angle | NUMBER(12, 6) | YES | Dipole Bend Angle |
|
DIPOLE_QUAD_TERM | NUMBER(12, 7) | YES | Dipole Quadrupole Terminal: The quadrupole terminal of the field (T/m). |
|
PM Quad Strength | Magnet Default | NUMBER(12, 6) | YES | PM Quadrupole Strength |
Beam Orient Ind | Beam Orient Ind | NUMBER(1, 0) | YES | Beam Orientation: Indicates the direction the magnet faces along the beamline. 1 if magnet leads are on the beam entrance end; -1 if leads are on the beam exit end. |
Pos Term Ind | Pos Term Ind | NUMBER(1, 0) | YES | Positive Terminal Inidcator: Tthe terminal number that the positive lead is connected to (allowed values = 1 or 2). |
Term Lead Plus | VARCHAR2(12) | YES | Terminal Lead Plus: The label for the attachment of positive lead from the power supply. |
|
Term Lead Minus | VARCHAR2(12) | YES | Terminal Lead Minus: The label for the attachment of negative lead from the power supply. |
|
Trim Term Lead Plus | VARCHAR2(12) | YES | Trim Terminal Lead Plus: The terminal label the positive lead of the trim winding should attach to. |
|
Trim Term Lead Minus | VARCHAR2(12) | YES | Trim Terminal Lead Minus: The terminal label the negative lead of the trim winding should attach to. |
|
Mod By Uid | Userid | VARCHAR2(64) | YES | Modify By Userid: The userid of the person who last changed the Magnet record. |
Mod Dte | DATE | YES | Modify Date: Date and time when this row was last modified |
|
V Reg | NUMBER(12, 6) | YES | Voltage Regulation: Stability in PPM of full scale. (Maximum voltage) |
|
I Reg | NUMBER(12, 6) | YES | Current Regulation: Stability in PPM of full scale. (Maximum voltage) |
|
Accur | NUMBER(12, 6) | YES | Accuracy: Linearity accuracy of the current setting (PPM of full scale). |
|
Max V | NUMBER(12, 6) | YES | Maximum Voltage: The maximum Voltage for "n" supplies of this magnet(V). |
|
Min V | NUMBER(12, 6) | YES | Minimum Voltage: The minimum Voltage for "n" supplies for this magnet(V). |
|
MAX_I | NUMBER(12, 6) | YES | Maximum Current: The maximum current for this magnet. |
|
MIN_I | NUMBER(12, 6) | YES | Minimum Current: The minimum current for this magnet. |
|
PS_DVC_ID | Device Id | VARCHAR2(50) | YES | 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. |
MAG_DVC Primary and Unique Keys |
Key Name | Key Type | Keys |
mag_dvc_pk | PrimaryKey | DVC_ID |
MAG_DVC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
DVC | Non-Identifying | Zero or One to Zero or More | PS_DVC_ID | NO | NO | NO | |||
DVC | Identifying | One to Zero or One | MAG_DVC_DVC_RF | DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MAG_DVC Check Constraints |
Check Constraint Name | CheckConstraint |
MAG_DVC 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 |
MAG_DVC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG_DVC 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 |
MAG_DVC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
MAG_DVC Security Types |
Name | Current Value |
MAG_DVC Bound Attachments |
Name | Current Value |
MAG_DVC Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Magnet 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) EPICS.MAG_DVC |
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) EPICS.MAG_DVC |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
MAG_DVC Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | EPICS |
Logical | Power Supply |
Logical | XAL Optics |
EPICS (Oracle) | Main Model |
XAL_OPTICS (Oracle) | Main Model |
MAG_DVC Data Movement Rules |
Name | Type | Rule Text/Value |