| PROJECT_STEP |
| Logical Entity Name | PROJECT_STEP |
| Default Table Name | PROJECT_STEP |
| Physical Only | NO |
| Do Not Generate | False |
| Owner | BARD_CAP_PROD |
| Definition | The annotations (context items) for a step show the annotations of the incoming arrowhead on the edge between the experiments and the "follows" experiment. Thus the annotations can refer to the experiment or the step (aka decision) that instigated the experiment. Bear in mind that the "follows" experiment can be null, i.e. this the experiment does not have a predecessor. Primary screens tend to have this characteristic. |
| Note | |
| PreSQL | |
| DDL Code | CREATE TABLE BARD_CAP_PROD.PROJECT_STEP(      PROJECT_STEP_ID                NUMBER(19, 0)     NOT NULL,      VERSION                        NUMBER(38, 0)     DEFAULT 0 NOT NULL,      NEXT_PROJECT_EXPERIMENT_ID     NUMBER(19, 0)     NOT NULL,      PREV_PROJECT_EXPERIMENT_ID     NUMBER(19, 0)     NOT NULL,      DATE_CREATED                   TIMESTAMP(6)      DEFAULT sysdate NOT NULL,      EDGE_NAME                      VARCHAR2(128),      LAST_UPDATED                   TIMESTAMP(6),      MODIFIED_BY                    VARCHAR2(40),      CONSTRAINT PK_PROJECT_STEP PRIMARY KEY (PROJECT_STEP_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE BARD_CAP_PROD          LOGGING          STORAGE(INITIAL 64K                  NEXT 1024K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  BUFFER_POOL DEFAULT                  ),      CONSTRAINT FK_PRJCT_STEP_NXT_PRJCT_EXPRMT FOREIGN KEY (NEXT_PROJECT_EXPERIMENT_ID)      REFERENCES BARD_CAP_PROD.PROJECT_EXPERIMENT(PROJECT_EXPERIMENT_ID),      CONSTRAINT FK_PRJCT_STEP_PRV_PRJCT_EXPRMT FOREIGN KEY (PREV_PROJECT_EXPERIMENT_ID)      REFERENCES BARD_CAP_PROD.PROJECT_EXPERIMENT(PROJECT_EXPERIMENT_ID) ) PCTFREE 10 INITRANS 1 MAXTRANS 255 TABLESPACE BARD_CAP_PROD LOGGING STORAGE(INITIAL 64K          NEXT 1024K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          BUFFER_POOL DEFAULT          ) ; |
| PostSQL |
| PROJECT_STEP Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
PROJECT_STEP_ID |
NUMBER(19, 0) | NO | ||
| VERSION | NUMBER(38, 0) | NO | ||
NEXT_PROJECT_EXPERIMENT_ID |
NUMBER(19, 0) | NO | ||
PREV_PROJECT_EXPERIMENT_ID |
NUMBER(19, 0) | NO | ||
| DATE_CREATED | TIMESTAMP(6) | NO | ||
| EDGE_NAME | VARCHAR2(128) | YES | ||
| LAST_UPDATED | TIMESTAMP(6) | YES | ||
| MODIFIED_BY | VARCHAR2(40) | YES |
| PROJECT_STEP Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_PROJECT_STEP | PrimaryKey | PROJECT_STEP_ID |
| PROJECT_STEP Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
| PROJECT_EXPERIMENT | Non-Identifying | One To Zero or More | FK_PRJCT_STEP_NXT_PRJCT_EXPRMT | NEXT_PROJECT_EXPERIMENT_ID | NO | NO | NO | ||
| PROJECT_EXPERIMENT | Non-Identifying | One To Zero or More | FK_PRJCT_STEP_PRV_PRJCT_EXPRMT | PREV_PROJECT_EXPERIMENT_ID | NO | NO | NO |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
| STEP_CONTEXT | Non-Identifying | One To Zero or More | FK_STEP_CNTXT_STEP | NO | NO | NO |
| PROJECT_STEP Check Constraints |
| Check Constraint Name | CheckConstraint |
| PROJECT_STEP Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | BARD_CAP_PROD |
| PctFree | 10 |
| PCTUSED | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 1 |
| MaxTrans | 255 |
| Organization | Heap |
| Cache | NO |
| Logging | Logged |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | FreeLists |
| FREELIST GROUPS | FreeList Groups |
| Buffer Pool | DEFAULT |
| Table Compression | NO |
| Row Movement | Disabled |
| PROJECT_STEP Growth Metrics |
| TABLE METRIC | TABLE METRIC VALUE |
| Current Row Count | 0 |
| Growth | Static |
| Growth Type | N/A |
| Growth Period | N/A |
| Maximum Rows | 0 |
| PROJECT_STEP Security Types |
| Name | Current Value |
| PROJECT_STEP Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Does Not Exist |
NO | |||
| BARD - MySQL (MySQL) Does Not Exist |
NO | |||
| BARD_Dev (Oracle) Does Not Exist |
NO | |||
| Current Production (Oracle) BARD_CAP_PROD.PROJECT_STEP |
NO |
| PROJECT_STEP Where Used - Submodel Usage |
| Model | Submodel Usage |
| Current Production (Oracle) | Main Model |
| Current Production (Oracle) | Project Information |
| Current Production (Oracle) | RI hierarchy |