ER diagram

Mathias_Dresske

Hi there

I am looking for a complete ER diagram of the Content Server database.

....any hints or links?

Thanks ahead

Mathias

Find more posts tagged with

Comments

Appu_Nair1

eLink : ER diagramUsually if you sign a NDA with OT for your org you will get a schema doc it has ER diagrams this is totally free for a paying customer
Some DB tools like Toad can show and analyze the schema as well

Sent with Good (www.good.com)

-----Original Message-----
From: eLink Entry: Content Server LiveReports Forum [livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, January 27, 2014 08:51 AM Central Standard Time
To: eLink Recipient
Subject: [EXTERNAL]ER diagram

ER diagram

Posted by mathias.dresske@tui-infotec.com (Dresske, Mathias) On 01-27-2014 09:37

Hi there

I am looking for a complete ER diagram of the Content Server database.

....any hints or links?

Thanks ahead

Mathias

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Colin_Schmidt

I used to work for a company that had the Schema book, but I've picked up more from the Tables listed in a DB Tool. You can examine them one at a time and learn quite a bit. The Schema book doesn't have a total ER, though it might have some for the key Tables: KUAF, DTREE, etc.., but that can be learned by looking through the tables. DATAID is pretty commonly used. DAUDITNEW has USERID and PERFORMERID, but they both are validated against KUAF. In some tables, ID may point to the DTREE and which table is not too hard to figure out.

A DB tool would be able to produce the total ER drawing that you want. The Schema table used to carry few if any codes for some of the columns. OT eventually created Champion document with a number of them. Others are obtained personally through thorough inspection. Here's some of what I've accumulated.

Colin J.

On Mon, Jan 27, 2014 at 10:06 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE [EXTERNAL]ER diagram Posted byappu.n.nair@conocophillips.com (Nair, Appu)On 01-27-2014 10:04

Usually if you sign a NDA with OT for your org you will get a schema doc it has ER diagrams this is totally free for a paying customer
Some DB tools like Toad can show and analyze the schema as well

Sent with Good (www.good.com)

-----Original Message-----
From: eLink Entry: Content Server LiveReports Forum [livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, January 27, 2014 08:51 AM Central Standard Time
To: eLink Recipient
Subject: [EXTERNAL]ER diagram

ER diagram Posted by mathias.dresske@tui-infotec.com (Dresske, Mathias) On 01-27-2014 09:37

Hi there
I am looking for a complete ER diagram of the Content Server database.
....any hints or links?

Thanks ahead
Mathias
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center
[To post a comment, use the normal reply function]
Topic: ER diagram
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Bhupinder_Singh

To obtain a copy of the Livelink/Content Server System Schema Reference Document which contains the Entity Relationship (ER) Diagram detailing how the various tables are connected to each other and also describes each table in detail, you will need to request a copy from your Open Text account manager; you will be asked to sign a non-disclosure agreement (NDA) prior to it being shipped to you. There is no charge for the document.

If you have already signed an NDA, you do not need to sign a new one to obtain the latest version of the Schema Reference. Customers who have ordered the Schema Reference in the past will not receive the new version automatically. Sales reps must explicitly order it for them.

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------