EA_APPLICATION_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EA Application Type |
Definition: | This table will store the application type reference data. |
Table Type: | REFERENCE |
Column Detail - EA_APPLICATION_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
APPLICATION_TYPE_DESC | VARCHAR(200) | N | Description of the application type |
APPLICATION_TYPE_NAME | VARCHAR(50) | N | Unique name for the application type |
CREATE_DT_TM | DATETIME | N | Timestamp when the record was created. |
CREATE_USER_NAME | VARCHAR(50) | N | Identifier of the user or system which created the record. |
EA_APPLICATION_TYPE_ID | DOUBLE | N | PRIMARY KEY. Database generated sequence number |
UPDATE_USER_NAME | VARCHAR(50) | N | Identifier of the user or system which updated the record. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - EA_APPLICATION_TYPE
Parent Column in EA_APPLICATION_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EA_APPLICATION_TYPE_ID | EA_TRANSACTION_HIST | EA_APPLICATION_TYPE_ID |
EA_TRANSACTION_MAIN | EA_APPLICATION_TYPE_ID |
EA_ATTRIBUTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Attribute |
Definition: | Represents a security "attribute", be it a privilege or account restriction, that may be assigned to a user account. |
Table Type: | REFERENCE |
Column Detail - EA_ATTRIBUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
ATTRIBUTE_NAME | VARCHAR(100) | N | Name of the attribute |
EA_ATTRIBUTE_ID | DOUBLE | N | Generated unique identifier for an attribute. |
NAMESPACE | VARCHAR(200) | N | The namespace (e.g., privilege or restriction) with which this attribute is associated. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - EA_ATTRIBUTE
Parent Column in EA_ATTRIBUTE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EA_ATTRIBUTE_ID | EA_USER_ATTRIBUTE_RELTN | EA_ATTRIBUTE_ID |
EA_CONFIG
Column Section | Top of Page |
Table-level Detail
Description: | Enterprise (Security Service) Configuration |
Definition: | Name-Value pairs representing Security Service configuration setting. |
Table Type: | REFERENCE |
Column Detail - EA_CONFIG
Column Name | Type | Null? | Definition |
---|---|---|---|
CONFIG_NAME | VARCHAR(100) | N | Name of the configuration setting. |
CONFIG_VALUE | VARCHAR(1000) | Y | The value of the configuration setting. |
EA_CONFIG_ID | DOUBLE | N | Generated unique identifier for a configuration setting. |
REALM | VARCHAR(100) | N | The realm or domain with which the user account is associated. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
EA_DIGITAL_CERT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DIGITAL CERTIFICATES |
Definition: | Represents digital certificates available to tye system |
Table Type: | REFERENCE |
Column Detail - EA_DIGITAL_CERT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ALIAS | VARCHAR(250) | N | ALIAS TEXT |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
COMPROMISED_DT_TM | DATETIME | Y | Timestamp indicating when the key pair was flagged as having been compromised |
EA_DIGITAL_CERT_ID | DOUBLE | N | Unique generated number that identifies a single row on the DIGITAL_CERT table |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
FINGERPRINT | VARCHAR(1000) | N | Base 64 encoded hash of the certificate |
NOT_AFTER_DT_TM | DATETIME | Y | Certificate's Not After value. The certificate is not valid after this date/time. |
NOT_BEFORE_DT_TM | DATETIME | Y | Certificate's Not Before value. The certificate is not valid before this date/time. |
SUBJECT | VARCHAR(4000) | N | SUBJECT MATTER |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - EA_DIGITAL_CERT
Parent Column in EA_DIGITAL_CERT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EA_DIGITAL_CERT_ID | EA_DIGITAL_CERT_KEYS | EA_DIGITAL_CERT_ID |
EA_DIGITAL_CERT_KEYS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EA_DIGITAL_CERT_KEYS |
Definition: | Holds cryptographic keys used by Certificate Management service. |
Table Type: | REFERENCE |
Column Detail - EA_DIGITAL_CERT_KEYS
Column Name | Type | Null? | Definition |
---|---|---|---|
EA_DIGITAL_CERT_ID | DOUBLE | N | FK value from the EA_DIGITAL_CERT table. |
EA_DIGITAL_CERT_KEYS_ID | DOUBLE | N | Unique generated number that identifies a single row on the EA_DIGITAL_CERT_KEYS table. |
KEY_DATA | LONGTEXT | Y | Cryptographic data. |
KEY_TYPE_FLAG | DOUBLE | N | Indicates the type of cryptographic data (private key, digital certificate, etc.). |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - EA_DIGITAL_CERT_KEYS
Child Column in EA_DIGITAL_CERT_KEYS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EA_DIGITAL_CERT_ID | EA_DIGITAL_CERT | EA_DIGITAL_CERT_ID |