| |
|
|
|
|
Column
|
Datatype
|
Purpose
|
Comments
|
|
DOC_ID
|
Varchar - 64
|
Contains the unique document id of every topic created in the publication process.
|
Unique key and foreign key from MI_MAIN and in MI_QUEUE.
|
|
EFFECTIVE
|
Bit
|
Set if document is effective or not
|
Can be used to select only effective versions of publications
|
|
AUDIENCE
|
Varchar - 32
|
Contains information about the intended audience of a publication
|
Can be used to select publications for specific audiences
|
|
DOC_UNID
|
Varchar - 64
|
Contains the unique Id of each topic created in the publication
|
Is unique key in HDS_TOPIC table
|
|
TOPIC_TYPE
|
Varchar - 32
|
Contains the type of topic created
|
Main topic or Sub topic - can be used to select only main topics in a publication
|
|
TRANSFORM_MODE
|
Varchar - 32
|
Contains the type of transformation used for this publication
|
Not in use yet - preparation for full support of XML as basis for transformed content.
|
|
DOC_HEADING
|
Varchar - 254
|
Contains the heading of the individual publication topic
|
...
|
|
DOC_SORTER_HEADING
|
Int - 4
|
Is used to define the correct hierarchical sorting of the individual topics in a publication
|
...
|
|
DOC_NUMBER
|
Varchar - 32
|
Shows this topic's place in the publication
|
...
|