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

0
Ukończony

how to change a color of a column

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

Any way to break up columns in a table by colors. Need to use that feature to differentiate different phases of projects touching the same table.

+3
W trakcie analizy

Add ability to change color of table outline and it's foreign key references in other table

Daniel Arlitt 10 lat temu Ostatnio zmodyfikowane przez Asim Haque 7 lat temu 4
It would be a useful feature if a user could select a different color outline for certain tables in their diagram that have a lot of foreign keys in other tables, especially when reference lines start to overlap. This would help the user to identify all of the tables that reference the colored table and to easily identify if a foreign key reference is missing.
0
W trakcie analizy

Blog article on dimension types not complete

Mike Christie 7 lat temu Ostatnio zmodyfikowane przez Mariusz Zakrzewski 7 lat temu 1

The article at https://www.vertabelo.com/blog/technical-articles/dimensions-of-dimensions-a-look-at-data-warehousings-most-common-dimensional-table-types is very useful but there are multiple times in the article where content is missing.  For example, under SCD 1 it says this:


"If we look at the data before the change, we’d see this:

If the account type has changed, the data would simply be overwritten:"


However nothing has been added for these two comments so we don't get to see the associated data.


This happens in quite a few places in the article where I'm guessing the writer meant to go back and add images or tables etc but forgot to do it.


Just thought I'd let you know - I'm trying to refresh myself on all things dimensional and have read quite a few of your blog articles and found them very good, but this one disappoints a little in that it is not complete.

0
Z odpowiedzią

You cannot join this account because you are a member of another team account

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

I was invited to a team but i cant because i get this message, "You cannot join this account because you are a member of another team account." Please help

+4
W trakcie analizy

drag field from table to view

Simon Weinstein 10 lat temu Ostatnio zmodyfikowane przez anonymous 7 lat temu 3
when building views it would be helpful to drag elements vs retyping them
0
W trakcie analizy

Shortcut tables for Academic accounts?

Leonard Armstrong 7 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 7 lat temu 1

I have an Academic account but the icon for creating a shortcut table is not shown and CTRL+K does nothing. (Nor can I drag-and-drop from the table list.)  Are shortcut tables disabled on Academic accounts?

0
Ukończony

How do I change Credit Card payment?

David Löwenbrand 10 lat temu Ostatnio zmodyfikowane przez Anya Shokodko 7 lat temu 5
Odpowiedź
Adam Mościcki 8 lat temu

Hello Linda,


Yes, they have changed. New steps are as follows:

1. Click "My Account" on top menu.

2. Click on the "Add billing data" button ("Billing data for your account" section)
3. Enter new credit card info and click "Save"


I hope this helps you.

Best regards,

Adam

0
Ukończony

HSQLDB Database schema generation is not correct...

Khurram Shakir 10 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 7 lat temu 9
I created a sample database diagram for HSQLDB 2.3 , The schema generated in SQL is following for a table,

CREATE TABLE Comments (
Id bigint GENERATED ALWAYS AS IDENTITY NOT NULL CONSTRAINT Comments_Id,
EntityId bigint NULL,
EntityType varchar(100) NOT NULL,
Subject varchar(200) NOT NULL,
CreationDate timestamp NOT NULL,
UserName varchar(200) NOT NULL,
CONSTRAINT Id PRIMARY KEY (Id) );

When I tried to run it on HSQL, it is giving me error that "ID" is duplicate, What I found is Constraint should be named something else otherwise HSQL gives error since it is same as column name, if I renamed that constraint ID instead of ID_PK , it is working fine.

2. Also based on HSQL documentation, Primary key can be defined as simply marking as
Id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY

instead of explicitly define the constraint. please confirm that I am not missing anything and this is bug.
Odpowiedź
Hi, 

I've looked on your model and reproduced  error.  Tables "attachment" and "comments" have the same name of primary key constraint. Primary key constraint name must be unique. Please change the name or "Unset" property. Check other tables also. 

0
W trakcie analizy

Default value of boolean (postgreSQL)

marcOcram 9 lat temu Ostatnio zmodyfikowane przez Grace Selfe 7 lat temu 2
Hello,

I just added a new column of type boolean with a default value of false. This hasn't been added in the create script. true works instead flawlessly.
0
Ukończony

Relationship

Ângelo de Sant'Ana 10 lat temu Ostatnio zmodyfikowane przez anonymous 7 lat temu 2
Did you think about to add relationship table to that modelling tool? It could improve the database representation.