Comments (4)
@Lonzak created by you issue according to point 3 - Exlude Views from Orphaned Tables will be fixed in issue #48
from schemaspy.
Regarding point 4 "missing anomaly - column nullable and must be unique":
This anomaly detection was removed from SchemaSpy before it was forked to this GitHub project.
But it was removed after the latest release of version 5.0.0. So it never went to "production".
So if you use version 5.0.0 you will still see the anomaly in the report.
See this commit on sourceforge:
https://sourceforge.net/p/schemaspy/code/662/
(Actually it was the very last commit dating back to the year 2014 :-) )
It turns out that the "anomaly" of nullable primary keys that must be unique is actually in the SQL standard and isn't an anomaly at all.
from schemaspy.
Hi @Lonzak
SchemaSpy project was improved and most of the missing backward things are available, including:
Fix 1. If you want to see everything on one page please use parameter -nopages
Fix 2. To the main page I added some useful simple statistic about the database/schema. You can see this simple statistic on Sample Output example
Fix 3. Orphan Tables with excluded views was fixed in issue #48
Fix 4. Please read @Riggs333 explanation above and you can go in the initial details here https://sourceforge.net/p/schemaspy/code/662/
Thank you for your contribution to the project and make SchemaSpy better solution !
from schemaspy.
Great work - thanks for your improvements!
from schemaspy.
Related Issues (20)
- SchemaSpy automatically detects only Foreign Keys that reference a Primary Key HOT 7
- marcelstoer:chore/jar-noteAre there any objections to this PR marked as "important"? HOT 1
- Docker: arm image HOT 1
- Moving GUI components
- GUI does not respond to re-sizing HOT 1
- No relationships image created HOT 6
- Too much information in error.
- Sign snapshots
- Cant get line breaks in Table Comments to work. HOT 6
- I am unable to get comments
- Oracle database - null password given HOT 5
- Driver Error HOT 7
- Failed to parse [schema].meta.xml HOT 5
- Terminating null reference error when generating HTML for Constraints MSSQL HOT 1
- SchemaSpy ERD (relationship tab) is not showing lines between tables HOT 4
- Relationship between Unique Keys and Foreign Key HOT 8
- ERROR - Bad config Schema (-s/-schemas) was not provided and unable to deduce schema, ... HOT 2
- Trying to set trustServerCertificate true in schemaspy.connprops Property in config file does not work HOT 2
- Getting an Exception when running against Oracle database in charset ISO-8859-15 HOT 1
- Feature request: "Comment" as title in relationships.html
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from schemaspy.