MFA_ACTIVITY
Column Section | Top of Page |
Table-level Detail
Description: | MULTI FACTOR AUTHENTICATION ACTIVITY |
Definition: | Holds evidence used to verify that a multi-factor authentication was successfully performed. |
Table Type: | ACTIVITY |
Column Detail - MFA_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
MFA_ACTIVITY_ID | DOUBLE | N | Unique generated number that identifies a single row on this table. Primary Key. |
RECEIPT | LONGTEXT | Y | Evidence used to verify that a multi--factor authentication was successfully performed. |
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. |
MFA_IDENTITY_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MFA Identity Type |
Definition: | Stores information about the defined Identity Types, and the Method implementations which are configured to support them. |
Table Type: | REFERENCE |
Column Detail - MFA_IDENTITY_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
CLASS_NAME | VARCHAR(260) | Y | FQN of the Java class which supports this identity type |
IDENTITY_TYPE_NAME | VARCHAR(45) | N | UNIQUE NAME FOR AN IDENTITY TYPE |
IDENTITY_TYPE_VAL | DOUBLE | N | A Unique Value (Enumeration) created by the application which identifies an Identity Type. |
LIBRARY_NAME | VARCHAR(260) | Y | Name of the DLL which supports this identity type |
MFA_IDENTITY_TYPE_ID | DOUBLE | N | Primary Key |
MFA_METHOD_ID | DOUBLE | N | Foreign Key to the METHOD table |
TIMEOUT_AMT | DOUBLE | Y | Amount of time framework will allow for Method to perform its authentication before cancelling the attempt and continuing. |
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 - MFA_IDENTITY_TYPE
Child Column in MFA_IDENTITY_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MFA_METHOD_ID | MFA_METHOD | MFA_METHOD_ID |
MFA_IDENTITY_TYPE_PROPERTY
Column Section | Top of Page |
Table-level Detail
Description: | MFA Identity Type Property |
Definition: | Associates Identity Types eith Identity Type Properties - Defines Identity Type Attribute Names |
Table Type: | REFERENCE |
Column Detail - MFA_IDENTITY_TYPE_PROPERTY
Column Name | Type | Null? | Definition |
---|---|---|---|
IDENTITY_TYPE_PROPERTY_NAME | VARCHAR(45) | Y | THE NAME OF THE PROPERTY. MUST BE UNIQUE PER IDENTITY TYPE. |
MFA_IDENTITY_TYPE_ID | DOUBLE | N | Foreign Key to the IDENTITY_TYPE table |
MFA_IDENTITY_TYPE_PROPERTY_ID | DOUBLE | N | Primary Key |
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. |
MFA_METHOD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MFA Method |
Definition: | Stores defined MFA Methods |
Table Type: | REFERENCE |
Column Detail - MFA_METHOD
Column Name | Type | Null? | Definition |
---|---|---|---|
METHOD_DESCRIPTION | VARCHAR(200) | Y | Free-text description of the Method |
METHOD_NAME | VARCHAR(45) | N | Free-text Name for the Method. Uniquely identifies a Method in the table. |
MFA_METHOD_ID | DOUBLE | N | Primary Key |
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 - MFA_METHOD
Parent Column in MFA_METHOD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MFA_METHOD_ID | MFA_IDENTITY_TYPE | MFA_METHOD_ID |
MFA_METHOD_CHAIN | MFA_METHOD_ID |
MFA_METHOD_CHAIN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MFA Method Chain |
Definition: | Stores the Methods associated with a Mode, and the sequence in which the Mode Methods will be processed |
Table Type: | REFERENCE |
Column Detail - MFA_METHOD_CHAIN
Column Name | Type | Null? | Definition |
---|---|---|---|
CHAIN_SEQUENCE | DOUBLE | N | Position of this entry in the mode's list of methods |
MFA_METHOD_CHAIN_ID | DOUBLE | N | Primary Key |
MFA_METHOD_ID | DOUBLE | N | Foreign Key to the Method table. |
MFA_MODE_ID | DOUBLE | N | Foreign Key to the MODE table |
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 - MFA_METHOD_CHAIN
Child Column in MFA_METHOD_CHAIN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MFA_METHOD_ID | MFA_METHOD | MFA_METHOD_ID |
MFA_MODE_ID | MFA_MODE | MFA_MODE_ID |