Aller au contenu

6. Base de données

6.1 Modèle conceptuel (UML)

```plantuml @startuml entity User { id: UUID email: string password: string (hash) googleId: string name: string }

entity Service { id: UUID name: string (unique) label: string icon: string active: boolean }

entity UserService { id: UUID userId: UUID serviceId: UUID accessToken: text refreshToken: text expiresAt: Date profileId: string username: string }

entity Area { id: UUID user_id: UUID name: string

actionService: string actionType: string

reactionService: string reactionType: string

parameters: JSONB active: boolean lastTriggered: Date }

User ||--o{ Area : has User ||--o{ UserService : connects Service ||--o{ UserService : provider @enduml