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