pyistanbul / dbpatterns Goto Github PK

Actually not work.

dbpattern now supports automatically assigning field types by field name like id is integer, etc.
But more names and types can be supported, such as:

• done, open, closed, canceled, active, is_active: boolean
• amount, total, debit, credit, grand_total, sub_total: currency

(assumed that is_active, isActive and IsActive expressions are identical)

when adding multiple foreign keys from one table to the other, the connection lines(and the text) overlap making it hard to read the connection details.

User will be able to

• add embeded object
• export pattern as json formatted.

Create a table, add two fields, mark both as PRIMARY KEY. Export as Postgres. This is what's generated:

CREATE TABLE a(
  f1 int PRIMARY KEY,
  f2 int PRIMARY KEY
);

This is what's desired:

CREATE TABLE a(
  f1 int,
  f2 int,
  PRIMARY KEY(f1, f2)
);

I would very much like to be able to work on a pattern before it goes into the live system.

Similarly I would like the ability to have private patterns. I would suggest introducing a status to the pattern model. Then a publishing style platform.

p.s. If you were to include a private option, I would pay for this.

It's really unclear that this dot will delete an attribute.
My suggestion is to make it a more obvious icon like a red 'x' for example.

Hi, first sorry for posting this here but, how can I edit my profile or delete it? I want to change my username

Thanks

Import from well formatted sql files will be a useful feature.

Hi.

I was wondering if UUID could be added as Attribute type as it is used on Postgres and Oracle databases.

http://dbpatterns.com/accounts/profile/bockabockablock/
http://dbpatterns.com/documents/5706cbb61514b4252236da53/
Example of a spam user and his database

There should be a way to report users or report certain database designs.

A "notes" feature may be helpful, like in mysql tables "table notes";

There should be a github oauth login.

fixlenecek yerler

1. Yorum kısmı
2. pattern title
3. pattern içerigi

örnek : http://dbpatterns.com/show/5095534c89cbad3c201a78bd

OS: Microsoft Windows [Version 10.0.14372]
SQLite Version: 3.10.1 2016-01-13 21:41:56 254419c36766225ca542ae873ed38255e3fb8588

I had to manually edit FK sections of exported Sqlite script since it throws syntax error.

• I splitted Column and FK definitions
• Moved FK definitions to last lines of table definitions.

Uploaded buggy and fixed scripts as a Gist , Download as Zip with

• Import scripts (bat and shell scripts)
• Original and fixed sql scripts
• With a simple diff file

Example:

I fixed manually changing this section:

CREATE TABLE "Led" (
    "id" int PRIMARY KEY,
    "oda_id" int FOREIGN KEY("oda_id") REFERENCES "Oda" ("id"),
    "status_id" int FOREIGN KEY("status_id") REFERENCES "Status" ("id")
);

To:

CREATE TABLE "Led" (
    "id" int PRIMARY KEY,
    "oda_id" int, 
    "status_id" int,
    FOREIGN KEY("oda_id") REFERENCES "Oda" ("id"),
    FOREIGN KEY("status_id") REFERENCES "Status" ("id")
);

Hi,

If I were to link to dbpatterns with this url: http://dbpatterns.com/accounts/login/?next=//malicious.example.com

Then after logging in you are redirected to malicious.example.com.

currency type exported like field nvarchar,
must be like field numeric(15,2),

When I remove a foreing key reference between two tables, it stays in the diagram.

Web page does not work anymore

Perhaps I'm blind, but it doesn't appear to be possible downloading a schema as SQL? I.e. a list of CREATE TABLE statements.

Oluşturduğun entityleri birbirine bağlayıp kayıt ettikten sonra tekrar görüntülemek istediğimde bağlarının görünmediğini farkettim.

I doesn't seem to be currently possible to delete an attribute once it's been created – I found no shortcut nor button to achieve that. Is it possible and if so how ?

While working on big patterns zoom out feature will be useful.

I try to login using "connect" button for Github. It doesn't work anymore.

Is it just me or is it really broken?

Capturing the entire chart like this http://jsfiddle.net/hasantayyar/AqAE2/2/ will be a cool function.

Please consider adding agree/disagree counters on comments (or some other reaction counter) to limit follow on comments like 👍 and help us build consensus.

The site doesn't have any references to this repository on it at http://dbpatterns.com
Also there are twitter callouts but no official twitter account?

Is it possible to show polymorphic foreign keys of that type, as done by Rails (Ruby) or Laravel (PHP) ?

I'm assuming this is not possible because SQL doesn't have any structure for it but as DBPatterns is more of a "representation" tool to me it'd seem logical to be allow to "show" that, maybe by specifying a list of entities in the foreign key field, like Book,Author or something.

Clicking the Edit Gear icon to edit a doc's settings causes another dialog to popup, but with incomplete properties, as some are added to the original dialog box. Selecting the edit icon multiple times, creates more dialogs with the same issue.