kvx_admin
Tables (5)
Copy Of ad_menu_auth (CopyOf유저 메뉴별 권한관리 정보)
- (auth_idx) — int — Primary key — NOT NULL
- (menu_idx) — int — Foreign key → ad_menu.menu_idx — NOT NULL
- (ad_user_idx) — int
- (auth_yn) — tinyint
- (isdel) — tinyint
- (inserttime) — date
- (insert_user_id) — int
- (updatetime) — date
- (update_user_id) — int
ad_function (어드민 메뉴별 기능정보)
- (func_idx) — int — Primary key — NOT NULL
- (menu_idx) — int — Foreign key → ad_menu.menu_idx — NOT NULL
- (func_name) — varchar
- (func_code) — varchar
- (isdel) — tinyint
- (inserttime) — date
- (insert_user_id) — int
- (updatetime) — date
- (update_user_id) — int
ad_member_auth (유저별 권한관리 정보)
- (auth_idx) — int — Primary key — NOT NULL
- (func_idx) — int — Foreign key → ad_function.func_idx — NOT NULL
- (menu_idx) — int — Foreign key → ad_menu.menu_idx — NOT NULL
- (ad_user_idx) — int
- (use_type) — tinyint
- (auth_yn) — tinyint
- (isdel) — tinyint
- (inserttime) — date
- (insert_user_id) — int
- (updatetime) — date
- (update_user_id) — int
ad_menu (어드민 메뉴정보)
- (menu_idx) — int — Primary key — NOT NULL
- (menu_name) — varchar
- (menu_url) — varchar
- (menu_depth) — smalint
- (menu_parent) — int
- (munu_order) — int
- (isdel) — tinyint
- (inserttime) — date
- (insert_user_id) — int
- (updatetime) — date
- (update_user_id) — int
ad_menu (CopyOf어드민 메뉴정보)
- (menu_idx) — int — Primary key — NOT NULL
- (use_type) — tinyint
- (menu_name) — varchar
- (menu_url) — varchar
- (menu_parent) — int
- (munu_order) — int
- (func_name) — varchar
- (func_ename) — varchar
- (inserttime) — date
- (isdel) — tinyint
- (insert_user_id) — int
- (updatetime) — date
- (update_user_id) — int