Your feedback is highly appreciated! Let's make Vertabelo even better.

0

is there a way to add audit columns to every table in a data model?

Alan Nitikman 7 lat temu zaktualizowano 7 lat temu 2

Standard Audit Columns must be added, in the Physical Data Model, to every table in the data model.  These would include the usual -- CreateUserid, CreateTimestamp, UpdateUserid, UpdateTimestamp, LoadID, BatchID, etc. I avoid these in the LDM, as it's irrelevant to the documentation of business requirements.


With other tools I've used in the past, this was generally handled in a macro, or otherwise automated in some way. I don't see any way, in Vertabelo, to add a standard set of attributes/columns to more than one table at a time.  Is there such a feature?  For a large data model, this can be a significant amount of busy work.

0

LONGBLOB

Maciej Dybała 7 lat temu 0

I am using  

Thanks!


-1
W trakcie analizy

Oops we've got a problem. Something went wrong

Ebrahim Cassim 7 lat temu Ostatnio zmodyfikowane przez Ali Asgari 7 lat temu 10

I KEEP GETTING THIS ERROR ON CHROME "Oops we've got a problem. Something went wrong" , I have re-installed Chrome and tried Chromium but in both it gives this problem..what do i do?

0
W trakcie analizy

DROP DDL statements are not hierarchical

Alan Nitikman 7 lat temu zaktualizowano 7 lat temu 3

How come your generated 'DROP' DDL statements are not in the right sequence?  Constraints must be dropped first, then the tables. Child Table first, then Parent table. It should be intelligent enough to build the DDL correctly, based on hierarchy.

0

Are you aware, that Vertabelo is currently down?

Matthias Brenner 7 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 7 lat temu 1

At the moment I get the message 503, service unavailable

0
To nie jest błąd

Exclude comments in SQL

Varmo Pilt 7 lat temu zaktualizowano 7 lat temu 2

I don't check the Include comments for database objects option, but generated SQL includes comments.

0
Z odpowiedzią

Need to remove users

Eugene Vais 8 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 7 lat temu 3

Hello,I have 3 users that I need to completely remove from the account. While I am able to lock them, I am not able to remove them. The Delete button is not enabled since some documents are shared with them. Please help with this.

Odpowiedź

Hi,


That ticket is private now. Here is an instruction:


Please do the following steps:
1. Please log in
2. Open https://my.vertabelo.com/company-account/documents - this is a page showing all documents in the team.
3. Select user that you want to delete in the top left select field.
4. For each document where he is an owner please remove it or take access of it.
5. Remove user.


Hope it helps.

0
Ukończony

Is there any way to automatically Normalized database architecture to denormalized database architecture ?

Ashok Pradhan 7 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 7 lat temu 2

Please suggest me.

Odpowiedź
Adam Mościcki 7 lat temu

Hello,


Right now, Vertabelo doesn't provide any (de)normalization utilities.


Best regards,

Adam Mościcki

+4

Add Materialized View option

marcOcram 9 lat temu Ostatnio zmodyfikowane przez Marcin Szuppe 7 lat temu 1

Hello,


I'm currently using PostgreSQL 9.4 as my DBMS and I would like to use the concept of materialized views (>= PostgreSQL 9.3). As there's no option to convert a view into a materialized view which I can fire as an after create statement, my only way to add a materialized view is to copy the created sql code, drop the view as an after create statement and create the exact same view as a materialized view.


So I'm suggesting a new view in form of a materialized view or some option to make a view materialized. This would be very helpful (at least for me).

0
Z odpowiedzią

Where can I designate "NOT NULL" for Postgres?

Matthew Weber 7 lat temu Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 7 lat temu 1

How can I define a field as NOT NULL within the UI? In particular I am using Postgres