This repository contains SQL scripts to generate a database schema in MariaDB. The schema includes tables for managing recipes, comments, users, tags, and more.
The database schema consists of the following tables:
- image: Stores image data for avatars and recipe images.
- person: Contains information about users such as name, email, and registration date.
- responsibility: Stores responsibilities associated with users.
- person_responsibility: Defines a many-to-many relationship between persons and responsibilities.
- status: Defines status options for recipes.
- locale: Stores locale information for translations.
- recipe: Represents individual recipes with details like author, cook time, and difficulty level.
- recipe_translation: Stores translations of recipe details in different languages.
- tag: Contains tags associated with recipes.
- comment: Stores comments made by users on recipes.
- comment_like: Tracks likes on comments.
- favorite: Stores information about users' favorite recipes.
- recipe_tag: Represents a many-to-many relationship between recipes and tags.
- recipe_rating: Stores ratings given by users to recipes.
-
Clone the Repository: Clone this repository to your local machine using
git clone. -
Execute SQL Scripts: Run the provided SQL scripts in your MariaDB environment to create the database schema.
-
Customization: Modify the schema or add additional features as per your requirements.
Contributions are welcome! If you find any issues or have suggestions for improvements, feel free to open an issue or create a pull request.
This project is licensed under the MIT License.