Implementing Generalization & specialization

[Jannik-dev]

Hi, I am quite new to dbml and I was searching for generalization & specialization in the documentation and couldn't find it.

Can you specify it and if so how?

[nguyenalter]

We don't have a corresponding syntax for generalization & specialization concepts. However, you can write the DBML based on these concepts. For example:

  Table person {
    id int [pk]
    role varchar
    name varchar
    email varchar
  }
  
  Table student {
    studentID int [pk]
    intake varchar
    major varchar
    personID int [ref: - person.id]
  }
  
  Table lecturer {
    lecturerID int [pk]
    skill varchar
    qualification varchar
    personID int [ref: - person.id]
  }

Result:

[Jannik-dev]

Thanks for the quick response. I will use that approach