er diagram.txt

// use https://dbdiagram.io/d

Table role {
  name varchar
  team varchar
  group varchar
  color varchar
  descr varchar
}

Table game {
  mid int
  map varchar
  duration float
  date date
}

Table player {
  name varchar
}

Table buys {
  mid int [ref: > game.mid]
  player varcher [ref: > player.name]
  item varchar
  time time
  role varchar
}

Table loves {
  mid int [ref: > game.mid]
  first varchar [ref: > player.name]
  second varchar [ref: > player.name]
}

Table participates {
  mid int [ref: > game.mid]
  player varchar [ref: > player.name]
  startrole varchar [ref: > role.name]
  won boolean
}

Table rolechange {
  mid int [ref: > game.mid]
  player varchar [ref: > player.name]
  fromrole varchar [ref: > role.name]
  torole varchar [ref: > role.name]
  time time
}

Table damages {
  mid int [ref: > game.mid]
  player varchar [ref: > player.name]
  vktrole varchar [ref: > role.name]
  reason enum
  causee varchar [ref: > player.name]
  atkrole varchar [ref: > role.name]
  weapon optional[varchar]
  damage int
  teamdmg boolean
}

Table dies {
  mid int [ref: > game.mid]
  player varchar [ref: > player.name]
  vktrole varchar [ref: > role.name]
  reason enum
  causee varchar [ref: > player.name]
  atkrole varchar [ref: > role.name]
  weapon optional[varchar]
  time time
}

TABLE karma {
  mid int [ref: > game.mid]
  player varchar [ref: > player.name]
  karma int
  time time
}

TABLE mediumchat {
  mid int [ref: > game.mid]
  msg varchar
}

Table configs {
  filename varchar
}