| Project_Step |
| EntityType | Independent |
| Logical Entity Name | Project_Step |
| Default Table Name | Project_Step |
| Logical Only | NO |
| 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 |
| Project_Step Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| Project_Step_ID |
Identifier | BIGINT | NO | |
| Version | Version | INTEGER | NO | |
| Next_Project_Experiment_ID |
Identifier | BIGINT | NO | |
| Prev_Project_Experiment_ID |
Identifier | BIGINT | NO | |
| Date_Created | Date_Created | TIMESTAMP/DATE | NO | |
| Edge_Name | VARCHAR(128) | YES | ||
| Last_Updated | Last_Updated | DATETIME | YES | |
| Modified_by | Modified_by | VARCHAR(40) | YES |
| Project_Step Keys |
| Key Name | Key Type | Keys |
| PK_Project_Step | PrimaryKey | Project_Step_ID |
| FK_PRJCT_STEP_NXT_PRJCT_EXPRMT | Inversion Entry | Next_Project_Experiment_ID |
| FK_PRJCT_STEP_PRV_PRJCT_EXPRMT | Inversion Entry | Prev_Project_Experiment_ID |
| Project_Step Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Project_Experiment | Non-Identifying | One To Zero or More | next | Next_Project_Experiment_ID | NO | ||
| Project_Experiment | Non-Identifying | One To Zero or More | previous | Prev_Project_Experiment_ID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| Step_Context | Non-Identifying | One To Zero or More | NO |
| Project_Step Check Constraints |
| Check Constraint Name | CheckConstraint |
| 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 |