| Project_Step |
| Logical Entity Name | Project_Step |
| Default Table Name | Project_Step |
| Physical Only | NO |
| Do Not Generate | False |
| Owner | |
| 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 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), CONSTRAINT FK_PRJCT_STEP_PRV_PRJCT_EXPRMT FOREIGN KEY (PREV_PROJECT_EXPERIMENT_ID) REFERENCES PROJECT_EXPERIMENT(PROJECT_EXPERIMENT_ID), CONSTRAINT FK_PRJCT_STEP_NXT_PRJCT_EXPRMT FOREIGN KEY (NEXT_PROJECT_EXPERIMENT_ID) REFERENCES PROJECT_EXPERIMENT(PROJECT_EXPERIMENT_ID) ) ; COMMENT ON TABLE Project_Step IS '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.' ; CREATE INDEX FK_PRJCT_STEP_NXT_PRJCT_EXPRMT ON Project_Step(NEXT_PROJECT_EXPERIMENT_ID) ; CREATE INDEX FK_PRJCT_STEP_PRV_PRJCT_EXPRMT ON Project_Step(PREV_PROJECT_EXPERIMENT_ID) ; |
| PostSQL |
| Project_Step Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| Project_Step_ID |
Identifier | NUMBER(19, 0) | NO | |
| VERSION | Version | NUMBER(38, 0) | NO | |
| NEXT_PROJECT_EXPERIMENT_ID |
Identifier | NUMBER(19, 0) | NO | |
| PREV_PROJECT_EXPERIMENT_ID |
Identifier | NUMBER(19, 0) | NO | |
| Date_Created | Date_Created | TIMESTAMP(6) | NO | |
| EDGE_NAME | VARCHAR2(128) | YES | ||
| Last_Updated | Last_Updated | TIMESTAMP(6) | YES | |
| MODIFIED_BY | 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 | |
| PctFree | 10 |
| PCTUSED | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 0 |
| PctIncrease | 0 |
| InitTrans | 1 |
| MaxTrans | 255 |
| Organization | Heap |
| Cache | NO |
| Logging | Logged |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Table Compression | NO |
| Row Movement | Disabled |
| Project_Step Growth Metrics |
| TABLE METRIC | TABLE METRIC VALUE |
| Current Row Count | 5000 |
| Growth | 250 |
| Growth Type | Rows |
| Growth Period | per Month |
| Maximum Rows | 10000 |
| Project_Step Security Types |
| Name | Current Value |
| Project_Step Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Project_Step |
NO | |||
| BARD - MySQL (MySQL) Does Not Exist |
NO | |||
| BARD_Dev (Oracle) Project_Step |
NO | |||
| Current Production (Oracle) Does Not Exist |
NO |
| Project_Step Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Project Information |
| Logical | RI hierarchy |
| BARD_Dev (Oracle) | Main Model |
| BARD_Dev (Oracle) | Project Information |
| BARD_Dev (Oracle) | RI hierarchy |