Conception modeles de données pour les festivals

Matchs

Actuel

classDiagram
    class Match {
        +bigint id
        +string nom_visiteur
        +string nom_resident
    }

Future

classDiagram
    class Match {
        +bigint id
    }

    class Event {
    }

    class Journee {
        +bigint id
    }

    class Participant {
        +bigint id
        +string nom
    }

    class EventParticipant {
        +bigint participant_id
        +bigint event_id
        +string event_class
    }

    Match "1" ..> "1" Event
    Journee "1" ..> "1" Event
    Participant "1" <--> "n" EventParticipant
    EventParticipant "1" <--> "1" Event

classDiagram
    class Event {
        +bigint id
        +bigint event_type_id
        +string event_type_class
    }

    class Match {
        +bigint id
        +bigint event_id
    }

    class Journee {
        +bigint id
        +bigint event_id
    }

    class Participant {
        +bigint id
        +string nom
    }

    class EventParticipant {
        +bigint participant_id
        +bigint event_id
        +string discriminant
    }

    Event <..> Match
    Event <..> Journee
    Participant "n" <--> "1" EventParticipant
    EventParticipant "1" <--> "n" Event