3 Tables
BlubbFish edited this page 2024-08-29 00:11:58 +02:00

Willkommen im Wiki. Docs: https://dbml.dbdiagram.io/docs

Table orgs {
  pk uuid [pk]
  id int
  name varchar 
  parent uuid [ref: < orgs.pk]
}

Table issi {
  pk uuid [pk]
  id int
  name varchar
  org uuid [ref: > orgs.pk]
}

Table gissi {
  pk uuid [pk]
  id int
  name varchar
  org uuid [ref: > orgs.pk]
}

Table device {
  pk uuid [pk]
  tai int
  key int
  issi int [ref: - issi.pk]
  device enum
}

Table prefix_issi {
  pk uuid [pk]
  name varchar
  from int [note: 'Issi start']
  size int [note: 'Content of the post']
}

Table tenant {
  pk uuid [pk]
}

https://dbdiagram.io/d