Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: derby-commits@db.apache.org
Date: Wed, 31 May 2006 19:19:17 -0000
Message-ID: <20060531191917.4499.12004@ajax.apache.org>
Subject: [Db-derby Wiki] Update of "SystemTables" by MamtaSatoor

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by MamtaSatoor:
http://wiki.apache.org/db-derby/SystemTables

------------------------------------------------------------------------------
  is a foreign key referring to SYSSCHEMAS.SCHEMAID.
  
  SYSCONGLOMERATES has one row for each heap (base table) and index in
- the database. Its primary key is CONGLOMERATEID, which is a
- system-generated value. The TABLEID column is a foreign key referring
- to SYSTABLES.TABLEID. The SCHEMAID column is a foreign key referring
- to SYSSCHEMAS.SCHEMAID. The ISCONSTRAINT column tells whether the row
- represents the backing index for a primary key, foreign key or unique
- constraint.
+ the database. CONGLOMERATEID is a system-generated value. There is no
+ unique key defined on it but it contains unique values for the table.
+ The TABLEID column is a foreign key referring to SYSTABLES.TABLEID. 
+ The SCHEMAID column is a foreign key referring to SYSSCHEMAS.SCHEMAID. 
+ The ISCONSTRAINT column tells whether the row represents the backing 
+ index for a primary key, foreign key or unique constraint.
  
  SYSKEYS has one row for each primary key or unique constraint in the
  database. Its primary key is CONSTRAINTID, which is also a foreign