Database Table Schema

Benjamin_Todd

Hi,I need to determine the Primary and Foreign Keys for the table structure. I have been pulled into this project (reporting) last minute and would like to find out the relationships between the tables. I cannot seem to reference to schemas.Thanks for your help and I apologize if this is a duplicate post.Thanks,Benjamin

Eric_Saavedra

Message from Eric Saavedra <esaavedr@opentext.com> via eLink

eLink

Livelink does not use foreign key/primarykey relationships in the schema. Instead unique indexes are used to enforce dataintegrity and foreign key relationships are implied and managed through theapplication. Provided you (or your company) has a signed NDA on file, contactOpen Text Support to obtain a system schema reference for your version ofLivelink.

When you get more time and if you find yourselfdoing more reporting out of Livelink, I heartily recommend the Advanced Schemaand LiveReports course, which provides excellent info on how the Livelinkschema is put together. If you happen to be going to LiveLinkUp! next week, thecourse is offered on Monday and Tuesday.

 

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, October 18, 20072:37 PM
To: eLink Recipient
Subject: Database Table Schema

 

Database Table Schema

Posted by btodd@vical.com (Todd, Benjamin) on 10/18/2007 05:34 PM

 

Hi, I need to determine the Primary and Foreign Keys for the table structure. I have been pulled into this project (reporting) last minute and would like to find out the relationships between the tables. I cannot seem to reference to schemas. Thanks for your help and I apologize if this is a duplicate post. Thanks, Benjamin