|
|
Loading...
|
|
|
Hyper.Net Database Structure and Datatype Definitions
|
(0)
|
MI_PUBLISHED_INFO
| |
|
|
|
|
Column
|
Datatype
|
Purpose
|
Comments
|
|
DOC_ID
|
Varchar - 64
|
Contains the unique Id of the document published
|
Is unique key in the table
|
|
EFFECTIVE
|
Bit - 1
|
Is set if the published document is the Effective Version
|
...
|
|
AUDIENCE
|
Varchar - 32
|
Contains the Audience of the published document
|
Production or Approval
|
|
LAST_PUB_DATE
|
Datetime - 8
|
Last time/date the document was published
|
...
|
|
TRANSFORMER
|
Varchar - 128
|
Contains the name of the transformer used for this document
|
...
|
|
PUB_CATEGORY
|
Varchar - 254
|
Contains the publication category for the document
|
...
|
|
[LANGUAGE]
|
Varchar - 128
|
Contains the language metadata for the document
|
...
|
|
PUB_DATABASE_PROD
|
Varchar - 64
|
Contains the name of the database where the document has been published to
|
...
|
|
NOTIFICATION_EMAIL_APP
|
Varchar - 254
|
Contains the email of the last user notified of approval of this document
|
...
|
|
NOTIFICATION_EMAIL_PROD
|
Varchar - 254
|
Contains the email of the last user notified of the change in status of this document
|
...
|
Loading, please wait...
|
|
|
|
|
|
|