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