cms_hub
Tables (6)
MS_GROUP
- GROUP_ID — NUMBER — Primary key — NOT NULL
- GROUP_NAME — VARCHAR2(20) — NOT NULL
- CREATE_USER — NUMBER — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL
MS_MENU
- MENU_ID — NUMBER — Primary key — NOT NULL
- MENU_NAME — VARCHAR2(20) — NOT NULL
- END_POINT — VARCHAR2(100)
- LEVEL — NUMBER — NOT NULL
- PARENT_ID — NUMBER
- MENU_POSITION — NUMBER — NOT NULL
- CREATE_USER — NUMBER — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL
MS_ROLE
- ROLE_GROUP_ID — NUMBER — Primary key — NOT NULL
- ROLE_ID — NUMBER — NOT NULL
- GROUP_ID — NUMBER — NOT NULL
- CREATE_USER — NUMBER — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL
MS_ROLE_MENU_MAPPER
- ROLE_GROUP_ID — NUMBER — Primary key — NOT NULL
- MENU_ID — NUMBER — NOT NULL
- CREATE_USER — NUMBER — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL
MS_USER
- USER_ID — NUMBER — Primary key — NOT NULL
- ROLE_GROUP_ID — NUMBER
- USER_EMAIL — VARCHAR2(30) — NOT NULL
- USER_PASSWORD — VARCHAR2(100) — NOT NULL
- USER_NAME — VARCHAR2(20) — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL
- CREATE_USER — NUMBER — NOT NULL
MS_USER_MENU_MAPPER
- USER_MENU_ID — NUMBER — Primary key — NOT NULL
- USER_ID — NUMBER — NOT NULL
- MENU_ID — NUMBER — NOT NULL
- MENU_NAME — VARCHAR2(20)
- IS_CREATE — VARCHAR2(1)
- IS_READ — VARCHAR2(1)
- IS_UPDATE — VARCHAR2(1)
- IS_DELETE — VARCHAR2(1)
- CREATE_USER — NUMBER — NOT NULL
- CREATE_DATETIME — TIMESTAMP — NOT NULL
- UPDATE_USER — NUMBER — NOT NULL
- UPDATE_DATETIME — TIMESTAMP — NOT NULL