From 85db7c5287ae58efc108263f7a40bdbd02de1a82 Mon Sep 17 00:00:00 2001 From: terminaldweller Date: Thu, 21 Jul 2022 10:06:02 +0430 Subject: added docs for the db using schemaspy --- dbdocs/anomalies.html | 263 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 263 insertions(+) create mode 100644 dbdocs/anomalies.html (limited to 'dbdocs/anomalies.html') diff --git a/dbdocs/anomalies.html b/dbdocs/anomalies.html new file mode 100644 index 0000000..e109e30 --- /dev/null +++ b/dbdocs/anomalies.html @@ -0,0 +1,263 @@ + + + + + + spring Database + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ +
+ + +
+ +
+

Anomalies


+
+

Things that might not be 'quite right' about your database and schema

+
+
+ +
+
+
+
+
+

Columns whose name and type imply a relationship to another table's primary key

+
+ + +
+
+
+ + + + + + + + + + + + +
Child ColumnImplied Parent Column
Anomaly not detected
+
+
+
+
+
+
+

Tables without indexes

+
+ + +
+
+
+ + + + + + + + + + + + +
TableRows
Anomaly not detected
+
+
+
+
+
+
+

Tables that contain a single column

+
+ + +
+
+
+ + + + + + + + + + + + +
TableColumn
Anomaly not detected
+
+
+
+
+
+
+

Tables with incrementing column names, potentially indicating denormalization

+
+ + +
+
+
+ + + + + + + + + + + +
Table
Anomaly not detected
+
+
+
+
+
+
+

Columns whose default value is the word 'NULL' or 'null'

+
+ + +
+
+
+ + + + + + + + + + + +
Table
Anomaly not detected
+
+
+
+
+
+
+ + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file -- cgit v1.2.3