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

0
Voltooid

Logical model: How to establish a one to many relationship between 2 entities?

Claire Frankel 6 jaar geleden bijgewerkt door Derek Emrie 6 jaar geleden 2

In a logical model of a data warehouse, how do you draw a one-to-many relationship between 2 entities in vertabelo.???

Antwoord
Adam Mościcki 6 jaar geleden

Hello,

1. Please select "add one to many relationship" in the toolbar.

2. Start dragging from "one" table.

3. Stop dragging on "many" table.

Image explanation:

Result:

Hope this helps,
Adam

0
Beantwoord

Change database

Ken Gillett 11 jaar geleden bijgewerkt door dominic 6 jaar geleden 3
Once a model has been created based on a specified database, how can you then change it to use a different database?

Looks to me like you cannot, which is rather limiting and major headache if you've spent a long time developing it and then find you have to use a different database,
Antwoord
anonymous 11 jaar geleden
You can do it this way:
1. export existing model as XML,
2. create a new model in the DB of your choice with this XML as a starting point. You can upload it in "From Vertabelo XML" tab.

After this operation, remember to recheck all "Additional Properties" of tables, columns etc. you've set (if any), since different DBs have a different set of those additional properties.

I hope this helps.
0
Voltooid

Is there a way to copy the entire model and have it open up on another page, so that I can make a "version 2" of the model ?

Claire Frankel 6 jaar geleden bijgewerkt door Adam Mościcki 6 jaar geleden 1

Is there a way to copy the entire model and have it open up on another page, so that I can make a "version 2" of the model ?

thank you in advance for your response. 

Cheers,

Claire Frankel

0
Voltooid

Never mind (how to copy). I found it ! Claire Frankel

Claire Frankel 6 jaar geleden bijgewerkt door Adam Mościcki 6 jaar geleden 1

Never mind (how to copy an entire model) I found it ! 

Cheers,

Claire Frankel

0
Voltooid

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT

Claire Frankel 6 jaar geleden bijgewerkt door Adam Mościcki 6 jaar geleden 1

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT ?

claire.frankel@warbyparker.com

Antwoord
Adam Mościcki 6 jaar geleden

Hello Claire,

Please:

1. Choose the 'add reference' tool.

2. Start dragging from a DIM table.

3. Drop mouse on a FACT table.

Hope this helps,

Adam

+11
Under review

Teradata database engine

Nosheen Iqbal 9 jaar geleden bijgewerkt door Susan Mayer 6 jaar geleden 2

Do you plan to add Teradata database?

0

Functions

Jussi Kinnula 8 jaar geleden bijgewerkt door Susan Mayer 6 jaar geleden 0

It would be nice to define functions as separate blocks in the diagram. Now I'm using "Additional SQL scripts" section in relevant tables to define functions, but since functions can consist of many views or tables it would be nice to separate them.

0
Beantwoord

Vertabelo Reverse Engineering Tool doesn't extract databases

Mariusz M 11 jaar geleden bijgewerkt door kate Winfield 6 jaar geleden 9
Why Vertabelo Reverse Engineering Tool extracts tables only from master system database in MSSQL Express?
0
Beantwoord

does not recognize my email

jeffreyjohnson11 6 jaar geleden bijgewerkt door Adam Mościcki 6 jaar geleden 1

I created an account a year ago for the beginner SQL course. I tried to go back to the course today but Vertabelo is claiming that the email associated with my account does not exist. I have the receipt from my purchase on my email account. How would I go about recovering my account? Thank you. 

0
Fixed

SQLite Autoincrement

Javier Tejedor 9 jaar geleden bijgewerkt door hepeyowa 6 jaar geleden 3

Hello, I have exported the SQL for a SQLite Database. In the tables, I have PRIMARY_KEY and AUTOINCREMENT.


CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL AUTOINCREMENT,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

Using this format, SQLite is throwing an error due the AUTOINCREMENT is not declared as PRIMARY KEY yet (it is being done in the CONSTRAINT). I am using the java sqlite-jdbc-3.8.11.2.jar driver from org.xerial


SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)


A possible correct syntax (regarding to the SQLite documentation https://www.sqlite.org/autoinc.html ) for the previous example would be:


CREATE TABLE CSS_AT_RULES (	
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT,	
    css_version varchar(10) NOT NULL,	
    syntax_id integer NOT NULL
);

Could you please confirm if I am right?


Regards,

Javier.

Antwoord
anonymous 9 jaar geleden

Hello,

Yes, it is a bug.
I think, the correct syntax is (as sqlite's faq mentions https://www.sqlite.org/faq.html#q1):

CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

If column has type 'integer' and 'primary key' then has also 'autoincrement'.

In this case, the fastes solution is to unset an autoincrement option.


I hope this helps.