All Questions
Tagged with erd postgresql
20 questions
1
vote
1
answer
684
views
How do you open a *.pgerd file and view the database diagram?
I have a *.pgerd file that I want to open an view the database diagram. What free tools can I use? I also have access to IntellJ Ultimate Edition, so if anyone knows of plugins I can use, this would ...
- 443
1
vote
1
answer
312
views
pgAdmin 4 ... is not present in the table
Hello
Here is my erd and the below my creating table codes;
-- This script was generated by the ERD tool in pgAdmin 4.
-- Please log an issue at https://redmine.postgresql.org/projects/pgadmin4/...
- 13
2
votes
1
answer
157
views
Deleting a row in one table should also delete the corresponding rows in another table
I have these tables: station and water_types. The user may only have one station, and if the user wants to delete the station, the corresponding water_types must also be deleted. In a station, there ...
- 125
2
votes
1
answer
283
views
PostgreSQL partitioned table data model
I have created partition by range based on row_created_tmst for PostgreSQL table. Since partition keys needs to be part of the primary key in PostgreSQL, row_created_tmst is included in the primary ...
- 27
0
votes
1
answer
125
views
Is my database ERD well designed
I'm creating a PostgreSQL database for datasets, which should store historical and future data of weather forecasts and train timetables. I'm wondering if my ERD is good enough for a database which ...
- 1
8
votes
1
answer
4k
views
How do I adjust the table link endpoint in PgAdmin's ERD tool after autogenerating it from an existing database?
I can move the lines themselves around, but I can't move the endpoints, which cause the lines to overlap. The only way to understand which relationship is being referenced is by hovering over the ...
- 181
1
vote
2
answers
455
views
Anonymous and Public User Table Design in twitter like application
I have schema design problem which I am not 100% sure if my assumptions are correct.
So the requirements are:
I need to have 2 different type of user, anonymous and public.
A user can have both ...
- 113
2
votes
1
answer
529
views
Modelling a relationship which has multiple one-to-many parents
I am attempting to model a relationship which could have two parents, one of them being optional, and the other being mandatory. The design should have the following rules,
A House must exist as the ...
- 123
2
votes
1
answer
8k
views
Chat/conversation history, entity relationship diagram
Totally aware that there are very similar questions, went through each of them, but those are pretty simple/basic solutions from where i took some things and ideas to create below entity relationship ...
- 123
1
vote
0
answers
59
views
How to structure SQL data model to maintain data integrity
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
- 111
-1
votes
1
answer
262
views
Database design for 'pay at table' product (integrating with restaurant APIs)
I am doing a database project for Uni and am trying to figure out how a 'Pay at Table' app would work for restaurants. I Have found this example company that does this https://readytopay.com/ but i ...
- 1
1
vote
1
answer
3k
views
Hotel Booking Database design problem
I am currently designing (as an assignment for the course at the university) a database for online booking of hotels worldwide and I have stumbled into a problem.
Here's is the conceptual design:
...
- 13
0
votes
0
answers
1k
views
Building an Entity-Relationship Diagram for a Language Dictionary
I need advice on how to build entity-relationship diagram (ERD) for Language Dictionary. Since I did not build ERD before, I will try to explain and show the ultimate goal of this project below.
...
- 101
-1
votes
1
answer
1k
views
ER diagram to Relational Schema (Many to Many relationship)
In this ER diagram, can anyone explain how we should convert the many to many relationships ('view', 'update' and 'diagnose') to Relational Schema and then SQL? What I think is that there shouldn't be ...
-1
votes
1
answer
960
views
Is there an open source PostgreSQL IDE that allows for model generation? [closed]
I have done quite a lot of SQL Server work where I could use SSMS. Now I'm working with Postgres and I miss the ability to generate models (diagrams) from existing relations (taking into account ...
- 2,410
6
votes
3
answers
5k
views
How to model Parent -> Child -> Grandchild if the Child can be removed
I'm dealing with a set of relationships where the child can be removed, but I obviously don't want to lose the connection between the grandchild and the parent. I did think about marking the child as "...
- 337
6
votes
1
answer
2k
views
Postgres 9.6 export the database structure as pdf [closed]
Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
- 279
3
votes
3
answers
3k
views
Storing historical records and extracting data from a given period
This a question about database modeling and PostgreSQL. This post partially answers the question but I need advice on more technical stuff: columns and query to extract the data.
I need to store ...
- 317
2
votes
2
answers
784
views
How to review Database schema?
I am green been software engineer, my team lead give me a task in PostgreSQL database, I need to determine the relationship of the all 405 tables, but the problem is the database doesn't have any ...
- 123
5
votes
2
answers
12k
views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu) [closed]
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
- 1,185