bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 58 forks source link

Legal API - Db updates for storing xml payloads #22285

Closed argush3 closed 1 month ago

argush3 commented 1 month ago

This ticket is used to make the necessary db updates to support store xml payloads sent to BCLaws for publishing to the gazette.

We had previously created a grouping_identifier column in the furnishings table but after some more design work, we will be removing this column in future tickets. To allow for more flexibility, we will use the new furnishing_group table to replace furnishings.grouping_identifier.

image.png

TODOs

argush3 commented 1 month ago

@vikas-gov @davemck513 I've pulled this into the sprint as Kevin needed work

argush3 commented 1 month ago

@kzdev420 as per retro, please provide test notes for Vishnu. thanks

vishnup0422 commented 1 month ago

Verified in Dev and the new table and column are updated.

Furnishing_groups table

Screenshot 2024-07-29 at 12.02.54 PM.png

furnishing_group_id column in Furnishings table

Screenshot 2024-07-29 at 12.02.22 PM.png