test

Tables (5)

tb_sys_auth

  • auth_id — character — NOT NULL
  • upd_dttm — timestamp
  • inpr_id — character
  • rgst_dttm — timestamp
  • modfr_id — character
  • use_yn — character(1)
  • auth_explan — character
  • auth_nm — character
  • exrs_yn — character(1)
  • mark_sequence — numeric(10,0)
  • menu_site_cd — character
  • user_div_cd — character
  • hgrn_auth_id — character

tb_sys_auth_menu

  • auth_id — character — Primary key — NOT NULL
  • menu_id — character — Primary key — NOT NULL
  • mng_yn — character(1)
  • read_yn — character(1)
  • write_yn — character(1)

tb_sys_menu

  • menu_id — character — NOT NULL
  • upd_dttm — timestamp
  • inpr_id — character
  • rgst_dttm — timestamp
  • modfr_id — character
  • use_yn — character(1)
  • display_mark_yn — character(1)
  • mark_sequence — numeric(10,0)
  • menu_div_cd — character
  • menu_istc — character
  • menu_level — numeric(10,0)
  • menu_nm — character
  • menu_site_cd — character
  • tab_menu_use_yn — character(1)
  • url_addr — character
  • upper_menu_id — character

tb_sys_menu_admin

  • admin_id — character — NOT NULL
  • upd_dttm — timestamp
  • inpr_id — character
  • rgst_dttm — timestamp
  • modfr_id — character
  • use_yn — character(1)
  • admin_dept_nm — character — NOT NULL
  • admin_user_nm — character — NOT NULL
  • telno — character
  • user_id — character — NOT NULL
  • menu_id — character — NOT NULL

tb_sys_user

  • user_uid — character — NOT NULL
  • upd_dttm — timestamp
  • inpr_id — character
  • rgst_dttm — timestamp
  • modfr_id — character
  • use_yn — character(1)
  • activation_end_date — timestamp
  • activation_start_date — timestamp
  • active_yn — character(1)
  • approval_yn — character(1)
  • email_addr — character
  • emp_no — character
  • final_login_dt — timestamp
  • final_login_ip — character
  • ip_addr — character
  • job_duty — character
  • job_rank — character
  • join_dt — timestamp
  • login_fail_cnt — numeric(10,0)
  • mac_addr — character
  • mobile_telno — character
  • office_telno — character
  • password — character — NOT NULL
  • password_altr_dt — timestamp
  • rtrc_resn — character
  • sso_yn — character(1)
  • trgt_dptcd — character
  • user_div_cd — character
  • user_id — character — NOT NULL
  • user_nm — character