data.gov icon indicating copy to clipboard operation
data.gov copied to clipboard

Update models to reflect table definition doc

Open rshewitt opened this issue 9 months ago • 0 comments

User Story

In order to use the most recent table definitions, datagov wants to update the harvest database tables to reflect what's in the table definition document

Acceptance Criteria

[ACs should be clearly demoable/verifiable whenever possible. Try specifying them using BDD.]

  • [ ] GIVEN the existing db models in harvesting logic
    WHEN an update to the model happens
    THEN the new table(s) should exist as they are in the table definition file
    AND columns with foreign keys should not be nullable

Background

[Any helpful contextual notes or links to artifacts/evidence, if needed]

Security Considerations (required)

[Any security concerns that might be implicated in the change. "None" is OK, just be explicit here!]

Sketch

[Notes or a checklist reflecting our understanding of the selected approach]

rshewitt avatar May 20 '24 17:05 rshewitt