Anyone know of a Yii extension or method for displaying model relations and table schema (including keys and comments) as a flowchart?

Question

I can't seem to find any extension/module/etc that does this nicely.

You can access the column metadata as follows, but I want a good way to display it as a flowchart or hypergraph in a model's index.

$m=new MyModel; 
Yii::log(CVarDumper::dumpAsString($m->tableSchema->columns),'warning');

// echo $m->toJSON(); // uses json behavior, will give this to a js flowchart to show the schema

Sorry, but unfortunately the "Yii" does not possess any extension that manages it yet. — FabianoLothor, Aug 16 '12 at 13:05

score 0 · Answer 1 · answered Oct 24 '12 at 11:39

0

There is one tool in phpmyadmin called designer. its written in PHP and really draw a nice data model from database. you should refer that code.

answered Oct 24 '12 at 11:39

Shiv

1,269
11
20

score 0 · Answer 2 · answered Nov 30 '13 at 06:32

0

Not exactly what you want, but have you had a look at MySQL Workbench yet? Experience with it is somewhat mixed, but I find it great to keep an overview of databases.

answered Nov 30 '13 at 06:32

DaSourcerer

6,288
5
32
55

Anyone know of a Yii extension or method for displaying model relations and table schema (including keys and comments) as a flowchart?

2 Answers2