Author Topic: Database Schema  (Read 4638 times)

hu97224

  • Newbie
  • *
  • Posts: 11
Database Schema
« on: September 18, 2007, 01:23:54 pm »
Here is what I did to reverse engineer the data model.

I downloaded an evaluation copy of the ModelRight2 program, and connected it to the MySQL database from CalemEAM.

The ModelRight program was very easy to use to auto layout the tables, I only need to re-arrange about 5 tables to avoid overlaps.

After I got all the tables showing up correctly, I exported the ER diagram into a JPEG file for later printing.

I configured my plotter with landscape mode, and set to a 24x34 page size, printed the JPEG with fit to page size option.  The final print out was very readable.

I wish I could post the JPEG file here.

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Database Schema
« Reply #1 on: September 18, 2007, 06:48:58 pm »
Installed file attachment mod for phpBB but it didn't work out. The mod was tested with phpBB v2.22, this forum is v2.18.

So I have it uploaded to CalemWiki:
http://www.calemeam.com/apps/wiki/images/b/bb/Calemeam_schema.jpg

Thanks William.

Note: the schema is for Calem Open Source r1.0.2.
Calem Community Forum Admin