권한설정 관련 테이블 관계도
테이블 (14)
API 토큰 정보 (cube_api_info)
- api_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- api_desc — varchar(255)
- api_token — varchar(255)
- api_type — varchar(255)
- end_date — datetime(6)
- name — varchar(255)
- use_yn — char(1) — NOT NULL
API토큰정보<->테이블 권한 맵핑 (cube_api_mapping_permission)
- mapping_id — bigint — 기본 키 — NOT NULL
- api_id — bigint — 외래 키 → API 토큰 정보.api_id — NOT NULL
- permission_id — bigint — 외래 키 → 테이블 권한(CRUDP).permission_id — NOT NULL
cube_menu
- menu_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- internal_link — char(1) — NOT NULL
- login — char(1) — NOT NULL
- menu_name — varchar(255) — NOT NULL
- popup — char(1) — NOT NULL
- priority — int — NOT NULL
- sort — int — NOT NULL
- url — varchar(255) — NOT NULL
- visible — char(1) — NOT NULL
- parent_id — bigint — 외래 키 → cube_menu.menu_id
- site_id — bigint — 외래 키 → cube_menu_site.site_id — NOT NULL
- group_id — bigint — 외래 키 → cube_menu_group.group_id — NOT NULL
cube_menu_group
- group_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- group_key — varchar(255) — NOT NULL
- group_name — varchar(255) — NOT NULL
- site_id — bigint — 외래 키 → cube_menu_site.site_id — NOT NULL
cube_menu_site
- site_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- domain — varchar(255)
- site_key — varchar(255) — NOT NULL
- site_name — varchar(255) — NOT NULL
권한정보 (cube_role)
- role_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- description — varchar(255)
- name — varchar(255) — NOT NULL
- use_yn — char(1) — NOT NULL
권한정보<->그룹정보 맵핑 (cube_group_role)
- group_role_id — bigint — 기본 키 — NOT NULL
- role_id (role_id2) — bigint — 외래 키 → 권한정보.role_id — NOT NULL
- group_id — bigint — 외래 키 → 그룹정보.group_id — NOT NULL
권한정보<->테이블 권한 맵핑 (cube_role_permission)
- mapping_id — bigint — 기본 키 — NOT NULL
- permission_id — bigint — 외래 키 → 테이블 권한(CRUDP).permission_id — NOT NULL
- role_id — bigint — 외래 키 → 권한정보.role_id — NOT NULL
그룹정보 (cube_group)
- group_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- group_desc — varchar(120)
- group_nm — varchar(255) — NOT NULL
사용자정보 (cube_user)
- user_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- birthday — char(10)
- blood — varchar(6)
- branch — varchar(20)
- career — varchar(5)
- department — varchar(255)
- display_mode — varchar(10)
- email — varchar(250) — NOT NULL
- email_accept — char(1)
- expiry_date — datetime(6)
- gender — char(1)
- handicap — varchar(5)
- language_setting — char(2)
- last_access_time — datetime(6)
- last_change_time — datetime(6)
- mms_accept — char(1)
- name — varchar(50) — NOT NULL
- note — varchar(150)
- password — varchar(255)
- phone — varchar(255)
- profile_url — varchar(255)
- refresh_token — varchar(255)
- role — varchar(15)
- service_user_id — varchar(50)
- token — varchar(255)
- use_alarm — char(1) — NOT NULL
- user_status — char(2)
- user_type — varchar(10)
사용자정보<->그룹정보 맵핑 (cube_group_user)
- mapping_id — bigint — 기본 키 — NOT NULL
- group_id — bigint — 외래 키 → 그룹정보.group_id — NOT NULL
- user_id — bigint — 외래 키 → 사용자정보.user_id — NOT NULL
테이블 권한(CRUDP) (cube_permission)
- permission_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- action — varchar(255) — NOT NULL
- content_type — varchar(255) — NOT NULL
- table_name — varchar(255) — NOT NULL
폴더정보 (cube_folder)
- folder_id — bigint — 기본 키 — NOT NULL
- mod_date — datetime(6)
- mod_user_id — bigint
- reg_date — datetime(6) — NOT NULL
- reg_user_id — bigint
- asset_type — char(1)
- description — varchar(255)
- is_current_folder — char(1)
- is_use_date — char(1)
- meta_group_id — bigint
- org_id — bigint
- parent_id — bigint
- preset_yn — char(1) — NOT NULL
- title — varchar(255)
- trash_view_yn — char(1) — NOT NULL
- use_yn — char(1) — NOT NULL
- preset_id — int
- sort — int
폴더정보<->그룹정보 맵핑 (cube_folder_auth)
- folder_auth_id — bigint — 기본 키 — NOT NULL
- group_id — bigint — 외래 키 → 그룹정보.group_id — NOT NULL
- folder_id — bigint — 외래 키 → 폴더정보.folder_id — NOT NULL