direction: right

sites: "sites" {
  shape: sql_table
  id: int { constraint: primary_key }
  nom: varchar
  ville: varchar
}

serveurs: "serveurs" {
  shape: sql_table
  id: int { constraint: primary_key }
  nom: varchar
  site_id: int { constraint: foreign_key }
}

techniciens: "techniciens" {
  shape: sql_table
  id: int { constraint: primary_key }
  nom: varchar
  equipe: varchar
}

incidents: "incidents" {
  shape: sql_table
  id: int { constraint: primary_key }
  ouvert_le: timestamp
  serveur_id: int { constraint: foreign_key }
  technicien_id: int { constraint: foreign_key }
}

impacts: "impacts" {
  shape: sql_table
  incident_id: int { constraint: [primary_key; foreign_key] }
  application_id: int { constraint: [primary_key; foreign_key] }
  gravite: varchar
}

applications: "applications" {
  shape: sql_table
  id: int { constraint: primary_key }
  nom: varchar
}

sites -> serveurs: "héberge (0 à N)"
serveurs -> incidents: "subit (0 à N)"
techniciens -> incidents: "traite (0 à N)"
incidents -> impacts: "touche (0 à N)"
applications -> impacts: "est touchée (0 à N)"