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/tables/doc.html | 267 +++++++++++++++++++++++++++++++++++++++++++++++++ dbdocs/tables/table.js | 85 ++++++++++++++++ 2 files changed, 352 insertions(+) create mode 100644 dbdocs/tables/doc.html create mode 100644 dbdocs/tables/table.js (limited to 'dbdocs/tables') diff --git a/dbdocs/tables/doc.html b/dbdocs/tables/doc.html new file mode 100644 index 0000000..db9ab04 --- /dev/null +++ b/dbdocs/tables/doc.html @@ -0,0 +1,267 @@ + + + + + + doc - spring Database + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ +
+ + +
+ +
+

doc

2 rows


+
+ +
+
+
+ +

Columns

+
+ + +
+
+
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint819null + +
+
+ +
+
bodyvarchar10000null + +
+
+ +
+
last_modifiedint819null + +
+
+ +
+
namevarchar255null + +
+
+ +
+
+
+
+
+
+ +

Indexes

+
+ + +
+
+
+ + + + + + + + + + + + + + + + + +
Constraint NameTypeSortColumn(s)
doc_pkeyPrimary keyAscid
+
+
+
+ +

Diagram producer might be missing

+

No diagrams were produced please see application output for any errors

+
+
+ +
+ + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/dbdocs/tables/table.js b/dbdocs/tables/table.js new file mode 100644 index 0000000..a07a96e --- /dev/null +++ b/dbdocs/tables/table.js @@ -0,0 +1,85 @@ +$(document).ready(function() { + anchors.options.visible = 'always'; + anchors.add('h3'); + + var table = $('#standard_table').DataTable( { + lengthChange: false, + ordering: false, + paging: config.pagination, + autoWidth: true, + buttons: [ + { + text: 'Related columns', + action: function ( e, dt, node, config ) { + $(".relatedKey").toggle(); + this.active( !this.active() ); + table.columns.adjust().draw(); + } + }, + { + text: 'Constraint', + action: function ( e, dt, node, config ) { + $(".constraint").toggle(); + this.active( !this.active() ); + table.columns.adjust().draw(); + } + }, + { + extend: 'columnsToggle', + columns: '.toggle' + } + ] + + } ); + dataTableExportButtons(table); + + if ($('#indexes_table').length) { + var indexes = $('#indexes_table').DataTable({ + lengthChange: false, + paging: config.pagination, + ordering: false + }); + dataTableExportButtons(indexes); + } + + if ($('#check_table').length) { + var check = $('#check_table').DataTable( { + lengthChange: false, + paging: config.pagination, + ordering: false + } ); + dataTableExportButtons(check); + } +} ); + + +$(function() { + var $imgs = $('img.diagram, object.diagram'); + $imgs.css("cursor", "move") + $imgs.draggable(); +}); + +$.fn.digits = function(){ + return this.each(function(){ + $(this).text( $(this).text().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "1 ") ); + }) +} + +$(function() { + $("#recordNumber").digits(); +}); + +var codeElement = document.getElementById("sql-script-codemirror"); +var editor = null; +if (null != codeElement) { + editor = CodeMirror.fromTextArea(codeElement, { + lineNumbers: true, + mode: 'text/x-sql', + indentWithTabs: true, + smartIndent: true, + lineNumbers: true, + matchBrackets: true, + autofocus: true, + readOnly: true + }); +} -- cgit v1.2.3