Banco-de-Dados.md

@@ -13,7 +13,112 @@
 ---
 
 # Diagrama Lógico do Banco de Dados
-![image](uploads/7a61cee876f98665328d053cfa319cea/image.png)
+```mermaid
+classDiagram
+    class Experience {
+      - String cnpj
+      - String name
+      - String email
+      - String phone
+      - String description
+      - Image image
+      - Boolean isFeatured
+      - JSON socialNetwork
+      - Address address
+      - Tag tags
+      - Category category
+      - Profile profile
+    }
+
+    class Spot {
+      - Integer id
+      - WorkingDay[] workingDay
+    }
+
+    class Event {
+      - Integer id
+      - String details
+      - String time
+    }
+
+    class WorkingDay {
+      - Integer id
+      - String day
+      - String openingHour
+      - String closingHour
+    }
+
+    class Tag {
+      - Integer id
+      - String name
+      - Category category
+    }
+
+    class Category {
+      - Integer categoryId;
+      - String name;
+      - Tag[] tags;
+    }
+
+    class Address {
+      - Integer id
+      - String street
+      - Integer number
+      - String zipCode
+    }
+
+    class Profile {
+      - Integer id;
+      - String name;
+      - String email;
+      - String cpf;
+      - String phone;
+      - String password;
+    }
+
+    class Route {
+      - Integer id
+      - String name
+      - String description
+      - RouteType routeType
+      - Experience[] experienceList
+    }
+
+    class RouteType {
+      - Integer id
+      - String name
+      - String description
+    }
+
+    class Image {
+        - Integer id
+        - String url;
+    }
+
+    class SocialNetwork {
+      - Integer id
+      - String tiktok
+      - String youtube
+      - String facebook
+      - String otherSocialNetwork
+    }
+
+    Experience "0..*" <--> "0..*" Category
+    Experience "1" <--> "1" Address
+    Experience "0..*" <--> "0..*" Tag : Tags_Experience
+    Experience "1" <--> "1" SocialNetwork
+    Experience <|-- Spot : Inheritance
+    Experience <|-- Event : Inheritance
+    Experience "0..*" <--> "1" Profile
+    Experience "0..n" <--> "1" Image
+    Experience "0..*" <--> "1..*" Route
+
+    Route "1..*" <--> "1" RouteType
+
+    Category "0..*" <--> "0..1" Tag : Tags_Category
+
+    Spot "1" <--> "1" WorkingDay
+```
 
 # Dados salvos client-side (cache do navegador)
 - Preferências do usuário
@@ -31,4 +136,4 @@
 }`
 
 # Arquivo do Diagrama
-[Diagrama-BD-TurismoRural.asta](uploads/f7bfc68d4af7cf9476b3340640af521f/Diagrama-BD-TurismoRural.asta)
\ No newline at end of file
+[Diagrama-BD-TurismoRural.asta](uploads/dfc9ccabe42af804a8bd59aba9fc0352/Diagrama-BD-TurismoRural.asta)
\ No newline at end of file