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)