haf2
Tables (5)
T_HANCOMAUTH_AUDIT_LOG (Untitled4)
- LOG_ID (로그ID) — NUMBER — Primary key — NOT NULL
- USER_ID (사용자ID) — VARCHAR2(255) — NOT NULL
- ACTOR_IP (행위자IP) — VARCHAR2(50) — NOT NULL
- ACTION_TYPE (작업유형) — VARCHAR2(255) — NOT NULL
- SQL_TEXT (실행 SQL) — CLOB — NOT NULL
- REGISTER_DATETIME (등록 시간) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MANAGER (관리자 테이블)
- USER_ID (사용자ID) — VARCHAR2(255) — Primary key — NOT NULL
- USER_NAME (사용자이름) — VARCHAR2(255) — NOT NULL
- ALLOWED_IP (사용자접속IP) — VARCHAR2(50)
- PASSWORD (패스워드) — VARCHAR2(255) — NOT NULL
- USE_YN (사용여부) — VARCHAR2(1 CHAR) — NOT NULL
- IS_DELETED (삭제여부) — VARCHAR2(1 CHAR)
- USER_EMAIL (사용자 Email) — VARCHAR2(255) — NOT NULL
- ROLE_ID (역할_ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_ROLE.ROLE_ID — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일자) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MENU (Untitled2)
- MENU_NAME (매뉴이름) — VARCHAR2(255) — Primary key — NOT NULL
- UP_MENU_Name (상위매뉴이름) — VARCHAR2(255) — NOT NULL
- URL — VARCHAR2(255) — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일자) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_ROLE (Untitled)
- ROLE_ID (역할_ID) — NUMBER(3) — Primary key — NOT NULL
- ROLE_NAME (역할이름) — VARCHAR2(255) — NOT NULL
- USE_YN (사용유무) — VARCHAR2(1 CHAR) — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일자) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_ROLE_MENU_MAP (Untitled3)
- ROLE_ID (역할_ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_ROLE.ROLE_ID — NOT NULL
- MENU_NAME (매뉴이름) — VARCHAR2(255) — Foreign key → T_HANCOMAUTH_MENU.MENU_NAME — NOT NULL
- SEARCH_YN (읽기가능) — VARCHAR2(1 CHAR) — NOT NULL
- WRITE_YN (저장,수정가능) — VARCHAR2(1 CHAR) — NOT NULL
- DELETE_YN (삭제가능) — VARCHAR2(1 CHAR) — NOT NULL
- EXPORT_YN (추출가능) — VARCHAR2(1 CHAR) — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일자) — TIMESTAMP — NOT NULL