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
|
|
OpenLMIS: the global initiative for powerful LMIS software