Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • Wiki Wiki
  • Project information
    • Project information
    • Activity
    • Labels
    • Planning hierarchy
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 32
    • Issues 32
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Infrastructure Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • O Turismo Rural em São Francisco de Paula
  • WikiWiki
  • Wiki
  • Banco de Dados

Last edited by Matheus Fernandes da Rosa Jun 27, 2024
Page history
This is an old version of this page. You can view the most recent version or browse the history.

Banco de Dados

🏠Home

Documentação de Negócio

Escopo Processo Gerência Design

Documentação Técnica

Arquitetura Banco de Dados Analytics

Diagrama Lógico do Banco de Dados

classDiagram
    class Experience {
      - String cnpj
      - String name
      - String email
      - String phone
      - String description
      - String image
      - Boolean isFeatured
      - Attachment attachments
      - 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 Attachment {
        - 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" Attachment
    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
  • Favoritos

Definição de JSONs

Entidade Experiencias

Redes Sociais

{ }

Entidade Rotas

Experiencias

{ }

Arquivo do Diagrama

Diagrama-BD-TurismoRural.asta

Clone repository

Home

Documentação do Projeto

Escopo

Processo

Gerência

Design

Sprints

Documentação Técnica

Arquitetura

Banco de Dados

Analytics