759:ERD generation
Test Case #:759 | Test Case Name: ERD generation |
System: OpenLmis | Subsystem: auth |
Test case designed by: Paulina Borowa | Design Date:03.08.2016 |
Short description: Acceptance: * Generate ERD for all schema. Work with dev team on whether these are per service, or can be combined into a consolidated view. Or both.* ERD is automatically generated, either with each service or as a separate build job * Default tech choice is SchemaSpy - open to alternatives. * Publish link to ERD(s) for all to enjoy |
|
Pre – conditions: |
|
Step | Action | Expected system response | Comment |
1 | Go to:
| Appears SchemaSpy Analysis of Database open_lmis view:  |
|
2 | Choose from Schema →public
| Appears SchemaSpy Analysis of open_lmis.public view: Appears SchemaSpy Analysis of open_lmis.public - All Relationships view: |
|
3 | Check Realtionships bookmark:
| |
|
4 |
|
Appears SchemaSpy Analysis of Database open_lmis view: |
|
5 | Go to: Schema →referencedata
| Appears SchemaSpy Analysis of open_lmis.referencedata view:
|
|
6 | Check Realtionships bookmark
|
Appears SchemaSpy Analysis of open_lmis.referencedata - All Relationships view: |
|
7 | Back to Schemas bookmark and chose requisition
| appears SchemaSpy Analysis of open_lmis.requisition view:
|
|
8 |
Check Realtionships bookmark
|
Appears SchemaSpy Analysis of open_lmis.requisition - All Relationships view |
|