Skip to main content

66 posts tagged with "dbdiagram"

View All Tags

πŸ“ Support Column Note

To help you make your diagrams more descriptive, dbdiagram.io now allows you to add notes into your columns!

Please refer to the syntax below to start adding your notes, then hover on the column fields to see your notes

field_name field_type [note: 'Winter is coming!!!']

column_note

✨ Support Inline References

dbdiagram.io now supports Inline References for foreign keys (Inline Relationships)

Syntax​

field_name type [ref: > other_table.field_name]

Examples​

Table posts {
  id integer [primary key]
  user_id integer [ref: > users.id] // many-to-one
}

// or this
Table users {
  id integer [ref: < posts.user_id, ref: < reviews.user_id] // one to many
}

πŸ”‘ Support unique, primary key, null and not null

😍 Yay! dbdiagram.io now supports unique, primary key, null and not null for columns. Use the syntax below to export your diagrams with the new attributes.

Table users {
  id integer [primary key]
  username varchar [not null, unique]
  full_name type [not null]
  .....
}