B1-PostgreSQLAutoServiceERP : Car Service Database with SwiftUI and PostgreSQL GUI

Description

This repository serves as a portfolio project aimed at creating a database system for a car service center. The primary focus is on learning and implementing PostgreSQL for database operations, SwiftUI for GUI.

Features

PostgreSQL

• Table Creation: Implemented essential tables to store information about cars, technicians, and services.
• Relationships Between Tables: Set up relationships to ensure data integrity.
• Data Retrieval: Queries for extracting necessary information are available.
• Data Insertion: Supports the insertion of new records into tables.
• Data Deletion: Functionality for deleting records is implemented.
• Data Modification: Capability to update existing records.
• Views: Complex queries are simplified into views for convenience.
• Stored Procedures: Utilized for automating routine tasks.
• Triggers: Automatic actions upon certain database events.
• Cursors: Employed for more complicated data selection operations.

Technology

• pgadmin4, docker-postgres, testcontainers,

• restfulapi, postman

• junit

• spring, start.spring.io, gradle, hibernate, jakarta, tomcat

• BCrypt

• Swift + SwiftUI + Foundation

Screenshots

Directory	Services

Add Service	Edit Service

Add Work

## License

MIT License. For more information, see the LICENSE file.

---

For any questions or suggestions, feel free to reach out at github::safroalex.