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)