OPR_CHKLST_ITEM |
Logical Entity Name | Operations Checklist Item |
Default Table Name | OPR_CHKLST_ITEM |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | OPER |
Definition | Operations Checklist: The checklist steps, either completed or in process. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE OPER.OPR_CHKLST_ITEM(      "Chklst Id"    VARCHAR2(120)     NOT NULL,      "Chklst Rev"   NUMBER(2, 0)      NOT NULL,      "Chklst Dte"   DATE              NOT NULL,      "Step Nbr"     VARCHAR2(4)       NOT NULL,      "Step Cmplt"   CHAR(1)           DEFAULT 'N' NOT NULL,      Val            VARCHAR2(50),      CONSTRAINT opr_chklst_item_opr_chklst_rf FOREIGN KEY ("Chklst Id", "Chklst Rev", "Chklst Dte")      REFERENCES OPER.OPR_CHKLST("Chklst Id", "Chklst Rev", "Chklst Dte"),      CONSTRAINT opr_chklst_item_chklst_step_rf FOREIGN KEY ("Chklst Id", "Chklst Rev", "Step Nbr")      REFERENCES OPER.CHKLST_STEP("Chklst Id", "Chklst Rev", "Step Nbr") ) PCTFREE 10 INITRANS 1 MAXTRANS 255 TABLESPACE OPER_TS LOGGING NOPARALLEL STORAGE(INITIAL 256K          NEXT 1024K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; ALTER TABLE OPER.OPR_CHKLST_ITEM ADD      CONSTRAINT PK_OPR_CHKLST_ITEM PRIMARY KEY ("Chklst Id", "Chklst Rev", "Chklst Dte", "Step Nbr")      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE OPER          LOGGING          STORAGE(INITIAL 256K                  NEXT 1024K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ) ; |
PostSQL |
OPR_CHKLST_ITEM Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Chklst Id | Name | VARCHAR2(120) | NO | Name: A long description name usually accompanied by an abbreviated code. |
Chklst Rev | NUMBER(2, 0) | NO | ||
Chklst Dte | Modify Date | DATE | NO | Modify Date: The date the entity values were were created or modified. |
Step Nbr | VARCHAR2(4) | NO | ||
Step Cmplt | Indicator | CHAR(1) | NO | Step Complete Indicator: Indicates if the step was completed. |
Val | Default Text | VARCHAR2(50) | YES | Value: Additional information that may need to be recorded. |
OPR_CHKLST_ITEM Primary and Unique Keys |
Key Name | Key Type | Keys |
opr_chklst_item_pk | PrimaryKey | Chklst Id, Chklst Rev, Chklst Dte, Step Nbr |
OPR_CHKLST_ITEM Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
CHKLST_STEP | Identifying | One To Zero or More | opr_chklst_item_chklst_step_rf | Chklst Id, Chklst Rev, Step Nbr | NO | NO | NO | ||
OPR_CHKLST | Identifying | One To Zero or More | opr_chklst_item_opr_chklst_rf | Chklst Id, Chklst Rev, Chklst Dte | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
OPR_CHKLST_ITEM Check Constraints |
Check Constraint Name | CheckConstraint |
OPR_CHKLST_ITEM Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_TS |
PctFree | 10 |
PCTUSED | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
OPR_CHKLST_ITEM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPR_CHKLST_ITEM Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 4 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
OPR_CHKLST_ITEM Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
OPR_CHKLST_ITEM Security Types |
Name | Current Value |
OPR_CHKLST_ITEM Bound Attachments |
Name | Current Value |
OPR_CHKLST_ITEM Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical OPER.Operations Checklist Item |
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) OPER.OPR_CHKLST_ITEM |
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 |
OPR_CHKLST_ITEM Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Operation |
OPER (Oracle) | Main Model |
OPR_CHKLST_ITEM Data Movement Rules |
Name | Type | Rule Text/Value |