REBUILD_PHASE |
Logical Entity Name | Rebuild Phase |
Default Table Name | REBUILD_PHASE |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | IONSRC |
Definition | The purpose of this application is to capture Ion Source re-build information, operational data and post operational tear-down inspection information. It is also intended to facilitate the analysis of Ion Source experience during this period of development of an Ion Source capable of supporting full power SNS operation. The life cycle of an ion source begins when it is given a re-build number and continues through an assembly process, operation of the newly re-built source for nominally two weeks on the front end of the accelerator or on one of the two test stands and the life cycle is completed when it undergoes a post operation tear-down inspection. Critical information and data needs to be recorded during each phase of the life cycle and put into a searchable database where it can be retained and analyzed for weaknesses and improvements. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE IONSRC.REBUILD_PHASE(      REBUILD_ID            VARCHAR2(15)     NOT NULL,      ION_SRC_TYPE_ID       VARCHAR2(20)     NOT NULL,      START_DTE             DATE             DEFAULT sysdate NOT NULL,      ZERO_CROSS_POS        VARCHAR2(15),      VAC_LEAK_DET          VARCHAR2(15),      VAC_LEAK_BACK         NUMBER(8, 4),      VAC_LEAK_RATE         NUMBER(8, 4),      MAG_CON_CONF_ID       VARCHAR2(10)     NOT NULL,      LEBT_CONF_ID          VARCHAR2(10)     NOT NULL,      CES_COLL_OUT_APER     NUMBER(8, 4),      CLOSE_DTE             DATE             DEFAULT sysdate,      CONSTRAINT PK_REBUILD_PHASE PRIMARY KEY (REBUILD_ID)      USING INDEX TABLESPACE ionsrc_ts          LOGGING,      CONSTRAINT FK_REBUILD_PHASE_MCC FOREIGN KEY (MAG_CON_CONF_ID)      REFERENCES IONSRC.MAG_CON_CONFIG(MAG_CON_CONF_ID),      CONSTRAINT FK_REBUILD_PHASE_LEBTC FOREIGN KEY (LEBT_CONF_ID)      REFERENCES IONSRC.LEBT_CONF(LEBT_CONF_ID),      CONSTRAINT FK_REBUILD_PHASE_IST FOREIGN KEY (ION_SRC_TYPE_ID)      REFERENCES IONSRC.ION_SRC_TYPE(ION_SRC_TYPE_ID) ) PCTFREE 0 TABLESPACE ionsrc_ts LOGGING NOPARALLEL STORAGE(MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; |
PostSQL |
REBUILD_PHASE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
REBUILD_ID | VARCHAR2(15) | NO | ||
ION_SRC_TYPE_ID | VARCHAR2(20) | NO | ||
START_DTE | Date | DATE | NO | Date: Date and time to seconds. |
ZERO_CROSS_POS | VARCHAR2(15) | YES | Zero Crossover Position: Measured in inches. |
|
VAC_LEAK_DET | VARCHAR2(15) | YES | Vacuum Leak Detector: |
|
VAC_LEAK_BACK | NUMBER(8, 4) | YES | Vacuum Leak Background: Measured by Torr*liter/sec. |
|
VAC_LEAK_RATE | NUMBER(8, 4) | YES | Vacuum Leak Rate: Measured by Torr*liter/sec. |
|
MAG_CON_CONF_ID | VARCHAR2(10) | NO | ||
LEBT_CONF_ID | VARCHAR2(10) | NO | ||
CES_COLL_OUT_APER | NUMBER(8, 4) | YES | Cesium Collar Outlet Aperture: Measured in inches. |
|
CLOSE_DTE | Date | DATE | YES | Date: Date and time to seconds. |
REBUILD_PHASE Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_REBUILD_PHASE | PrimaryKey | REBUILD_ID |
REBUILD_PHASE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ION_SRC_TYPE | Non-Identifying | One To Zero or More | FK_REBUILD_PHASE_IST | ION_SRC_TYPE_ID | NO | NO | NO | ||
LEBT_CONF | Non-Identifying | One To Zero or More | FK_REBUILD_PHASE_LEBTC | LEBT_CONF_ID | NO | NO | NO | ||
MAG_CON_CONFIG | Non-Identifying | One To Zero or More | FK_REBUILD_PHASE_MCC | MAG_CON_CONF_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
ANT_MEAS | Identifying | One To Zero or More | FK_ANT_MEAS_RP | NO | NO | NO | |||
OPER_PHASE | Identifying | One To Zero or More | FK_OPER_PHASE_RP | NO | NO | NO | |||
POST_OPER_INSP_PHASE | Identifying | One To Zero or More | FK_POST_OPER_INSP_PHASE_RP | NO | NO | NO | |||
REBUILD_COMPO_ASGN | Identifying | One To Zero or More | FK_REBUILD_COMPO_ASGN_RP | NO | NO | NO |
REBUILD_PHASE Check Constraints |
Check Constraint Name | CheckConstraint |
REBUILD_PHASE Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
PctFree | 0 |
PCTUSED | |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | |
Next | |
PctIncrease | 0 |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
REBUILD_PHASE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE 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 |
REBUILD_PHASE Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
IONSRC_ADMIN | Role | ALTER | Revoke | NO | NO |
IONSRC_ADMIN | Role | DELETE | Grant | NO | NO |
IONSRC_ADMIN | Role | INSERT | Grant | NO | NO |
IONSRC_ADMIN | Role | SELECT | Grant | NO | NO |
IONSRC_ADMIN | Role | UPDATE | Grant | NO | NO |
IONSRC_USER | Role | DELETE | Grant | NO | NO |
IONSRC_USER | Role | INSERT | Grant | NO | NO |
IONSRC_USER | Role | SELECT | Grant | NO | NO |
IONSRC_USER | Role | UPDATE | Grant | NO | NO |
REBUILD_PHASE Security Types |
Name | Current Value |
REBUILD_PHASE Bound Attachments |
Name | Current Value |
REBUILD_PHASE Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical Does Not Exist |
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) IONSRC.REBUILD_PHASE |
NO | |||
IONSRC1 (Oracle) IONSRC.REBUILD_PHASE |
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) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
REBUILD_PHASE Where Used - Submodel Usage |
Model | Submodel Usage |
IONSRC (Oracle) | Main Model |
IONSRC1 (Oracle) | Main Model |
REBUILD_PHASE Data Movement Rules |
Name | Type | Rule Text/Value |