direction: right

avant: "incident_log" {
  shape: sql_table
  num_incident: int
  serveur: varchar
  site: varchar
  ville_site: varchar
  applications: "varchar (list)"
  technicien: varchar
  equipe: varchar
}

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

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

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

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

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

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

avant -> incidents: "2NF then 3NF"
avant -> impacts: "1NF then 2NF"
avant -> applications: "1NF"
avant -> serveurs: "3NF"
avant -> sites: "3NF"
avant -> techniciens: "3NF"