Oracle® Health Sciences Information Gateway Secure Health Email Installation and Configuration Guide Release 1.2 E22884-01 |
|
|
PDF · Mobi · ePub |
This appendix provides six OHIG Secure Health Email tables that list column names and their data type.
This appendix includes the following section:
This appendix includes the following OHIG Secure Health Email tables:
Table B-2, "ANCHORChanges to the ANCHOR table require a restart of the application."
Table B-4, "DOMAINChanges to the DOMAIN table require a restart of the application."
Table B-6, "SETTINGChanges to the SETTING table require a restart of the application."
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 (should be "XD") |
UPDATETIME |
TIMESTAMP(6) |
Update time |
Table B-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.
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 B-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.
COLUMN_NAME | DATA_TYPE | COMMENTS |
---|---|---|
SEQ_COUNT |
NUMBER(38,0) |
Sequence count |
SEQ_NAME |
VARCHAR2(50 BYTE) |
Sequence name |
Table B-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
NAME | DEFAULT | VALUE | COMMENT |
---|---|---|---|
Required SETTINGs | |||
AnchorStoreType | n/a | WS | Required to be WS |
PublicStoreType | n/a | WS | Required to be WS |
PrivateStoreType | n/a | WS | Required to be WS |
Optional SETTINGs | |||
AnchorResolverType | uniform | uniform, multidomain | uniform
multidomain
|
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 |