DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:dbtables

DBTables Plugin

Compatible with DokuWiki

>= 2009-12-25

plugin Render database schemas in DokuWiki format. Useful for DB Dev'rs.

Last updated on
2010-09-29
Provides
Helper, Render

This extension has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues.

Tagged with data, database, tables

Download and Installation

Download and install the plugin using the Plugin Manager using the URL given above. Refer to Plugins on how to install plugins manually.

Download the plugin from here - Copy/Paste URL into UPLOAD in the Plugin Manager

Demo here

Syntax and Usage

<dbtables {options}>
.
.
.
</dbtables>
<dbtables groups=4;cols=4;c1=Col1;c2=Col2;c3=Col3;c4=Col4;fdelim=:;thead=_>

Options

Option Description Default
groups How many horizontal DW-tables are displayed 4
cols How many columns per DW-table are rendered 4
c{#} Name of DW-table field, where # the field number c1=Field;c2=Type;c3=Relation;c4=Desc
fdelim Field Delimeter - Character representing how each DW-DB field is seperated :
thead Table Heading - Character representing the line in which a table name is defined _ {Underscore}
twidth Width of the HTML table Undefined - Dokuwiki decides
nosort When assigned any value, does not sort the table names. Sorting happens by default. Undefined
norender Outputs the DW-tables in Dokuwiki text format Undefined

Note that with twidth, nosort, and norender, you must assign some sort of value, for example, norender=1.

Examples

Example #1

<dbtables>
Table1
TableID:int:PK:ID of Table
TableName:varchar(50)

Table2
TableID:int:PK
TableParent:int:FK->Table1.TableID
TableDesc:varchar(50)::Description of Table:You won't see this rendered if cols=4

Table3
TableID:int:PK
Table4
TableID:int:PK
Table5
TableID:int:PK
Table6
TableID:int:PK
</dbtables>

Example #2

<dbtables groups=2;cols=3;c1=Field;c2=Type;c3=Desc;twidth=95%>
_Customers
CustomerID:int:Primary Key
FirstName:varchar(50)
LastName:varchar(50)
Address:text:Populated via TEXTAREA

_Orders
OrderID:int:Primary Key
CustomerID:int:FK->Customers.CustomerID
DateSumbitted:datetime
DateFilled:datetime
DateShipped:datetime
Shipper:varchar(50)

_OrderDetails
OrderID:int:FK->Orders.OrderID
ProductID:int:FK->Products.ProductID
Units:int
Price:money

_Products
ProductID:int:Primary Key
Name:varchar(50)
VolumeInStock:int
CurrentPrice:money
Photo:blob
Description:text

</dbtables>
plugin/dbtables.txt · Last modified: 2015-08-07 09:45 by 109.164.205.82