MySQL Schema & .SQL Script

Заказчик: AI | Опубликовано: 14.11.2025
Бюджет: 30 $

I already have the business logic mapped out and now need a clean, well-structured relational schema written as a single database.sql file. The database will store two main domains of data—user information and product inventory—so tables such as users, profiles, products, categories, and any junction tables you feel are essential should be covered, complete with primary keys, indexes, and properly declared foreign-key constraints. Please write the script for MySQL (recent 8.x syntax preferred) and aim for clear, readable naming conventions. If you see opportunities to normalise or add helpful lookup tables, go for it; the goal is a future-proof design that lets me extend to orders or transactions later without rewiring everything. Deliverables • database.sql containing all CREATE TABLE, ALTER, and INSERT sample rows (just a handful per table for testing). • A short read-me at the top of the file or a separate txt explaining table purpose and relationships. I’ll test by importing the file into an empty MySQL instance, so the script must run start-to-finish without manual tweaks. Let me know if you need any clarifications on field details before you dive in.