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