We’re happy to announce that DBML now supports custom properties: you can add key-value pairs to your tables and columns.
Use them to record who owns a table, which fields hold personal data, or anything else your team tracks.
Write them inline in the settings list, or in a separate Metadata block:
Table users [owner: "identity-team", pii: "true"] {
id int [pk]
email varchar [classification: "confidential"]
}
// or keep the properties apart from the schema
Metadata Column users.email {
masking: 'partial'
}
What’s new:
- Any key you need, on tables, columns and table groups: owner, classification, retention, SLA, etc.
- Properties live in your DBML, so git versions them with the schema and your own scripts can read them.
- Filter tables and fields by key and value in dbdiagram and dbdocs, matching the whole value or just part of it.
- Read them in place: properties show up in the diagram view and in your dbdocs database doc, so whoever is reading the schema sees them without opening another tool.
Note: Custom properties are available on all plans.
Learn more →Please give this feature a try and let us know what you think.
From dbx team with 