Overview

We need a way to handle errors during the creation of a table with a FK.

This issue adds text to each Create Table issue containing a FK, providing instructions on what the developer should do to clear the error and, once the FK table has been created, make sure that their comments get uncommented.

Action Items

Add links to issues

• Go to this link: Issues tab, label: needs FK text
• Find the FK references.
• Find the related table issues (using issue tab, spreadsheet)
• If the issue has a table format, we will need to add 2 extra columns for the FK designation and the issue link. See example of table issue
• Add the links to the issues next to the FK item
• If the issues found are all closed, then remove the label
• Copy and paste the two templates below into the top comment

Update issue templates

• Table creation issue template change needed
  • All issues need to be formatted like this (with table) in the future Update Table: User #429
    • file to update: https://github.com/hackforla/peopledepot/blob/main/.github/ISSUE_TEMPLATE/create-table-issue-template.md
• Table update issue template change needed
  • we need to expand the table so that it has space for Key Type and FK issue(s)
    • file to update: https://github.com/hackforla/peopledepot/blob/main/.github/ISSUE_TEMPLATE/update-table.md

Resources

• Find table issues
  • Spreadsheet PD: Table and field explanations, Tables - has links to issues next to table names. Might be a little out of date, but worth checking if you can't find the issue.
  • Issue tab, label: table creation

Templates to add

- Check to see if open issues in `FK status` below
   - [ ] If all Issues listed are closed (or there are no FKs), then skip the next 3 steps
      - [ ] comment out the code after you create it (see FK Status below for open/closed state)
      - [ ] add an action item on the open issue to uncomment the code line you commented out when that issue's table is created. 
      - [ ] Provide your file and line number as a permalink under resources in that issue

### FK status