시스템
테이블 (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