FIDO
Tables (20)
ADMIN
- ID — VARCHAR(255 BYTE) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- ADMIN_ID — VARCHAR(255 CHAR)
- CHG_PASSWORD — VARCHAR(255 CHAR)
- CUR_FAILCOUNT — NUMBER(10)
- CURPASSWORD — VARCHAR(255 CHAR)
- EMAIL — VARCHAR(255 CHAR)
- LOCKED_TIME — VARCHAR(255 CHAR)
- LOCKING_TIME — NUMBER(10)
- MAX_FAILCOUNT — NUMBER(10)
- MODIFED_PW_DATE — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- PASSWORD — VARCHAR(255 CHAR)
- PW_MODIFY_TIME — NUMBER(10)
- ROLE — VARCHAR(255 CHAR)
- STATUS — VARCHAR(255 CHAR)
- TEL — VARCHAR(255 CHAR)
ADMIN_AUDIT
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- DETAIL — VARCHAR(255 CHAR)
- MAIN_TYPE — VARCHAR(255 CHAR)
- RESULT — VARCHAR(255 CHAR)
- ROWHASH — VARCHAR(255 CHAR)
- SUB_TYPE — VARCHAR(255 CHAR)
AUTHAGENT
- ID — VARCHAR(255 CHAR) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- DESCRIPTION — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- URL — VARCHAR(255 CHAR)
AUTHENTICATORS
- USERNAME — VARCHAR(255 CHAR) — Primary key — NOT NULL
- AAID — VARCHAR(255 CHAR)
- ALGENCPUB — VARCHAR(255 CHAR)
- APPID — VARCHAR(255 CHAR)
- AUTHENTICATORVERSION — VARCHAR(255 CHAR)
- IP — VARCHAR(255 CHAR)
- KEYID — VARCHAR(255 CHAR)
- MANUFACTURER — VARCHAR(255 CHAR)
- NETWORK — VARCHAR(255 CHAR)
- OID1 — VARCHAR(255 CHAR)
- OID2 — VARCHAR(255 CHAR)
- OS — VARCHAR(255 CHAR)
- OSVERSION — VARCHAR(255 CHAR)
- PUBLICKEY — VARCHAR(255 CHAR)
- RAWVAL — VARCHAR(255 CHAR)
- SIGNATURECOUNTER — VARCHAR(255 CHAR)
- STATUS — VARCHAR(255 CHAR)
- P_TYPE — VARCHAR(255 CHAR)
AUTHKEY_DATA
- ID — NUMBER(19) — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR)
- CREATED_DATE — TIMESTAMP(6)
- MODIFIED_BY — VARCHAR(255 CHAR)
- MODIFIED_DATE — TIMESTAMP(6)
- AUTH_KEY — VARCHAR(255 CHAR)
- USER_ID — VARCHAR(255 BYTE)
AUTHTOKEN
- ID — NUMBER(19) — Primary key — NOT NULL
- TOKEN — VARCHAR(255 CHAR)
- CREATED_DATE — TIMESTAMP(6)
AUTH_AUDIT
- ID — NUMBER
- AAID — VARCHAR(255 CHAR)
- APPID — VARCHAR(255 CHAR)
- CREATED_DATE — TIMESTAMP(6)
- IP — VARCHAR(255 CHAR)
- MANUFACTURER — VARCHAR(255 CHAR)
- NETWORK — VARCHAR(255 CHAR)
- OP — VARCHAR(255 CHAR)
- OS — VARCHAR(255 CHAR)
- OSVERSION — VARCHAR(255 CHAR)
- TYPE — VARCHAR(255 CHAR)
- USERNAME — VARCHAR(255 CHAR)
CERTDATA
- ID — VARCHAR(255 BYTE) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- SIGNATURE — CLOB
- DN — VARCHAR(255 BYTE)
- PASSWORD — VARCHAR(255 BYTE)
- VERIFYID — VARCHAR(255 BYTE)
CHALLENGES
- ID — NUMBER(19) — Primary key — NOT NULL
- CHALLENGE — VARCHAR(255 CHAR)
- CREATED_AT — TIMESTAMP(6)
- EXPIRATION — VARCHAR(255 CHAR)
- POLICY — VARCHAR(255 CHAR)
- SERVER_DATA — VARCHAR(255 CHAR)
- USERNAME — VARCHAR(255 CHAR)
OTP
- USERID — VARCHAR(255 CHAR) — Primary key — NOT NULL
- TIMER — VARCHAR(255 CHAR)
- AUTHCODE — VARCHAR(255 CHAR)
- EMAIL — VARCHAR(255 CHAR)
- OTPVALUE — VARCHAR(255 CHAR)
- PHONE — VARCHAR(255 CHAR)
- RESULT — VARCHAR(255 CHAR)
- SESSIONID — VARCHAR(255 CHAR)
POLICIES
- ID — NUMBER(19) — Primary key — NOT NULL
- AAID — VARCHAR(255 CHAR)
- FLAG — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
POLICIES_BASE_INFO
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- AAID — VARCHAR(255 CHAR)
- DESCRIPTION — VARCHAR(255 CHAR)
- DETAIL — VARCHAR(255 CHAR)
- FILE_NAME — VARCHAR(255 CHAR)
- ORIGINAL_METADATA — CLOB
- STATUS — VARCHAR(255 CHAR)
PUSHTOKEN
- USERNAME — VARCHAR(255 CHAR) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- AUTH_KEY — VARCHAR(255 CHAR)
- PHONE — VARCHAR(255 CHAR)
- SESSIONID — VARCHAR(255 CHAR)
- TOKEN — VARCHAR(255 CHAR)
- TYPE — VARCHAR(255 CHAR)
RELAY_AUDIT
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- AGENT_ID — VARCHAR(255 CHAR)
- AUTH_CNT — VARCHAR(255 CHAR)
- AUTH_KEY — VARCHAR(255 CHAR)
- BROWSER — VARCHAR(255 CHAR)
- IP — VARCHAR(255 CHAR)
- OP — VARCHAR(255 CHAR)
- RESULT — VARCHAR(255 CHAR)
- SESSIONID — VARCHAR(255 CHAR)
- USERNAME — VARCHAR(255 CHAR)
- AUTHMETHOD — VARCHAR(255 BYTE)
- AUTH_URL — VARCHAR(255 BYTE)
- PC — VARCHAR(255 BYTE)
- SYS — VARCHAR(255 BYTE)
SETTING
- ID — VARCHAR(255 CHAR) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- CODE — VARCHAR(255 CHAR)
- VALUE — VARCHAR(255 CHAR)
SYS_AUDIT
- ID — NUMBER(19) — Primary key — NOT NULL
- OP — VARCHAR(255 CHAR)
- CREATED_BY — VARCHAR(255 CHAR)
- CREATED_DATE — TIMESTAMP(6)
- MODIFIED_BY — VARCHAR(255 CHAR)
- MODIFIED_DATE — TIMESTAMP(6)
- USER_ID — VARCHAR(255 CHAR)
- USER_PASSWORD — VARCHAR(255 CHAR)
- SYS_ID — VARCHAR(255 CHAR)
- SYS1 — VARCHAR(255 CHAR)
- SYS2 — VARCHAR(255 CHAR)
- AUTH_KEY — VARCHAR(255 CHAR)
TRUSTED_FACET
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- APPID — VARCHAR(255 CHAR)
- DESCRIPTION — VARCHAR(255 CHAR)
- FACET_ID — VARCHAR(255 CHAR)
- HASH — VARCHAR(255 CHAR)
- OS — VARCHAR(255 BYTE)
- FAIL_COUNT — VARCHAR(255 CHAR)
- VERSION — VARCHAR(255 CHAR)
TRUSTED_FACET_DETAIL
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- APPID — VARCHAR(255 CHAR)
- FILE_NAME — VARCHAR(255 CHAR)
- FILE_PATH — VARCHAR(255 CHAR)
- OS — NUMBER(10)
- TRUSTED_FACET — RAW(255 CHAR)
- VERSION — VARCHAR(255 CHAR)
USERINFO
- ID — VARCHAR(255 BYTE) — Primary key — NOT NULL
- UDID — VARCHAR(255 CHAR)
- AUTH_URL — VARCHAR(255 CHAR)
- EMAIL — VARCHAR(255 CHAR)
- MAIL_AUTH_CNT — NUMBER(10)
- MAIL_LAST_DATE — TIMESTAMP(6)
- NAME — VARCHAR(255 CHAR)
- TEL — VARCHAR(255 CHAR)
- USER_ID — VARCHAR(255 CHAR)
- CREATED_BY — VARCHAR(255 BYTE)
- CREATED_DATE — TIMESTAMP(6)
- MODIFIED_BY — VARCHAR(255 BYTE)
- MODIFIED_DATE — TIMESTAMP(6)
- PASSWORD — VARCHAR(255 BYTE)
- MEMBER_CLASS — VARCHAR(255 BYTE)
- SYSTEM_CLASS — VARCHAR(255 BYTE)
- MNDCS_GROUP_NAME — VARCHAR(255 BYTE)
- SYS_ID — VARCHAR(255 BYTE)
- SYS1 — VARCHAR(255 BYTE)
- SYS2 — VARCHAR(255 BYTE)
- AUTH_METHOD — VARCHAR(255 BYTE)
USER_SYS_INFO
- NO — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 CHAR) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- USER_ID — VARCHAR(255 CHAR)
- SYS_ID — VARCHAR(255 CHAR)
- SYS1 — VARCHAR(255 CHAR)
- SYS2 — VARCHAR(255 CHAR)