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)