INSTR_UNAVAIL |
Logical Entity Name | Instrument Unavailable |
Default Table Name | INSTR_UNAVAIL |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | XF_ADMIN |
Definition | Instrument Unavailable: Date when the the insturment is unvailable for use. This date is superseded by the Run Cycle date so an instrument is marked as unavailable here only if it during ther Run Cycle. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE XF_ADMIN.INSTR_UNAVAIL(      INSTR_ID      VARCHAR2(20)     NOT NULL,      BEGIN_DTE     DATE             DEFAULT sysdate NOT NULL,      END_DTE       DATE             DEFAULT sysdate NOT NULL,      CONSTRAINT PK_INSTR_UNAVAIL PRIMARY KEY (INSTR_ID, BEGIN_DTE, END_DTE),      CONSTRAINT FK_INSTR_UNAVAIL_INSTR FOREIGN KEY (INSTR_ID)      REFERENCES XF_ADMIN.INSTR(INSTR_ID) )ORGANIZATION INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE XF_OPER_TS NOPARALLEL STORAGE(INITIAL 256K          NEXT 256K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          FREELISTS 1          FREELIST GROUPS 1          ) LOGGING ; |
PostSQL |
INSTR_UNAVAIL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
INSTR_ID | VARCHAR2(20) | NO | Instrument Identifier: Abbreviated identier for the instrument. |
|
BEGIN_DTE | Date | DATE | NO | Date: Date and time to seconds. |
END_DTE | Date | DATE | NO | Date: Date and time to seconds. |
INSTR_UNAVAIL Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_INSTR_UNAVAIL | PrimaryKey | INSTR_ID, BEGIN_DTE, END_DTE |
INSTR_UNAVAIL Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
INSTR | Identifying | One To Zero or More | FK_INSTR_UNAVAIL_INSTR | INSTR_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
INSTR_UNAVAIL Check Constraints |
Check Constraint Name | CheckConstraint |
INSTR_UNAVAIL Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | XF_OPER_TS |
PctFree | 10 |
PCTUSED | |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
Organization | Index-Organized |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
INSTR_UNAVAIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_UNAVAIL 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 |
INSTR_UNAVAIL Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
INSTR_UNAVAIL Security Types |
Name | Current Value |
INSTR_UNAVAIL Bound Attachments |
Name | Current Value |
INSTR_UNAVAIL Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical XF_ADMIN.Instrument Unavailable |
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) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) XF_ADMIN.INSTR_UNAVAIL |
NO |
INSTR_UNAVAIL Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Experimental Facilities Administration |
XF_ADMIN (Oracle) | Main Model |
INSTR_UNAVAIL Data Movement Rules |
Name | Type | Rule Text/Value |