I have two tables, both with a column named "id" that is a SERIAL and the primary key of each.

The SQL that is generated creates a constraint to declare the primary key:

CONSTRAINT id PRIMARY KEY (id)

Using the generated SQL, the first table is created successfully.

The second table fails with the following error:

   relation "id" already exists

The constraint name must be unique.

A better solution would be to suffix the primary key column with "PRIMARY KEY".

Alternatively, if you must create a constraint, prefix the name with the table name.

I created and alternate index and alloated a varchar(64) column.

The table has a flagged error stating that the alternate index does not have a column.

I have paid for the subscription but it says the trial period is over while using. Please guide.

Hi,

I found that the GitHub login button was disappeared recently. How should I login to my Vertabelo courses with my GitHub account? I have SQL courses purchased with that account.

Thank you in advance!

After entering a Description under Model Properties and letting the model autosave, the last 1-4 characters in the Description disappear when closing and logging back in to the model. This does not seem to be due to character limits as it occurs at different lengths:

• "Database for XXX XXXX Application" saves as "Database for XXX XXXX Applicatio"
• "XXX XXXX Application Database" becomes "XXX XXXX Application Data"
• "XXX XXXX Database" becomes "XXX XXXX Databas"

Editing something else in the model and saving again does not solve the problem. This is related to the "Model Description" bug I posted a year ago.

It could be very nice to have the opportunity to change font color or other formats (bold, italic,...) for specific fields.

For example I have a large db with a set of columns which repeats in any important table, and I'd like to have these fields/columns greyed out or in different format, just to remember these fields cannot be changed in a single table without breaking a standard

Please help me get my models back. I lost all of my databse models when I converted my account.

Thanks!

Hello,

Is there a solution and/or best practise for marking PII (sensitive) columns in Vertabelo Modelling diagram? 

Thanks in advance. Regards

Is there any way to display the reference attribute(s) on links in a logical datamodel ?
When creating a reference between tables the associated link attribute (role) is not shown in the table layout

Example:  Modelling a Customer table with a CountryOfBrth  role referencing a CountryTable , the CountryOfBirth attribute is not displayed on the diagram ... this is confusing