Hi,

Oops. TIMESTAMPTZ works, but TIMESTAMPTZ(P) don't.

Thanks for a bug report. Fix will be available with the next production rollout.

Hi,

I though you'll register using @ukr.net email. But OK. I've changed your account to academic.

Hi,

Please sign up and provide your email here. I'll change you plan to academic.

Hi,

It is not possible to delete that user. Please lock his/her account and PM me his/her name I will delete documents.

Hi,

You've closed your account and created new one. You've been warned that your document will be deleted on close. Maybe we should alter this "commercial to academic conversion" message to give more information about the process.

I'm going to find these models. I'll send you them via email.

Hi,

This is by design. We've decided do not show them on the diagram. Unique/alternative keys can be composed using multiple fields, so display them on the diagram may take space and sometimes makes the diagram messy. This a quite old assumption so maybe we should back to the drawing board and rethink it.

Hi,

There is feature that allows you to copy&paste between database models. Please follow these steps:

1. Create a new model and import SQL file.

2. Select tables, and press "Copy" button (or press Control-C)

3. Click on the model name (It's on the left side of the toolbar)

4. Pick "Switch to model" option

5. Select target model

6. Press "Control-V" or "Paste" button

7. Done

Copy&paste between models works in the same browser tab only. That's why switching between models should be performed this way.

If you interested in other keyboard shortcuts press "Control-I".

Hi,

Yes you can. We call them "migration scripts".

Here are steps to generate migration script:

1. Sign in

2. Right click on the database model and pick "Model details" option (the last one)

3.On "details" screen click "Generate migration SQL" link (on the right site panel)

4. You'll see the migration tool. Here you can pick a source model and target model or version.

5. Click "Generate"

6. You'll get migration script + warnings.

Hope it help. If you have any questions please do not hesitate to contact us.