Hi folks,
Just want to share with you an exciting new feature: Multiple Schemas!
Support for Multiple Schemas
Previously you could only define the table names, then every table falls into the default โpublicโ schema.
Now, you can define the tables with full schema names:
Table ecommerce.order_items {
...
}
Moreover, you can make cross-schemas relationships and use enums from different schemas:
Table orders {
id int [pk, ref: < ecommerce.order_items.order_id]
status core.order_status
...
}
Enum core.order_status {
...
}
For more DBML syntax updates, please check out our docs!
From dbdiagram team w/ ![:heart: :heart:](https://community.dbdiagram.io/images/emoji/apple/heart.png?v=12)
Is there any way to add notes to schema?
1 Like
Hi Jehwan Ryu,
I am Huy from the dbdiagram team.
You might currently add the notes at the Project/Schema level using the syntax described in this documentation: DBML - Full Syntax Docs | DBML
I hope this was useful.
Best Regards
Huy Phung
Iโm aware of that, but itโs project notes, not schema notes. I want the notes to appear when I click the schema in the dbdocs. Seems like it is not supported yetโฆ
Hi Jehwan Ryu,
Thank you for your feedback.
Yes, we do not support it at the moment. We took note of your suggestion, and we will think about it. It would be a great addition to our product.
Best Regards
Huy Phung
1 Like