Mag_Mnfctr_Mdl |
Logical Entity Name | Magnet Manufacter Model |
Default Table Name | Mag_Mnfctr_Mdl |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Magnet Manufacturer Model: Manufacturer information relating specifically to magnets. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE Mag_Mnfctr_Mdl(      "Core Lngth"                   NUMBER(14, 6),      Gap                            NUMBER(14, 6),      "Mag Lngth"                    NUMBER(14, 6),      Resistance                     NUMBER(14, 6),      "Trim Turn Ratio"              NUMBER(7, 3),      "Dipole Entr Rotation Angle"   NUMBER(14, 6),      "Dipole Exit Rotation Angle"   NUMBER(14, 6),      "Dipole Bend Angle"            NUMBER(14, 6),      "Rev Swap Term Ind"            CHAR(1)           DEFAULT 'N' NOT NULL,      "Path Lngth"                   NUMBER(14, 6),      NBR_TURN_POLE                  NUMBER(38, 0),      PWR_SPLY_MAX_I                 NUMBER(38, 0),      TRIM_MAX_I                     NUMBER(38, 0),      THRM_MAX_I                     NUMBER(38, 0),      "Dipole Quad Term"             NUMBER(12, 8) ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
Mag_Mnfctr_Mdl Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Core Lngth | Standard Number | NUMBER(14, 6) | YES | Core Length |
Gap | Standard Number | NUMBER(14, 6) | YES | Gap |
Mag Lngth | Standard Number | NUMBER(14, 6) | YES | Magnetic Length |
Resistance | Standard Number | NUMBER(14, 6) | YES | Resistance: Resistance of the circuit (Ohm). |
Trim Turn Ratio | NUMBER(7, 3) | YES | Trim Turn Ratio: Ratio of trim windings / primary windings. Is 0 if no trims. Only for trims of primary pole type. |
|
Dipole Entr Rotation Angle | Standard Number | NUMBER(14, 6) | YES | Dipole Entrance Rotation Angle |
Dipole Exit Rotation Angle | Standard Number | NUMBER(14, 6) | YES | Dipole Exit Rotaton Angle |
Dipole Bend Angle | Standard Number | NUMBER(14, 6) | YES | Dipole Bend Angle |
Rev Swap Term Ind | Indicator | CHAR(1) | NO | Reverse Swap Terminal Indicator |
Path Lngth | Standard Number | NUMBER(14, 6) | YES | Path Length |
NBR_TURN_POLE | NUMBER(38, 0) | YES | Number Turn Pole: ???? |
|
PWR_SPLY_MAX_I | NUMBER(38, 0) | YES | Power Supply Maximum Current: Maximum current to be provided by the power supply to the magnet. |
|
TRIM_MAX_I | NUMBER(38, 0) | YES | Trim Maximum Current: The maximum current to be provided to the magnet trim. |
|
THRM_MAX_I | NUMBER(38, 0) | YES | Thermal Maximum Current: The maximum current for the magnets operating temperature. |
|
Dipole Quad Term | NUMBER(12, 8) | YES | Dipole Quadrupole Termination: The dipole quadrupole field component using MAD definition (1/m2). |
Mag_Mnfctr_Mdl Primary and Unique Keys |
Key Name | Key Type | Keys |
Mag_Mnfctr_Mdl Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
Mag_Mnfctr_Mdl Check Constraints |
Check Constraint Name | CheckConstraint |
Mag_Mnfctr_Mdl 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_Mnfctr_Mdl Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
Mag_Mnfctr_Mdl 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_Mnfctr_Mdl Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Mag_Mnfctr_Mdl Security Types |
Name | Current Value |
Mag_Mnfctr_Mdl Bound Attachments |
Name | Current Value |
Mag_Mnfctr_Mdl Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EQUIP.Magnet Manufacter Model |
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) Mag_Mnfctr_Mdl |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
Mag_Mnfctr_Mdl Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Equipment |
Logical | Power Supply |
Logical | XAL Optics |
XAL_OPTICS (Oracle) | Main Model |
Mag_Mnfctr_Mdl Data Movement Rules |
Name | Type | Rule Text/Value |