Skip to content

Latest commit

 

History

History
67 lines (45 loc) · 2.36 KB

README.md

File metadata and controls

67 lines (45 loc) · 2.36 KB

Mechanic Workshop Database

This repository contains the database schema for a mechanic workshop management system. The database schema is defined in the SQL script file named OficinaMecanincaDB.sql. Additionally, there are two visual representations of the database model in the form of MySQL Workbench files: OficinaMecanincaDB.png and OficinaMecanincaDB.mwb.

Database Model

Tables

  1. customers

    • Fields: id, name, email, phone, city, state
    • Primary Key: id

  2. mechanics

    • Fields: id, name, specialization
    • Primary Key: id

  3. services

    • Fields: id, description, labor_cost
    • Primary Key: id

  4. parts

    • Fields: id, description, price
    • Primary Key: id

  5. work_orders

    • Fields: id, number, issue_date, total_value, status, delivery_date, customer_id, mechanic_id, execution_authorization
    • Primary Key: id
    • Foreign Keys: customer_id (references customers.id), mechanic_id (references mechanics.id)

  6. work_orders_services

    • Fields: work_order_id, service_id
    • Primary Key: work_order_id, service_id
    • Foreign Keys: work_order_id (references work_orders.id), service_id (references services.id)

  7. work_orders_parts

    • Fields: work_order_id, part_id, quantity
    • Primary Key: work_order_id, part_id
    • Foreign Keys: work_order_id (references work_orders.id), part_id (references parts.id)

Changes Made

  • work_orders table:
    • Added mechanic_id field to reference the mechanic responsible for the work order.
    • Added execution_authorization field to indicate whether the execution was authorized.

Database Visualization

How to Use

  1. SQL Script:

    • Execute the SQL script OficinaMecanincaDB.sql on your MySQL database server to create the database and tables.

  2. MySQL Workbench:

    • Open the MySQL Workbench files (OficinaMecanincaDB.mwb) to visualize and interact with the database model using MySQL Workbench.

Feel free to customize the database according to your specific requirements.

Contributors

  • Luis Gustavo Cezar Puga (lgustavopuga)

License

This project is licensed under the [MIT] License - see the LICENSE.md file for details.