Re: Database Schema

Adam Tauno Williams wrote:
> On Fri, 2008-07-04 at 22:09 +0100, Ken Smith wrote:
{snip}

>> I've exported the data with Outlook from the .pst file into a csv 
>> file. Using Excel I use OLE to link to another spreadsheet which is 
>> in the same format as date_x. I then use Access/ODBC to import the 
>> date to the OGo database. I need to manually create some data, 
>> especially for the repeating appointments.
>> Fortunately there isn't any real data for the participants or the 
>> resources but I notice that entries are created in those tables by my 
>> test entries. that don't have participants or resources.
>
> Appointments must have participants;  therefore there is always at least
> one record in date_company_assignment for each record in date_x.
>
>> I can see that the public_date_info table gets updated when I create a
>
> ??? public_date_info?  There isn't any such table;  perhaps you have
> create a view?

Honestly, I haven't created any views, but the name is more likely 
date_info. It just shows as public_date_info through odbc/MSaccess
>
>> Assuming that key of date_x is the first field called  date_id I
>
> Yep.
>
>> can see that field (date_id) appears in the second column of the 
>> table date_info. Again assuming that the first column of date_info is 
>> the key I notice that numerically the key is one greater than the 
>> value of date_id
>
> That is circumstantial. "date_company_assignment_id" is the primary key
> of the table,  it must be assigned with the ?"nextval('key_generator')".
> Since the participants are added immediately after the date_x record is
> inserted - so they track, but only circumstantially.
>
{snip}

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users