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