Domainkey-Signature: a=rsa-sha1; c=nofws;         d=googlegroups.com; 
 s=beta;         h=x-sender:x-apparently-to:received-spf:authentication-results:from
 :to:subject:date:user-agent:mime-version:content-type          
 :content-transfer-encoding:content-disposition:message-id:reply-to        
 :sender:precedence:x-google-loop:mailing-list:list-id:list-post          
 :list-help:list-unsubscribe:x-beenthere-env:x-beenthere;         
 b=sKUXN9AzEXgq93D1b5UmCoskcXV3m3tFDMXyb74uKds4FT609cH/N/2ToSKcAiNE8W      
 o0Do44WWGW8DHzQqhsx4ogl8BVq8PCpIYDIj10qsgMZNP3TyHboAU40/XpJ2zQHt7bEI      
 o4LTFVK2g9wKQ5l9Qjq31Rs1tzjU1+Iq0RW0k=
Received-SPF: neutral (google.com: 75.180.132.122 is neither permitted nor
 denied by best guess record for domain of phma@phma.optus.nu) 
 client-ip=75.180.132.122;
From: Pierre Abbat <phma@phma.optus.nu>
To: lojban-lbck@googlegroups.com
Subject: Database
Date: Wed, 2 Sep 2009 22:49:55 -0400
User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405)
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-ID: <200909022249.57041.phma@phma.optus.nu>
Reply-To: lojban-lbck@googlegroups.com
Sender: lojban-lbck@googlegroups.com
Precedence: bulk
Mailing-List: list lojban-lbck@googlegroups.com; 	contact
 lojban-lbck+owner@googlegroups.com
Content-Length: 1231


Here's a rough draft of the database structure:

table preti (
nacycme int autoincrement;
retygri int foreign key retygri;
jufra text; -- HTML (in case we want to add italics or fonts) in UTF8 (in case 
we want to zoi-quote a foreign word)
danfu1 text; -- HTML in UTF8
danfu2 text;
danfu3 text;
danfu4 text;
danfu5 text;
drani char; -- A through E
jufydrani text; -- for fill-in-blank questions
cunpoi boolean; -- true if the answers should be randomized
);

table retygri (
nacycme int autoincrement;
nilnandu short; -- or real, or maybe several of these
finti int foreign key cipfihi;
zgana int foreign key cipfihi; -- Who reviewed the question group.
jarco_namcu short; -- Number of questions to ask. The number of questions in 
the group you can get by a count query.
jufra text; -- HTML in UTF8; may contain img tags.
);

The number of questions to ask is normally either 1 or the same as the number 
of questions in the group. If it's 1, retygri.jufra is normally empty, but it 
could be not. jarco_namcu=1 with several questions is used for alternative 
versions of a question, such as the same sentence with any of several errors. 
jarco_namcu>1 is used for reading comprehension stories with several 
questions.

Pierre