This is an old revision of the document!

dbtables plugin

Compatible with DokuWiki

>= 2009-12-25

Download

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

By Stephen C / Pontiac76

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>

Table of Contents