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

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 Attachment {
        - Integer id
        - String url;
    }

    class SocialNetwork {
      - Integer id
      - String tiktok
      - String youtube
      - String facebook
      - String otherSocialNetwork
    }

    Experience "0..*" <--> "1..*" 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 "1" <--> "0..*" Attachment
    Experience "1..*" <--> "0..*" Route

    Category "0..*" <--> "0..*" 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

A ser implementado

Entidade Rotas

Experiencias

{
      "routeExperienceId": 01,
      "experienceId": 01,
      "title": "Titulo Exemplo",
      "description": "Esta é uma descrição exemplo!",
      "image": "image_url",
      "orderIndex": 1
}

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