From phma@webjockey.net Thu May 02 17:29:05 2002 Return-Path: X-Sender: phma@ixazon.dynip.com X-Apparently-To: lojban@yahoogroups.com Received: (EGP: mail-8_0_3_1); 3 May 2002 00:29:05 -0000 Received: (qmail 22738 invoked from network); 3 May 2002 00:29:04 -0000 Received: from unknown (66.218.66.217) by m14.grp.scd.yahoo.com with QMQP; 3 May 2002 00:29:04 -0000 Received: from unknown (HELO neofelis.ixazon.lan) (208.150.110.21) by mta2.grp.scd.yahoo.com with SMTP; 3 May 2002 00:29:04 -0000 Received: by neofelis.ixazon.lan (Postfix, from userid 500) id 9052D3C476; Thu, 2 May 2002 20:29:01 -0400 (EDT) Content-Type: text/plain; charset="utf-8" To: lojban@yahoogroups.com Subject: Re: [lojban] dictionary editing system (was: Lojban dictionary in TEI) Date: Thu, 2 May 2002 20:28:59 -0400 X-Mailer: KMail [version 1.2] References: In-Reply-To: X-Spamtrap: fesmri@ixazon.dynip.com MIME-Version: 1.0 Message-Id: <02050220285908.01738@neofelis> Content-Transfer-Encoding: 8bit Sender: phma@ixazon.dynip.com From: Pierre Abbat X-Yahoo-Group-Post: member; u=92712300 On Thursday 02 May 2002 14:42, Jay Kominek wrote: > I've attached a copy of the PostgreSQL tables I'd come up when working on > this. Please add some comments on the fields. I've been spending some months programming databases, so I can read SQL right off, but I'm not sure what, for example, words.added is. For the language fields, can you make a table of names of languages and replace the varchar with an int foreign key to the language table? phma