Add an additional attribute to the items_extended materialized database view called "lastWorn". The last worn attribute should return an ISO date of when this particular item was last worn in an outfit for this user. If there are no outfits associated with this item, null should be returned. Make sure the authorUsername attributes match. See previous draft of this feature in Github: https://github.com/radicalplatforms/shafa/blob/376d182b58db59461a463c1f5ae5427bfa4109e6/hono/src/service/items.ts#L32
Description
Add an additional attribute to the items_extended materialized database view called "lastWorn". The last worn attribute should return an ISO date of when this particular item was last worn in an outfit for this user. If there are no outfits associated with this item, null should be returned. Make sure the authorUsername attributes match. See previous draft of this feature in Github: https://github.com/radicalplatforms/shafa/blob/376d182b58db59461a463c1f5ae5427bfa4109e6/hono/src/service/items.ts#L32
Acceptance Criteria