mOTP
Tables (14)
ADMIN
- 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
- CUR_FAILCOUNT — NUMBER(10)
- 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)
APP_CORE
- 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
- APP_ID — VARCHAR(255 CHAR)
- DESCRIPTION — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- OS — VARCHAR(255 CHAR)
APP_CORE_HISTORY
- ID — NUMBER(19) — Primary key — NOT NULL
- CREATED_BY — VARCHAR(255 BYTE) — NOT NULL
- CREATED_DATE — TIMESTAMP(6) — NOT NULL
- MODIFIED_BY — VARCHAR(255 BYTE) — NOT NULL
- MODIFIED_DATE — TIMESTAMP(6) — NOT NULL
- FILE_NAME — VARCHAR(255 BYTE)
- FILE_PATH — VARCHAR(255 BYTE)
- ICON_NAME — VARCHAR(255 BYTE)
- ICON_PATH — VARCHAR(255 BYTE)
- VERSION — VARCHAR(255 BYTE)
- APP_CORE_ID — NUMBER(19)
AUDIT_ADMIN
- 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)
- IP — VARCHAR(255 CHAR)
- MAIN_TYPE — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- RESULT — VARCHAR(255 CHAR)
- SUB_TYPE — VARCHAR(255 CHAR)
- USERID — VARCHAR(255 CHAR)
AUDIT_AUTH
- 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)
AUTH_AGENT
- 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)
- INPUT_MODE — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- URL — VARCHAR(255 CHAR)
- POLICY_ID — NUMBER(19)
CERTDATA
- AUTHCODE — VARCHAR(8 BYTE)
- PARAMS — VARCHAR(500 BYTE)
- MODDATE — VARCHAR(20 BYTE)
- P12CERT — CLOB
CONFIG
- 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
- VALUE — VARCHAR(255 CHAR)
MESSAGE
- 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
- OBJECT_NAME — VARCHAR(255 CHAR)
- OBJECT_TYPE — VARCHAR(255 CHAR)
- USER_GROUP_ID — VARCHAR(255 CHAR)
- USER_ID — VARCHAR(255 CHAR)
POLICY
- 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
- DESCRIPTION — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- OTP_ALG — VARCHAR(255 CHAR)
- OTP_LEN — NUMBER(10)
- OTP_TIME — NUMBER(10)
- OTP_VALIDATE_DAYS — NUMBER(10)
- OTP_WIN_SIZE — NUMBER(10)
USER_GROUP
- 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)
- PARENT_ID — VARCHAR(255 CHAR)
USER_INFO
- 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
- AUTH_CODE — VARCHAR(255 CHAR)
- AUTH_STATUS — VARCHAR(255 CHAR)
- EMAIL — VARCHAR(255 CHAR)
- NAME — VARCHAR(255 CHAR)
- TEL — VARCHAR(255 CHAR)
- USER_GROUP_ID — VARCHAR(255 CHAR)
- PASSWORD — VARCHAR(255 CHAR)
USER_INFO_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
- BLOCK_TYPE — VARCHAR(255 CHAR)
- FAIL_CNT — NUMBER(10)
- LAST_AUTH_TOKEN — VARCHAR(255 CHAR)
- OTP_USE — VARCHAR(255 CHAR)
- QR_URL — VARCHAR(255 CHAR)
- SECRET_KEY — VARCHAR(255 CHAR)
- STATUS — VARCHAR(255 CHAR)
- TEMP_AUTH_TOKENS — VARCHAR(255 CHAR)
- AUTH_AGENT_ID — VARCHAR(255 CHAR)
- USER_INFO_ID — VARCHAR(255 CHAR)
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) — Foreign key → USER_INFO.ID
- SYS_ID — VARCHAR(255 CHAR)
- SYS1 — VARCHAR(255 CHAR)
- SYS2 — VARCHAR(255 CHAR)