search

LegendarySpork9 / Hunter-Industries-API

File Store for the Assistant API
Other
0 stars 0 forks source link

Add Change Table to Database and API #7

Closed LegendarySpork9 closed 1 month ago

LegendarySpork9 commented 6 months ago

Create a change table linked to the audit history table that stores previous values of changes columns.

LegendarySpork9 commented 5 months ago

Added to Database and Database ERD.

LegendarySpork9 commented 1 month ago

Added code for the insert of change rows.

Need to add a link to the audit history table that doesn't go through endpoints while still being able to link to endpoint.

Image

LegendarySpork9 commented 1 month ago

Connect using AuditID. Alter Audit History insert code to return the ID of the new row for use in the change table.

LegendarySpork9 commented 1 month ago

Change code added and tested:

Image