Here’s a typical way to do this query without using the subquery method you showed. This may satisfy @Godeke’s request to see a join-based solution. SELECT * FROM movies m LEFT OUTER JOIN seen s ON (m.id = s.movie_id AND s.user_id = 123) WHERE s.movie_id IS NULL; However, in most brands of database this solution … Read more
Try DbVisualizer, it works for any database and I particularly like the way it arranges large diagrams. Check the Personal evaluation license.
Doubled shapes can be done by using [peripheries=2] on the node Doubled edges can be done by specifying more than one colour for the edge, separated by a colon. In this case use the same colour twice: [color=”black:black”] (or, to separate them slightly more, do [color=”black:invis:black”]) I got there eventually! Sorry for the “evolutionary” nature … Read more
Weak (Non-Identifying) Relationship Entity is existence-independent of other enties PK of Child doesn’t contain PK component of Parent Entity Strong (Identifying) Relationship Child entity is existence-dependent on parent PK of Child Entity contains PK component of Parent Entity Usually occurs utilizing a composite key for primary key, which means one of this composite key components … Read more
I’ve recently discovered DBeaver. It automatically detects relations between tables in a visual manner. You can move tables around, change colors, see foreign keys, etc. It’s extremely good. Fully compatible with PostgreSQL Querying and manipulating data using the GUI is extremely easy. Not only that you can use it with all major SQL and noSQL … Read more
By changing pocos to: public class Order { public int OrderId { get; set; } public virtual Quotation Quotation { get; set; } } public class Quotation { public int QuotationId { get; set; } public virtual Order Order { get; set; } } and using these mapping files: public class OrderMap : EntityTypeConfiguration<Order> { … Read more
This is a little bit dated question, but for completeness. What about PgModeler? According to their github repo it’s under GPL3. Schema creation works well.
This is a little bit dated question, but for completeness. What about PgModeler? According to their github repo it’s under GPL3. Schema creation works well.
Go to SQL Server Management Studio → Object Explorer → Databases → Choose and expand your database. Under your database, right click on “Database Diagrams” and select “New Database Diagram”. It will a open a new window. Choose tables to include in the ER diagram (to select multiple tables, press Ctrl or Shift key and … Read more
Name similarly targetted stored procs with the same prefix, for instance if you’ve got 3 stored procedures for Person. That way everything for person is grouped in one place and you can find them easily without having to look through all your procs to find them. PersonUpdate PersonDelete PersonCreate Do similar things for tables when … Read more