[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Database
- To: lojban-lbck@googlegroups.com
- Subject: Database
- From: Pierre Abbat <phma@phma.optus.nu>
- Date: Wed, 2 Sep 2009 22:49:55 -0400
- Authentication-results: gmr-mx.google.com; spf=neutral (google.com: 75.180.132.122 is neither permitted nor denied by best guess record for domain of phma@phma.optus.nu) smtp.mail=phma@phma.optus.nu
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=beta; h=domainkey-signature:received:received:x-sender:x-apparently-to :received:received:received:received-spf:received:received: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; bh=SZDey1v2+RjbyQ9bKLDF+/lrM0tHuRDZ8iCGDHobylg=; b=LnVMYZ/nxmc6+bDlWwe5wfTUrL2czH5ilyiPnrUWu8blPNQX4W+KBcMc77dTBOJp5c Qr1+dVhh143z+ErLT2yFH7gCw/4J2spfzYVNbIxQq3wEHTN0g1NLQZQpmCgG9ip9jaQ9 Lzpntu7mNfPmSmEEbsAqKeUAkjSSjcZvv2R2E=
- 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=
- List-help: <mailto:lojban-lbck+help@googlegroups.com>
- List-id: <lojban-lbck.googlegroups.com>
- List-post: <mailto:lojban-lbck@googlegroups.com>
- List-unsubscribe: <http://googlegroups.com/group/lojban-lbck/subscribe>, <mailto:lojban-lbck+unsubscribe@googlegroups.com>
- Mailing-list: list lojban-lbck@googlegroups.com; contact lojban-lbck+owner@googlegroups.com
- Reply-to: lojban-lbck@googlegroups.com
- Sender: lojban-lbck@googlegroups.com
- User-agent: KMail/1.9.6 (enterprise 0.20070907.709405)
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