Render database schemas in Dokuwiki format. Useful for DB Dev'rs
Compatible with DokuWiki
>= 2009-12-25
Render database schemas in Dokuwiki format. Useful for DB Dev'rs
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
<dbtables {options}>
.
.
.
</dbtables>
<dbtables groups=4;cols=4;c1=Col1;c2=Col2;c3=Col3;c4=Col4;fdelim=:;thead=_>
| 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.
<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>
<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>