EXCITAION_CURVE |
Logical Entity Name | Excitaion Curve |
Default Table Name | EXCITAION_CURVE |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Excitaion Curve: Points along the operational Integrated Transfer function (i) curve. These points are from the upper hysterisis curve (going from high current to low current). ITF levels are for the primary mulitpole, in MKS units {(T-m)/m^(n-1)}/A. E.g. Dipole(n=1) is T-m/A, Quad (N=2) is T/A, etc. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EXCITAION_CURVE(      TEST_DTE                DATE               DEFAULT sysdate NOT NULL,      POLE                    NUMBER(2, 0)       NOT NULL,      EXCITAION_CURVE_CUR     NUMBER(12, 6)      NOT NULL,      ITF                     NUMBER(14, 10),      X_REF                   NUMBER(12, 6),      Y_REF                   NUMBER(12, 6),      NORM_SKEW_CDE           NUMBER(1, 0),      SHIM_THICK              NUMBER(12, 6),      NOTE                    VARCHAR2(4000),      EQUIP_ID                VARCHAR2(30)       NOT NULL,      CONSTRAINT PKEXCITAION_CURVE PRIMARY KEY (EQUIP_ID),      CONSTRAINT MAG_EXCITAION_CURVE_RF FOREIGN KEY (EQUIP_ID)      REFERENCES MAG(EQUIP_ID) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE MAGNET_TS LOGGING NOPARALLEL STORAGE(INITIAL 10K          NEXT 10K          MINEXTENTS 1          MAXEXTENTS 121          PCTINCREASE 50          ) NOCACHE NOCOMPRESS ; |
PostSQL |
EXCITAION_CURVE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TEST_DTE | Date | DATE | NO | Test Date |
POLE | NUMBER(2, 0) | NO | Pole: Multipole of winding for measurement (Use if more than one per magnet). |
|
EXCITAION_CURVE_CUR | Magnet Default | NUMBER(12, 6) | NO | Exitaion Curve Current: Current point (A) |
ITF | Magnet Large Value | NUMBER(14, 10) | YES | Integrated Transfer Function: The Integrated transfer function (field integrated over length, normalized by current). |
X_REF | Magnet Default | NUMBER(12, 6) | YES | X Reference: The Horizontal location of the origin for the harmonic expansion, measured from the magnetic center. Positive = to the right looking from the coil lead end. |
Y_REF | Magnet Default | NUMBER(12, 6) | YES | Y Reference: The Vertical location of the origin for the harmonic expansion, measured from the magnetic center, positive = up. |
NORM_SKEW_CDE | NUMBER(1, 0) | YES | Normal Skew Code: 0 = skew measurement. 1 = normal measurement. |
|
SHIM_THICK | Magnetic Field | NUMBER(12, 6) | YES | Shim Thickness: Shim thickness used in the measurement (mm). "Positive" is return leg shim (increasing the gap) and "negative" is pole shim (reducing the gap). |
NOTE | Note | VARCHAR2(4000) | YES | |
EQUIP_ID | Asset Identifier | VARCHAR2(30) | NO | Asset Identifier: The Datastream/Infor asset identifier also often referred to as the Barcode Id. |
EXCITAION_CURVE Primary and Unique Keys |
Key Name | Key Type | Keys |
EXCITAION_CURVE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
MAG | Identifying | One To Zero or More | MAG_EXCITAION_CURVE_RF | EQUIP_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EXCITAION_CURVE Check Constraints |
Check Constraint Name | CheckConstraint |
EXCITAION_CURVE Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | MAGNET_TS |
PctFree | 10 |
PCTUSED | 40 |
MinExtents | 1 |
MaxExtents | 121 |
Initial | 10 |
Next | 10 |
PctIncrease | 50 |
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 |
EXCITAION_CURVE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXCITAION_CURVE Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
EXCITAION_CURVE Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
EXCITAION_CURVE Security Types |
Name | Current Value |
EXCITAION_CURVE Bound Attachments |
Name | Current Value |
EXCITAION_CURVE Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical MAGNET.Excitaion Curve |
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) EXCITAION_CURVE |
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 |
EXCITAION_CURVE Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Magnet |
Logical | Power Supply |
Magnet (Oracle) | Main Model |
EXCITAION_CURVE Data Movement Rules |
Name | Type | Rule Text/Value |