Category description: in which table is this stored ?

[matasa]

Hi,
I'm looking into livelink (9.7.1) DB organization and I'm to trying to find in which tables are described the content of a category. I can see the list of fields in table catregionmap,
for instance for a catid=18629137 I can see the list of corresponding fields:
; catid; ; catname; setname; attrname; regionname
; 18629137 ; ABC; unk ; abc_cat_01 ; Attr_18629137_2 ;
; 18629137 ; ABC ; unk ; abc_cat_02 ; Attr_18629137_3 ;
; 18629137 ; ABC ; unk ; abc_cat_03_req ; Attr_18629137_4 ;
...

I look in most of the tables and I can see nowhere information such as:
- type of each field (date, integer, string)
- list of valid values for a popup text or integer field
- if a field is or not required

However when I add these attributes to an object I can see the result (fields types and values) in llattrdata
I know I can use LAPI to get this information, I'm just curious to know where it is stored in the DB.
I'd really appreciate if somebody could give me some hints here.
Thanks in advance for your help,
Matasa.

 

[appnair]

The category definition that you make up is a flat ascii/utf8 file which is like any text file in the EFS or blob storage if that is used with a subtype of 131 I guess. When you apply this category to a object livelink actually does an insert into LLATTRBLOBDATA table.If you look at a row in that table it will have a CLOB or LONG with what we call an ASSOC.It is not conducive to SQL based reporting.Each of the LLATTRBLOBDATA rows are de normalized into another table called LLATTRDATA which has the attribute ID and the data type.
If you sign an NDA for livelink which is free much of this info can be mined.LLAATTRDATA table is a read only table soif you make changes to the table the livelink GUI will not reflect any changes.DIRECT DB MANIPULATION OF LIVELINK SCHEMA IS VERY DANGEROUS AS WELL.


You read this as
Attr_18629137_2

Category Attribute with a dataid of 18629137 and an attribute id of 2.Catregionmap is ised by the search indexer pof livelink so you can use
livelink search later to figure that out

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[matasa]

Thanks appnair,
Really useful information as always, just to be clear the intent when looking into the DB is to fetch information, I never write into the base you are perfectly right on this point. I pursue 2 goals: one is having better performance than LAPI when looking for some data, the other goal being to understand the schema (more by personal interest).
Thanks for the tip, I'll try to contact Livelink people about the NDA.
Best regards,
Matasa,