Data Portal - CRUD - Add Photo/Video

We would like to have this project done with a React frontend and Django backend. Timeframe to complete is 1 week. Please do not apply to this job if you cannot complete in 1 week time.


Purpose
The purpose of this portal is to display data from a MySQL Database and allow users to edit. Users with the ‘approver’ role can approved the edited items
There are several pages that will need to be created
Page Name
Auctions List of auctions from auctions table
Auction Detail Editable form for Auction Details from’ auctions’ table
Auction Items List of auction items from auction_data table
Auction Items Detail Editable form for Auction Item Details from ‘auction_data’ table
Collection List of collections from ‘collection’ table
Collection Detail Editable form for collection
Users CRUD user page with role assignments etc.

The master data hierarchy is provided in the following tables
• jewelry
• jewelry_attr
• jewelry_ddl
• jewelry_ddl_values
Data is populated into the portal by the ‘auction_data’ table. This is a table in the development database but will be a view from a separate database – keep this in mind for production deployment. When data is reviewed and edited it is saved into the ‘auction_data_reviewed’ table

Each jewelry item can have multiple components. The jewelry components of each auction item are recorded in the tables with the ‘auction_’ prefix.

Auction items and collections need the ability to have photos/videos uploaded

Database Schema Diagram, SQL Code, and page layouts attached