Skip to main content

Custom Properties

Attach any key-value pair to a table, column, table group or sticky note (full syntax).

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'
}

Filter by property:

  1. Open the table list: the search icon in the dbdiagram toolbar, or the search box in the dbdocs sidebar.
  2. Click the funnel icon next to the search box.
  3. Click Add filter, pick a key, then pick contains, matches or exists.
  4. Type a value and click Add.