plugin:dbtables
Table of Contents
DBTables Plugin
Compatible with DokuWiki
Lemming
This extension has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues.
Download and Installation
Search and install the plugin using the Extension Manager. Refer to Plugins on how to install plugins manually.
Download the plugin from here
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: 2023-10-31 00:59 by Klap-in