New Feature: Support Multiple Schemas 🗂

News from dbx
1

Hi folks,

Just want to share with you an exciting new feature: Multiple Schemas!

Support for Multiple Schemas :card_index_dividers:

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 {
  ...
}

cross-schema-relationship
cross-schema-relationship985×407 21.7 KB

For more DBML syntax updates, please check out our docs!

From dbdiagram team w/ :heart:

2

Is there any way to add notes to schema?

1 Like
3

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

4

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…

5

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