RoleERP

Tables (10)

AUTH_INFO (사용자권한테이블)

  • roleId (Key) — Foreign key → ROLE_MST.roleId — NOT NULL
  • empNo (Key2) — Foreign key → EMP_INFO.empNo — NOT NULL

EMP_INFO (사요자 테이블)

  • empNo (Key) — Primary key — NOT NULL

ROLE_MST (권한 테이블)

  • roleId (Key) — Primary key — NOT NULL

SBButtonAuthInfo (버튼권한 테이블(new))

  • buttonId (Key) — Foreign key → SBUIButton.buttonId — NOT NULL
  • roleId (Key2) — Foreign key → ROLE_MST.roleId — NOT NULL
  • viewId (Key3) — Foreign key → SBUIButton.viewId — NOT NULL

SBMenuAuthInfo (메뉴권한테이블)

  • roleId (Key) — Foreign key → ROLE_MST.roleId — NOT NULL
  • menuId (Key2) — Foreign key → SBMenuInfo.menuId — NOT NULL

SBMenuInfo (메뉴테이블)

  • menuId (Key) — Primary key — NOT NULL
  • viewId (Key2) — Foreign key → SBUIView.viewId — NOT NULL

SBTaskAuthInfo (작업권한테이블)

  • roleId (Key) — Foreign key → ROLE_MST.roleId — NOT NULL
  • mathod (Key2) — Foreign key → SBTaskInfo.mathod — NOT NULL
  • Key2 (Key22) — Foreign key → SBTaskInfo.path — NOT NULL

SBTaskInfo (작업 테이블)

  • mathod (Key) — Primary key — NOT NULL
  • path (Key2) — Primary key — NOT NULL

SBUIButton (버튼 테이블(new))

  • buttonId (Key) — Primary key — NOT NULL
  • viewId (Key3) — Foreign key → SBUIView.viewId — NOT NULL
  • buttonNm (Field)
  • mathod (Key2) — Foreign key → SBTaskInfo.mathod — NOT NULL
  • path (Key22) — Foreign key → SBTaskInfo.path — NOT NULL

SBUIView (화면 테이블(new))

  • viewId (Key) — Primary key — NOT NULL
  • viewNm (Field)
  • desc (Field2)
  • isPopup (Field3)