Create Table issues data gathering workflow

1. Check this issue to find the next table that needs to be created.

   1. Or the tables spreadsheet for rows that don't already have an issue created

   2. Always update the spreadsheet as the single source of truth.

2. Create a new issue using the Create Table form

3. Identify the table description

   

4. Record the table description

   

5. Identify and copy data fields checkboxes

   

6. Record data fields

   

7. Identify and copy associated tables checkboxes. Do not worry that it doesn't look right. This is the way it has to be for this reason.

   

8. Record associated tables

   

9. Manually compare data fields with ERD and check off fields in the issue

   1. Note any fields that exists only in the ERD

   

10. Manually compare associated table with ERD and check off tables in the issue

    1. You will have to visually trace all the lines connecting the table to another table. These are the related tables. Sometimes there's no line but there's a FK for the data field, which means it's still a relationship. Please make a note of these since it is missing a line connecting it to the other table.

       1. There are 4 related tables for permission. 3 of the FK (Foreign Keys) reference the same user table.

       2. See also how permission_type has 1-to-many relationships with permission and permission_history. Same for the role table. Think of the cross end as a "1", and the chicken feet end as "many".

    2. Note any tables that exist only in the ERD