direction: right

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

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

techniciens: "technicians" {
  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: "hosts (0 to N)"
serveurs -> incidents: "suffers (0 to N)"
techniciens -> incidents: "handles (0 to N)"
incidents -> impacts: "affects (0 to N)"
applications -> impacts: "is affected (0 to N)"