[OGo-Users] Importing the Hardware

[Adam Tauno Williams]

> I have two basic questions. The first one is, is that a generally a good
> idea? I am a bit worried that id's might get out of sync if I update one

If you use the nextval('key_sequence') when inserting objects you should
be fine.

> table and not another, or fail to update an audit trail, or who knows

You don't have to worry much about the log table, etc...

> what. If I manage to figure out where data should go, how much danger is
> there in just inserting that information?

For loading the database initially you should be pretty safe;  I'd be
more cautious about doing it to an up-and-running server.

> The second question is that, after A) figuring out PostgreSQL a bit and B)
> taking a peek at the database I seem to be missing something. I mean,
> there seems to be tables that correspond to news, contacts, companies,
> projects, etc. But there doesn't appear to be dedicated tables for
> appointments, tasks, and times. Can somebody please point me in the right
> direction for this?

Appointments center around the date_x table and jobs like in the job
table.  Looking at the EOModel file in subversion might help you -
http://svn.opengroupware.org/viewcvs/trunk/Database/OGoModel/OpenGroupware.org_PostgreSQL.eomodel?rev=1478&view=markup