Return-Path: Delivered-To: apmail-continuum-dev-archive@www.apache.org Received: (qmail 33003 invoked from network); 18 Dec 2008 01:29:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Dec 2008 01:29:54 -0000 Received: (qmail 42985 invoked by uid 500); 18 Dec 2008 01:30:06 -0000 Delivered-To: apmail-continuum-dev-archive@continuum.apache.org Received: (qmail 42957 invoked by uid 500); 18 Dec 2008 01:30:06 -0000 Mailing-List: contact dev-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list dev@continuum.apache.org Received: (qmail 42946 invoked by uid 99); 18 Dec 2008 01:30:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Dec 2008 17:30:05 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of wsmoak@gmail.com designates 64.233.170.190 as permitted sender) Received: from [64.233.170.190] (HELO rn-out-0910.google.com) (64.233.170.190) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Dec 2008 01:29:45 +0000 Received: by rn-out-0910.google.com with SMTP id k50so278757rnd.3 for ; Wed, 17 Dec 2008 17:29:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=RdGm5Haw7uaFTSzeup9CT90aqjbKXbH9AzG0uS2E5fw=; b=vHN6ZzRhO6gQ7gqmQjn5lvzyaJbaW/WHIay+6FUBS9IETi4kvmLEtB4UjAcGVqjKwx oO03yWu1zKlkqWUy6vmo8HFLN1TTl+BjkjZ1gPjHUvv5okiw+PPfdRjJngTGyVHPb0UG 8d12aOzf0ykQ+GPyXXg3Vq9/BjnfDe2EhhEoU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=KinP4ElO81RMsb9IiWaS7AnZWtJ5oyPaEXkG6eZoGCp8EBrppu49kDBkzjnk1ufBTw 3IcaTe8qrNhRN24jw9aRK/xLXVV26RF/du2SlqrNw1xtQOaRvZuxbNmGGWBMG7AiQEmf 5oGJqytCfmxn1/s3nYQYHCBtZgBpM6Br1w/tQ= Received: by 10.150.192.4 with SMTP id p4mr2398335ybf.243.1229563763800; Wed, 17 Dec 2008 17:29:23 -0800 (PST) Received: by 10.150.198.5 with HTTP; Wed, 17 Dec 2008 17:29:23 -0800 (PST) Message-ID: Date: Wed, 17 Dec 2008 18:29:23 -0700 From: "Wendy Smoak" To: dev@continuum.apache.org Subject: SchemaSpy for Continuum MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org I met the author of SchemaSpy at a conference recently, and tried it out on the database from Continuum 1.2.2: http://wsmoak.net/continuum/1.2.2/schemaspy/SA/index.html There you can see the list of tables. Choose one of them to see the details, then scroll down a bit and you'll see a diagram of the relationships it has with other tables. There is more info on the other tabs. The SchemaSpy site is here: http://schemaspy.sourceforge.net/ . If you want to try it, this is the command I used: java -jar /Applications/schemaspy-4.1.1/schemaSpy_4.1.1.jar -t derby -db $CONTINUUM_HOME/data/databases/continuum -u sa -o /tmp/schemaspy-continuum-1.2.2 -dp $CONTINUUM_HOME/lib/derby-10.1.3.1.jar -schemas SA Enjoy! -- Wendy