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