asd

Tables (8)

TBL_AUTHENTICATED_MENU

  • AUTHORITY_CODE — NUMBER — NOT NULL
  • MENU_CODE — NUMBER — NOT NULL

TBL_AUTHORITY

  • AUTHORITY_CODE — NUMBER — NOT NULL
  • AUTHORITY_NAME — VARCHAR2(255) — NOT NULL
  • AUTHORITY_DESC — VARCHAR2(4000) — NOT NULL

TBL_CHANGED_PWD_LOG

  • CHANGED_PWD_LOG_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • BEFORE_CHANGED_PWD — CHAR(60) — NOT NULL
  • CHANGED_PWD_DATE — CHAR(8) — NOT NULL

TBL_GLOBAL_MENU

  • MENU_CODE — NUMBER — NOT NULL
  • MENU_NAME — VARCHAR2(255) — NOT NULL
  • MENU_URL — VARCHAR2(255) — NOT NULL
  • MENU_DESC — VARCHAR2(4000) — NOT NULL
  • MENU_ORDER — NUMBER — NOT NULL
  • REMOVED_YN — CHAR(1) — NOT NULL
  • MENU_TYPE — NUMBER — NOT NULL
  • REF_MENU_CODE — NUMBER

TBL_LOGIN_FAILED_LOG

  • LOGIN_FAILED_LOG_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • LOGIN_FAILED_DATETIME — TIMESTAMP — NOT NULL
  • LOGIN_TRIED_IP — CHAR(15) — NOT NULL
  • LOGIN_FAILED_REASON — VARCHAR2(255) — NOT NULL

TBL_LOGIN_LOG

  • LOGIN_LOG_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • LOGIN_DATETIME — TIMESTAMP — NOT NULL
  • LOGIN_IP — CHAR(15) — NOT NULL
  • REFERER_URL — VARCHAR2(255) — NOT NULL

TBL_MEMBER

  • MEMBER_NO — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • MEMBER_PWD — CHAR(60) — NOT NULL
  • TEMP_PWD_YN — CHAR(1) — NOT NULL
  • PWD_CHANGED_DATETIME — DATE — NOT NULL
  • PWD_EXP_DATE — CHAR(8) — NOT NULL
  • MEMBER_NAME — VARCHAR2(20) — NOT NULL
  • MEMBER_REGIST_DATETIME — DATE — NOT NULL
  • ACCUM_LOGIN_COUNT — NUMBER — NOT NULL
  • LOGIN_FAILED_COUNT — NUMBER — NOT NULL
  • ACC_LOCK_YN — CHAR(1) — NOT NULL
  • ACC_INACTIVE_YN — CHAR(1) — NOT NULL
  • ACC_EXP_DATE — CHAR(8) — NOT NULL
  • ACC_EXP_YN — CHAR(1) — NOT NULL
  • ACC_SECESSION_DATETIME — DATE
  • ACC_SECESSION_YN — CHAR(1) — NOT NULL

TBL_MEMBER_ROLE

  • MEMBER_NO — NUMBER — NOT NULL
  • AUTHORITY_CODE — NUMBER — NOT NULL