gis
Tables (6)
TB_DEPT (부서 테이블)
- DEPT_ID (부서ID) — VARCHAR2(100) — Primary key — NOT NULL
- DEPT_NM (부서명) — VARCHAR2(100)
TB_MENU (메뉴 관리 테이블)
- MENU_ID (메뉴ID) — VARCHAR2(100) — Primary key — NOT NULL
- MENU_NAME (메뉴명) — VARCHAR2(100)
- MENU_PATH (메뉴경로) — VARCHAR2(255)
- MENU_TYPE (메뉴타입) — VARCHAR2(100)
- MENU_ORDER (메뉴정렬순서) — INT
- PARENT_MENU_ID (상위메뉴ID) — VARCHAR2(100) — Foreign key → TB_MENU.MENU_ID — NOT NULL
TB_PERMISSION (권한 마스터 테이블)
- PERMISSION_ID (권한ID) — INT — Primary key — NOT NULL
- MENU_ID (메뉴ID) — VARCHAR2(100) — Foreign key → TB_MENU.MENU_ID — NOT NULL
- USER_ID (사용자ID) — VARCHAR2(100) — Foreign key → TB_USER_ROLE_MAP.USER_ID — NOT NULL
- ROLE_ID (역할 ID) — VARCHAR2(100) — Foreign key → TB_ROLE.ROLE_ID — NOT NULL
- PLATFORM_TYPE (플랫폼유형) — VARCHAR2(100)
- PERM_ACCESS (메뉴 접근/조회 권한) — CHAR(1)
- PERM_CREATE (버튼:저장/생성 권한) — CHAR(1)
- PERM_UPDATE (버튼:저장/수정 권한) — CHAR(1)
- PERM_DELETE (버튼:삭제 권한) — CHAR(1)
TB_ROLE (권한 관리 역할 테이블)
- ROLE_ID (역할 ID) — VARCHAR2(100) — Primary key — NOT NULL
- ROLE_NAME (역할명) — VARCHAR2(100)
TB_USER (사용자 테이블)
- USER_ID (사용자ID) — VARCHAR2(100) — Primary key — NOT NULL
- DEPT_ID (부서ID) — VARCHAR2(100) — Foreign key → TB_DEPT.DEPT_ID — NOT NULL
- USER_NM (사용자명) — VARCHAR2(100)
- PASSWORD (비밀번호) — VARCHAR2(100)
TB_USER_ROLE_MAP (사용자 권한 매핑테이블)
- USER_ID (사용자ID) — VARCHAR2(100) — Foreign key → TB_USER.USER_ID — NOT NULL
- ROLE_ID (역할 ID) — VARCHAR2(100) — Foreign key → TB_ROLE.ROLE_ID — NOT NULL