Skip Headers

Oracle® Health Sciences Information Gateway Secure Health Email Installation and Configuration Guide Release 2.0.1 E37028-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# C Oracle Health Sciences Information Gateway Secure Health Email Tables

This appendix provides six OHIG Secure Health Email tables that list column names and their data type.

This appendix includes the following section:

- Using the Secure Health Email Tables

## C.1 Using the Secure Health Email Tables

This appendix includes the following OHIG Secure Health Email tables:

- Table C-1, "ADDRESS"

- Table C-2, "ANCHORChanges to the ANCHOR table require a restart of the application."

- Table C-3, "CERTIFICATE"

- Table C-4, "DOMAINChanges to the DOMAIN table require a restart of the application."

- Table C-5, "SEQUENCE"

- Table C-6, "SETTINGChanges to the SETTING table require a restart of the application."

Table C-1 ADDRESS

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
ID | NUMBER(19,0) | Primary key
CREATETIME | TIMESTAMP(6) | Create time
DISPLAYNAME | VARCHAR2(255 BYTE) | Display name
DOMAINID | NUMBER(19,0) | Foreign key to address's DOMAIN
EMAILADDRESS | VARCHAR2(255BYTE) | Internal secure email address
ENDPOINT | VARCHAR2(255 BYTE) | Internal corporate email address
STATUS | NUMBER(10,0) | Object status (0=NEW, 1=ENABLED, 2=DISABLED)
TYPE | VARCHAR2(64 BYTE) | Type of address (XD or SMTP)
UPDATETIME | TIMESTAMP(6) | Update time

Table C-2 ANCHORFoot 1

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
ID | NUMBER(19,0) | Primary key
CERTIFICATEDATA | BLOB | Anchor binary data
CERTIFICATEID | NUMBER(19,0) | <deprecated>
CREATETIME | TIMESTAMP(6) | Create time
FORINCOMING | NUMBER(1,0) | Use anchor for incoming messages (0=NO, 1=YES)
FOROUTGOING | NUMBER(1,0) | Use anchor for outgoing messages (0=NO, 1=YES)
OWNER | VARCHAR2(255 BYTE) | Domain hostname (see DOMAIN) or User name
STATUS | NUMBER(10,0) | Object status (0=NEW, 1=ENABLED, 2=DISABLED)
THUMBPRINT | VARCHAR2(255 BYTE) | Anchor thumbprint
VALIDENDDATE | TIMESTAMP(6) | Anchor expiration date
VALIDSTARTDATE | TIMESTAMP(6) | Anchor start date

Footnote 1 Changes to the ANCHOR table require a restart of the application.

Table C-3 CERTIFICATE

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
ID | NUMBER(19,0) | Primary key
CERTIFICATEDATA | BLOB | Certificate binary data
CREATETIME | TIMESTAMP(6) | Create time
OWNER | VARCHAR2(255 BYTE) | Certificate associated email address
PRIVATEKEY | NUMBER(1,0) | Holds public and private key (0=NO public only, 1=YES)
STATUS | NUMBER(10,0) | Object status (0=NEW, 1=ENABLED, 2=DISABLED)
THUMBPRINT | VARCHAR2(255 BYTE) | Certificate thumbprint
VALIDENDDATE | TIMESTAMP(6) | Certificate expiration date
VALIDSTARTDATE | TIMESTAMP(6) | Certificate start date

Table C-4 DOMAINFoot 1

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
ID | NUMBER(19,0) | Primary key
CREATETIME | TIMESTAMP(6) | Create time
DOMAINNAME | VARCHAR2(255 BYTE) | Domain hostname
POSTMASTERADDRESSID | NUMBER(19,0) | Foreign key to domain's postmaster ADDRESS
STATUS | NUMBER(10,0) | Object status (0=NEW, 1=ENABLED, 2=DISABLED)
UPDATETIME | TIMESTAMP(6) | Update time

Footnote 1 Changes to the DOMAIN table require a restart of the application.

Table C-5 SEQUENCE

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
SEQ_COUNT | NUMBER(38,0) | Sequence count
SEQ_NAME | VARCHAR2(50 BYTE) | Sequence name

Table C-6 SETTINGFoot 1

COLUMN_NAME | DATA_TYPE | COMMENTS
--- | --- | ---
ID | NUMBER(19,0) | Primary key
CREATETIME | TIMESTAMP(6) | Create time
NAME | VARCHAR2(255 BYTE) | Setting name
STATUS | NUMBER(10,0) | Object status (0=NEW, 1=ENABLED, 2=DISABLED)
UPDATETIME | TIMESTAMP(6) | Update time
VALUE | VARCHAR2(1024 BYTE) | Setting value

Footnote 1 Changes to the SETTING table require a restart of the application.

Required and Optional SETTINGs

Table C-7 Required Settings

NAME | DEFAULT | VALUE | COMMENT
--- | --- | --- | ---
AnchorStoreType | n/a | WS | Required to be WS
PublicStoreType | n/a | WS | Required to be WS
PrivateStoreType | n/a | WS | Required to be WS

Table C-8 Optional Settings

NAME | DEFAULT | VALUE | COMMENT
--- | --- | --- | ---
AnchorResolverType | uniform | uniform, multidomain | uniform `FORINCOMING` anchors, are used for both incoming and outgoing messages multidomain `FORINCOMING` anchors, are used for incoming messages `FORINCOMING` anchors, are used for outgoing messages
BadMessageSaveFolder | null | <directory name> | Test directory for logging bad messages
IncomingMessageSaveFolder | null | <directory name> | Test directory for logging incoming messages
OutgoingMessageSaveFolder | null | <directory name> | Test directory for logging outgoing messages
RawMessageSaveFolder | null | <directory name> | Test directory for logging raw messages