시스템

테이블 (7)

MC_SYSTEM_AUTHGROUP (Untitled7)

  • AUTHGROUP_PK — 기본 키 — NOT NULL
  • AUTHGROUP_NAME

MC_SYSTEM_AUTHGROUPMENU (Untitled6)

  • AUTHGROUPMENU_PK — 기본 키 — NOT NULL
  • AUTHGROUPUSERS_PK — 외래 키 → MC_SYSTEM_AUTHGROUPUSERS.AUTHGROUPUSERS_PK — NOT NULL
  • AUTHGROUP_PK (AUTHGROUP_PK2) — 외래 키 → MC_SYSTEM_AUTHGROUPUSERS.AUTHGROUP_PK — NOT NULL
  • USERNAME — 외래 키 → MC_SYSTEM_AUTHGROUPUSERS.USERNAME — NOT NULL
  • AUTHGROUP_PK
  • MENU_PK
  • USE_YN
  • SEARCH_YN
  • SAVE_YN
  • DELETE_YN
  • ADD_YN
  • REMOVE_YN
  • REVISION_YN
  • CREATE_YN
  • NEW_YN

MC_SYSTEM_AUTHGROUPUSERS (Untitled5)

  • AUTHGROUPUSERS_PK — 기본 키 — NOT NULL
  • AUTHGROUP_PK (AUTHGROUP_PK2) — 외래 키 → MC_SYSTEM_AUTHGROUP.AUTHGROUP_PK — NOT NULL
  • USERNAME — 외래 키 → MC_USER.USERNAME — NOT NULL
  • AUTHGROUP_PK
  • USERS_NAME

MC_SYSTEM_AUTHMENU (Untitled4)

  • AUTHMENU_PK — 기본 키 — NOT NULL
  • MENU_PK (MENU_PK2) — 외래 키 → MC_SYSTEM_MENU.MENU_PK — NOT NULL
  • MENU_PK
  • USERS_PK
  • USE_YN
  • SEARCH_YN
  • SAVE_YN
  • DELETE_YN
  • ADD_YN
  • REMOVE_YN
  • REVISION_YN
  • CREATE_YN
  • NEW_YN

MC_SYSTEM_CODE (Untitled3)

  • CODE_PK — 기본 키 — NOT NULL
  • CODE_VALUE
  • CODE_NAME
  • PARENT_CODE_PK
  • CODE_SORT
  • CODE_TYPE
  • CODE_ATTR1
  • CODE_ATTR2
  • CODE_ATTR3

MC_SYSTEM_MENU (Untitled2)

  • MENU_PK — 기본 키 — NOT NULL
  • PARENT_MENU_PK
  • NS_NAME
  • CS_NAME
  • MENU_TYPE
  • MENU_KIND
  • PARAMS_YN
  • PARAMS
  • MENU_NAME
  • MENU_SORT
  • USE_YN
  • APP_YN
  • MENU_URL

MC_USER (Untitled)

  • USERNAME — 기본 키 — NOT NULL
  • EMAIL
  • PHONENUMBER
  • ADDRESS
  • MEMBERNAME
  • ENTERPRISE
  • AUTHGROUP
  • DEPART
  • RANK