角色-权限关联表ROLE_PERM_REL
ID VARCHAR2(32)ROLE_ID VARCHAR2(32)PERM_ID VARCHAR2(32)
PERM_ID=PERM_ID1:N
用户信息表USER_INFO
USER_ID VARCHAR2(32)USER_NAME VARCHAR2(100)DEPT_CODE VARCHAR2(20)USER_STATUS VARCHAR2(20) LOGIN_ACCOUNT VARCHAR2(50)
RESOURCE_ID=RESOURCE_IDN:1
用户-角色关联表USER_ROLE_REL
ID VARCHAR2(32)USER_ID VARCHAR2(32)ROLE_ID VARCHAR2(32)ASSIGN_ORGN_CODE VARCHAR2(20) ASSIGNED_USER_ID VARCHAR2(32)
资源信息表RESOURCE_INFO
RESOURCE_ID VARCHAR2(32)RESOURCE_NAME VARCHAR2(100)RESOURCE_TYPE VARCHAR2(20)RESOURCE_CODE VARCHAR2(50)
部门信息表DEPT_INFO
DEPT_CODE VARCHAR2(20)DEPT_NAME VARCHAR2(100)PARENT_DEPT_CODE VARCHAR2(20)DEPT_LEVEL NUMBER(2)IS_LEAF NUMBER(1)
ROLE_ID=ROLE_ID1:N
权限信息表PERMISSION_INFO
PERM_ID VARCHAR2(32)PERM_NAME VARCHAR2(100)PERM_CODE VARCHAR2(50) RESOURCE_ID VARCHAR2(32)OPERATION_TYPE VARCHAR2(20)IS_ENABLED NUMBER(1)
USER_ID=USER_ID1:N
角色信息表ROLE_INFO
ROLE_ID VARCHAR2(32)ROLE_NAME VARCHAR2(100)ROLE_TYPE VARCHAR2(20)
ASSIGN_ORGN_CODE=DEPT_CODE1:N
