--- Begin Message ---
Subject: |
Returned mail: see transcript for details |
Date: |
Fri, 28 Mar 2003 20:03:36 -0600 |
The original message was received at Fri, 28 Mar 2003 20:01:31 -0600
from hornbeck [127.0.0.1]
----- The following addresses had permanent fatal errors -----
<address@hidden>
----- Transcript of session follows -----
... while talking to mx10.gnu.org.:
>>> STARTTLS
<<< 421 monty-python.gnu.org: SMTP command timeout - closing connection
554 5.3.5 deliver: mci=814a7d4 rcode=0 errno=0 state=0
sig=mx10.gnu.org.:mx20.gnu.org.:mx30.gnu.org.
554 5.3.0 Internal error
Reporting-MTA: dns; localhost.localdomain
Received-From-MTA: DNS; hornbeck
Arrival-Date: Fri, 28 Mar 2003 20:01:31 -0600
Final-Recipient: RFC822; firefly-dev@nongnu.org
Action: failed
Status: 5.5.0
Last-Attempt-Date: Fri, 28 Mar 2003 20:03:35 -0600
--- Begin Message ---
Subject: |
Re: [Firefly-dev] Database |
Date: |
28 Mar 2003 20:01:31 -0600 |
Man that is nice. I will have some more time to look it all over this
weekend. I am running around right now doing arrends and just stopped
home to check mail. I will write more later. Looks good though. What
program is that?
John Hornbeck
On Fri, 2003-03-28 at 15:28, address@hidden wrote:
> Hi,
> since relic.net seems to be always down and I'm waiting savannah for a
> cvs member access, I'll post here some considerations about the db.
>
> I've done a first draft of the db design, please note that
> this is still very inaccurate and incomplete, because before go on I
> would like to hear your comments. You can find an image here:
> http://ryudo.altervista.org/db.png
> I especially would like to know what do you think about my choice to set
> as primary key for the catalog table(that I called BM, book material,
> for now) the library_id + inventory_id.
>
> The main reason for this choice is that for an interlibrary system the
> inventory_id is not enough.
> For example, library 01 can have a book with inventory # 000052 titled
> "pippo" while library 02 can have a book with the same inventory but
> called "pluto". The only way to univocally identify a book is using
> inventory id in combination with library id. In this way book "pippo" is
> identified by 01 000052 while "pluto" is identified by 02 000052.
>
> But there is a problem...many libraries are not part of an interlibrary
> system and in this case the library_id is totally useless....A
> workaround could be to give a fake id to the library, for example 00 or
> 01 but I'm not sure, it's not elegant as solution however it could be
> effective.
>
> Another problem is the books classification. I searched on the net and I
> found out that there are *lots* of classification systems. These are all
> incompatible between them, maybe a simple varchar field could be a
> solution but again, I'm not sure.
>
> The BM table is also incomplete because I have to read some
> documentation about bibliographic descriptions standards.
> About this I think we can make the table follow the guidelines of the
> International Standard Bibliographic Description (ISBD), but I'm open to
> other ideas.
>
> Once the db will be almost completed I'll start to do some test scripts
> to insert books. I'll keep you informed.
>
>
> Marco
>
>
>
> _______________________________________________
> Firefly-dev mailing list
> address@hidden
> http://mail.nongnu.org/mailman/listinfo/firefly-dev
--
John Hornbeck <address@hidden>
--- End Message ---
--- End Message ---