OPR_CHKLST |
Logical Entity Name | Operations Checklist |
Default Table Name | OPR_CHKLST |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | OPER |
Definition | Operations Checklist: An instance of a checklist which has been performed or is in the process of being performed. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE OPER.OPR_CHKLST(      "Chklst Id"          VARCHAR2(120)      NOT NULL,      "Chklst Rev"         NUMBER(2, 0)       NOT NULL,      "Chklst Dte"         DATE               NOT NULL,      "Chklst Cmplt Ind"   CHAR(1)            DEFAULT 'N' NOT NULL,      CMNT                 VARCHAR2(2000),      "Chklst Id Val"      VARCHAR2(50),      DVC_ID               VARCHAR2(50),      "Mod By Uid"         VARCHAR2(64)       NOT NULL,      CONSTRAINT opr_chklst_chklst_rf FOREIGN KEY ("Chklst Id", "Chklst Rev")      REFERENCES OPER.CHKLST("Chklst Id", "Chklst Rev") ) 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 ADD      CONSTRAINT PK_OPR_CHKLST PRIMARY KEY ("Chklst Id", "Chklst Rev", "Chklst Dte")      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 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 | Checklist Revision: Revision number. |
|
Chklst Dte | Modify Date | DATE | NO | Modify Date: The date the entity values were were created or modified. |
Chklst Cmplt Ind | Indicator | CHAR(1) | NO | Checklist Complete Indicator: Indicates whether or not the checklist was completed. |
CMNT | Comment | VARCHAR2(2000) | YES | Comment: General comments. |
Chklst Id Val | VARCHAR2(50) | YES | Checklist Title Value: Allows a value to be displayed with the title of an instance of a checklist. (i.e. Allow diagnostics to display a device identifier with the checklist title) |
|
DVC_ID | Device Id | VARCHAR2(50) | YES | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
Mod By Uid | Mod By Uid | VARCHAR2(64) | NO | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
OPR_CHKLST Primary and Unique Keys |
Key Name | Key Type | Keys |
opr_chklst_pk | PrimaryKey | Chklst Id, Chklst Rev, Chklst Dte |
OPR_CHKLST Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
CHKLST | Identifying | One To Zero or More | opr_chklst_chklst_rf | Chklst Id, Chklst Rev | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
OPR_CHKLST_ITEM | Identifying | One To Zero or More | opr_chklst_item_opr_chklst_rf | NO | NO | NO |
OPR_CHKLST Check Constraints |
Check Constraint Name | CheckConstraint |
OPR_CHKLST 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 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPR_CHKLST Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 1 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
OPR_CHKLST Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
OPR_CHKLST Security Types |
Name | Current Value |
OPR_CHKLST Bound Attachments |
Name | Current Value |
OPR_CHKLST Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical OPER.Operations Checklist |
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 |
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 Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Operation |
OPER (Oracle) | Main Model |
OPR_CHKLST Data Movement Rules |
Name | Type | Rule Text/Value |