Your feedback is highly appreciated! Let's make Vertabelo even better.
Make column recognition in view work if referencing a manually defined schema
Can't get column recognition to work if a insert a SQL query in a view's SQL field and refer to tables or views in other schemas. E.g.: If a insert this query in a view's SQL field, the columns get recognized automatically -
select id from some_table
- but if I do this, the parser shows an error message:
select id from some_schema.some_table
Even though some_table has "some_schema" set as it's schema.
Is there a way to get this to work or is it simply a bug/only partly implemented feature?
Hello,
Sorry for a late response. We have missed that one.
I think it is a partially implemented feature and works only for `schemaless` views.
Best regards,
Adam Mościcki
what is the relationship between patients table and diagnosis table .and what do you suggest for file ID for each patient .how can i draw tables and relations between these , please help me ?
I am doing a Database for Emergency dept in the hospital
Hello
If you ask us how to design database, sorry, we do not provide consulting services.
We have explained 'how to use our tool' in our documentation:
http://www.vertabelo.com/documentation
and blog articles:
http://www.vertabelo.com/blog/technical-articles/database-modeling-course-entities-and-attributes
I recommend the first one with hospital related example:
Hope this helps.
Adam Mościcki
Team name
I am a member of different teams. I would welcome a feature when I can give a name or nickname to the team. The name can then be shown in top, black bar between label Halp and user icon. That would help me to see current team.
User died. Need to re-assign ownership's and delete account
User died, was owner of a document. Need to delete document he owned (already copied to new owner) and delete his account so we can add a new user (we are at our max user limit). I can't seem to do anything as administrator but lock his account.
Account missing
I had an account with email: imrankhanamardan@gmail.com. Now when I enter my credentials it says "We don't have an account with the email address you have provided." Can someone please help me with that?
Joining a team cancelled my Prenium acount
I was recently added to a team because someone wanted to share a database model with me. But by joining the team, this cancelled my prenium account. I want to go back to my prenium account and leave the team. How can I do this?
Duplicate a Table
It would be really handy to have an option to 'duplicate' a table on a diagram when you are trying to create a table with a very similar set of columns. Possibly add it to drop down menu when you choose a Model/Table and have it append '_copy' to duplicated table name.
Add missing postgresql column types
Trying to import an existing DB structure from PostgreSQL and the importer says that a number of columns are unsupported. Currently I've found TIMESTAMPTZ and TSTZRANGE (and it looks like none of the range types are recognised).
TIMESTAMPTZ seems to work within the editor, but trying to import from an SQL file that includes a column of that type fails and the rest of the table definition is ignored.
Customer support service by UserEcho