haf
Tables (9)
T_HANCOMAUTH_AUDIT_LOG (Untitled8)
- LOG_ID (로그ID) — NUMBER — Primary key — NOT NULL
- USER_ID (사용자ID) — VARCJAR2(255) — NOT NULL
- ACTOR_IP (행위자IP) — VARCHAR2(50) — NOT NULL
- TARGET_TABLE (대상 테이블) — VARCJAR2(255) — NOT NULL
- TARGET_ID (대상 식별자) — VARCJAR2(255) — NOT NULL
- ACTION_TYPE (행위 타입) — VARCJAR2(10) — NOT NULL
- CHANGE_DATA (변경 데이터) — CLOB — NOT NULL
- REGISTER_DATETIME (등록 일시) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_AUTH_MENU_MAP (Untitled6)
- AUTH_ID (권한ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_MANAGER_AUTH.AUTH_ID — NOT NULL
- MENU_ID (매뉴ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_MENU.MENU_ID — NOT NULL
- SEARCH_YN (검색가능) — VARCHAR2(1 CHAR) — NOT NULL
- WRITE_YN (저장 가능) — VARCHAR2(1 CHAR) — NOT NULL
- UPDATE_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
T_HANCOMAUTH_DELETED_MANAGER (Untitled9)
- USER_ID (사용자ID) — VARCHAR2(255) — Primary key — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일자) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_M ANAGER_GRADE_AUTH_CHANGE (Untitled7)
- POLICY_TYPE (정책타입) — VARCJAR2(255) — Primary key — NOT NULL
- VERSION (버전) — NUMBER — NOT NULL
- REGISTER_USER_ID (등록자) — VARCJAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일시) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MANAGER (Untitled)
- 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
- USER_EMAIL (사용자 Email) — VARCHAR2(255)
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일시) — TIMESTAMP — NOT NULL
- GRADE_ID (등급ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_MANAGER_GRADE.GRADE_ID — NOT NULL
T_HANCOMAUTH_MANAGER_AUTH (Untitled4)
- AUTH_ID (권한ID) — NUMBER(3) — Primary key — NOT NULL
- AUTH_NAME (권한명) — VARCHAR2(255) — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR(255) — NOT NULL
- MODIFY_DATETIME (수정일) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MANAGER_GRADE (Untitled2)
- GRADE_ID (등급ID) — NUMBER(3) — Primary key — NOT NULL
- GRADE_NAME (등급명) — VARCHAR2(255) — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일시) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MANAGER_GRADE_AUTH_MAP (Untitled3)
- GRADE_ID (등급ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_MANAGER_GRADE.GRADE_ID — NOT NULL
- AUTH_ID (권한ID) — NUMBER(3) — Foreign key → T_HANCOMAUTH_MANAGER_AUTH.AUTH_ID — NOT NULL
- REGISTER_USER_ID (등록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일) — TIMESTAMP — NOT NULL
T_HANCOMAUTH_MENU (Untitled5)
- MENU_ID (매뉴ID) — NUMBER(3) — Primary key — NOT NULL
- UP_MENU_ID (상위 매뉴 ID) — NUMBER(3)
- MENU_NAME (메뉴 이름) — VARCHAR2(255) — NOT NULL
- REGISTER_USER_ID (둥록자) — VARCHAR2(255) — NOT NULL
- MODIFY_DATETIME (수정일자) — TIMESTAMP — NOT NULL
- REGISTER_DATETIME (등록일) — TIMESTAMP — NOT NULL