CMS_AUTHORITY_INFO
Tables (3)
CMS_AUTHORITY_HISTORY
- HISTORY_NUM — INT(autoincrement) — Primary key — NOT NULL
- ROLE_ID (ROLE_ID2) — VARCHAR(15) — Foreign key → CMS_AUTHORITY_INFO.ROLE_ID — NOT NULL
- CHANGE_TYPE — VARCHAR(1)
- CHANGE_DT — DATETIME
- CHANGER_ID — VARCHAR(500)
CMS_AUTHORITY_INFO
- ROLE_ID — VARCHAR(15) — Primary key — NOT NULL
- ROLE_NAME_KOR (ROLE_NAME) — VARCHAR(25)
- ROLE_NAME_ENG — VARCHAR(25)
- CATEGORY — VARCHAR(10)
- REG_DT — DATETIME
- REG_ID — VARCHAR(500)
- DESCRIPTION (DESCIPTION) — VARCHAR(250)
- IS_ENABLE — VARCHAR(1)
- MENU_LIST — VARCHAR(500)
CMS_MENU_AUTHORITY (Untitled)