Hello,

Right now, there is no way to convert physical models to logical.
I can't think of any way to convert a physical model to logical with ease.

Best regards,
Adam

Hello,

You have signed up as a normal user. Please delete your account and create it as academic again. Here is an instruction:

https://support.vertabelo.com/pl/knowledge-bases/2/articles/298-how-do-i-convert-my-account-to-academic

Best regards,

Adam

Hello Rob,

You have set the same primary key name for two different tables. 
If you leave a primary key's name empty, the constraint name will be automatically generated.
An example here:

Hope this helps,
Adam

Hello,

This is an intended behavior. In fact, the "Default Value" property can be many things, i.e.:
- a constant, like FALSE, which indeed has to be quoted
- an expression like, nextval('sequence') which can't be quoted

Therefore we decided to not quote this property.

Hope this helps,
Adam

Hello,

Indeed, the UI can be misleading.
Please click on the "+Add" button.

Best regards,
Adam

I have answered in the private topic.

Hello Scott,

Thank you for detailed description. We have managed to reproduce the error.

We will fix it ASAP.

Sorry for the inconvenience caused.

Adam

Hello,

However, if you want to color columns in someway it is not possible right now. We have it on our roadmap. Estimated delivery time is unknown yet.

In terms of best designing practices, I can only forward you to our articles:
https://vertabelo.com/blog/how-to-store-authentication-data-in-a-database-part-1/

https://vertabelo.com/blog/security-approaches-in-data-modeling-part-2-handling-sensitive-data-in-your-data-modeling/

Hope this helps,

Adam