[Issue #1363] Update the Opportunity summary database models based on updated database schema plan #75

	# Update database ERD diagrams so that they remain up to date with the application
	name: Update Database ERD Diagrams

	on:
	pull_request:
	paths:
	- api/src/db/models/**
	- api/bin/create_erds.py
	- Makefile
	- .github/workflows/ci-erd-diagrams.yml

	defaults:
	run:
	working-directory: ./api

	# Only trigger one update of the ERD diagrams at a time on the branch.
	# If new commits are pushed to the branch, cancel in progress runs and start
	# a new one.
	concurrency:
	group: ${{ github.head_ref }}
	cancel-in-progress: true


	jobs:
	update-database-erd:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v3
	with:
	# Checkout the feature branch associated with the pull request
	ref: ${{ github.head_ref }}

	- name: Update OpenAPI spec
	run: make create-erds

	- name: Push changes
	run: \|
	git config user.name nava-platform-bot
	git config user.email [email protected]
	git add --all
	# Commit changes (if no changes then no-op)
	git diff-index --quiet HEAD \|\| git commit -m "Update database ERD diagrams"
	git push

Provide feedback