CiviCRM Community Forums (archive)

The page documenting this function links to a Wiki page on the Data Model which doesn't exist. There are also references in civicrm/api/Contact.php to the same page (via objectledge.com - http://wiki.civicrm.org/confluence/display/CRM/Data+Model) where it says the page has been deleted.

I can find an earlier (early 2007) page in Archive.org with this content. It says that it's not current and to consult the ERD until the page is updated.

http://web.archive.org/web/20070402090740/http://wiki.civicrm.org/confluence/display/CRM/Data+Model

Can I help complete this documentation somehow? The deleted Data Model page seems to contain a lot of information which doesn't appear in the ERD.

I have the 2.0 SQL script, and Sybase PowerDesigner 9.5.

I reverse engineered the database, but got no objects, thinking it was probably because the PD only recognizes MySQL up to 3.2.3, so I created a db, then dumped it back out as 3.2.3 compatible and reverse engineered that, but got no objects again.  There are a lot of lines in the Output window that say "skipped", but no reason given as to why.

I can't even get PD to reverse engineer the tutorial file:
"
Reverse Engineering
Reverse engineers the file C:\Program Files\Sybase\PowerDesigner 9\Examples\Tutorial\Pdmbefore.sql...

Lines    8 to    9:  "alter table TITLE" skipped.
Lines    8 to    9:  "   delete foreign key FK_TITLE_TITLE_PUB_PUBLISHE" skipped.
Lines   11 to   12:  "alter table DISCOUNT" skipped.
Lines   11 to   12:  "   delete foreign key FK_DISCOUNT_STORE_DIS_STORE" skipped.
Lines   14 to   15:  "alter table ROYSCHED" skipped.
Lines   14 to   15:  "   delete foreign key FK_ROYSCHED_TITLE_ROY_TITLE" skipped.
Lines   17 to   18:  "alter table SALE" skipped.
Lines   17 to   18:  "   delete foreign key FK_SALE_STORE_SAL_STORE" skipped.
Lines   20 to   21:  "alter table SALE" skipped.
Lines   20 to   21:  "   delete foreign key FK_SALE_SALES_TIT_TITLE" skipped.
Lines   23 to   24:  "alter table PICTURE" skipped.
Lines   23 to   24:  "   delete foreign key FK_PICTURE_AUTHOR_PI_AUTHOR" skipped.
Lines   26 to   27:  "alter table TITLEAUTHOR" skipped.
Lines   26 to   27:  "   delete foreign key FK_TITLEAUT_RELATION__TITLE" skipped.
Lines   29 to   30:  "alter table TITLEAUTHOR" skipped.
Lines   29 to   30:  "   delete foreign key FK_TITLEAUT_RELATION__AUTHOR" skipped.
Lines   32 to   34:  "if exists(select 1 from sys.systable where table_name='AUTHOR' and table_type='BASE') then" skipped.
Lines   32 to   34:  "    drop table AUTHOR" skipped.
Lines   32 to   34:  "end if" skipped.
Lines   36 to   38:  "if exists(select 1 from sys.systable where table_name='DISCOUNT' and table_type='BASE') then" skipped.
Lines   36 to   38:  "    drop table DISCOUNT" skipped.
Lines   36 to   38:  "end if" skipped.
Lines   40 to   42:  "if exists(select 1 from sys.systable where table_name='PICTURE' and table_type='BASE') then" skipped.
Lines   40 to   42:  "    drop table PICTURE" skipped.
Lines   40 to   42:  "end if" skipped.
Lines   44 to   46:  "if exists(select 1 from sys.systable where table_name='PUBLISHER' and table_type='BASE') then" skipped.
Lines   44 to   46:  "    drop table PUBLISHER" skipped.
Lines   44 to   46:  "end if" skipped.
Lines   48 to   50:  "if exists(select 1 from sys.systable where table_name='ROYSCHED' and table_type='BASE') then" skipped.
Lines   48 to   50:  "    drop table ROYSCHED" skipped.
Lines   48 to   50:  "end if" skipped.
Lines   52 to   54:  "if exists(select 1 from sys.systable where table_name='SALE' and table_type='BASE') then" skipped.
Lines   52 to   54:  "    drop table SALE" skipped.
Lines   52 to   54:  "end if" skipped.
Lines   56 to   58:  "if exists(select 1 from sys.systable where table_name='STORE' and table_type='BASE') then" skipped.
Lines   56 to   58:  "    drop table STORE" skipped.
Lines   56 to   58:  "end if" skipped.
Lines   60 to   62:  "if exists(select 1 from sys.systable where table_name='TITLE' and table_type='BASE') then" skipped.
Lines   60 to   62:  "    drop table TITLE" skipped.
Lines   60 to   62:  "end if" skipped.
Lines   64 to   66:  "if exists(select 1 from sys.systable where table_name='TITLEAUTHOR' and table_type='BASE') then" skipped.
Lines   64 to   66:  "    drop table TITLEAUTHOR" skipped.
Lines   64 to   66:  "end if" skipped.
Lines   68 to   70:  "if exists(select 1 from systypes where name='T_ADDRESS') then" skipped.
Lines   68 to   70:  "   drop datatype T_ADDRESS" skipped.
Lines   68 to   70:  "end if" skipped.
Lines   72 to   74:  "if exists(select 1 from systypes where name='T_AMOUNT') then" skipped.
Lines   72 to   74:  "   drop datatype T_AMOUNT" skipped.
Lines   72 to   74:  "end if" skipped.
Lines   76 to   78:  "if exists(select 1 from systypes where name='T_AN_IDENTIFIER') then" skipped.
Lines   76 to   78:  "   drop datatype T_AN_IDENTIFIER" skipped.
Lines   76 to   78:  "end if" skipped.
Lines   80 to   82:  "if exists(select 1 from systypes where name='T_DATE') then" skipped.
Lines   80 to   82:  "   drop datatype T_DATE" skipped.
Lines   80 to   82:  "end if" skipped.
Lines   84 to   86:  "if exists(select 1 from systypes where name='T_IDENTIFIER') then" skipped.
Lines   84 to   86:  "   drop datatype T_IDENTIFIER" skipped.

etc.

"

Google seems to have nothing for PowerDesigner and skipped.

If anyone can suggest anything, I'll provide the ERD as a resource for the community.

Thanks,
Ken