[
“””
ok now let’s focus on our database implementation.

I want to remodel the database and implement Prisma. I want you to focus on the data layer.

currently we have a very minimal database schema, see my proposal in server/storyboard_db.sql.

I am suggesting we create seven tables, separating the images and videos and users and boards.

I want to also track the ai requests separately and we are going to add a table for videos. Every video is based on an individual image.

Images and videos may be used on multiple boards.

If a user removes an image or video from a board the user will still be able to see that media in their assets.

I have already created the database. Now i need you to setup a manageable model based architecture that implements the schema.

To begin analyze storyboard_db and consider how this transitions from our current schema.

Especially notice our new board_images and board_videos tables will need to be implemented.

We need the flexibility to do various joins and special queries.

This must loosely integrate with our websocket layer.

these changes should have minimal to no impact on the front-end

Consider the usage for our REST and websocket events.

Finally based on our current network events stub out the new and improved database layer into distinct modules.

Now that you understand our goal start on the Prisma implementation first.
“””,
“great double check your work is accurate”,
“””
great now let’s focus on migrating the API services to use our new data layer. should we add a new layer between Prisma.mysql and REST/websocket?

remember to use storyboard_db.sql as our schema guide.

focus on the rest, websocket, authentication and api end points.
“””,
“””
great proceed implementing our new data layer and api handling.
“””,
“””
double check your work is accurate and complete
“””,
“””
let’s do a back-end code clean-up and review
“””,
“””
is the new data layer complete? are we properly using server/storyboard_db.sql?

how can we improve it?
“””,
“””
ok let’s finalize and wrap it up.

these changes should have minimal to no impact on the front-end
“””,
“””
let’s verify the front and back end transaction signatures and payloads still match up
“””,
“””
great let’s check the new end-to-end client to database and back process for fixes and improvements.
“””
]