bzp
Tables (11)
AUTH_GROUP (권한 그룹)
- PK (ID) — Primary key — NOT NULL
- FK (CORP_ID) — Foreign key → CORP.PK — NOT NULL
- 권한그룹명 (AUTH_GROUP_NM)
- 권한그룹 타입 (AUTH_GROUP_TYPE)
AUTH_GROUP_DEPT (권한그룹-부서)
- PK (ID) — Primary key — NOT NULL
- FK (AUTH_GROUP_ID) — Foreign key → AUTH_GROUP.PK — NOT NULL
- FK (DEPT_ID) — Foreign key → DEPT.PK — NOT NULL
AUTH_GROUP_MENU (권한그룹-메뉴)
- PK (ID) — Primary key — NOT NULL
- FK (AUTH_GROUP_ID) — Foreign key → AUTH_GROUP.PK — NOT NULL
- FK (MENU_ID) — Foreign key → CORP_MENU.PK — NOT NULL
- 기능권한타입 (FUNC_AUTH_TYPE)
- 조회범위 (Field)
AUTH_GROUP_USER (권한그룹-사용자)
- PK (ID) — Primary key — NOT NULL
- FK (AUTH_GROUP_ID) — Foreign key → AUTH_GROUP.PK — NOT NULL
- FK (CORP_USER_ID) — Foreign key → CORP_USER.PK — NOT NULL
CORP (회사)
- PK (ID) — Primary key — NOT NULL
- 그룹ID (CORP_GROUP_ID)
- 회사명 (CORP_NM)
CORP_MENU (회사별메뉴)
- PK (ID) — Primary key — NOT NULL
- FK (MENU_ID) — Foreign key → MENU.PK — NOT NULL
- 회사ID (CORP_ID)
CORP_USER (회사사용자)
- PK (ID) — Primary key — NOT NULL
- FK (USERS_ID) — Foreign key → USERS.PK — NOT NULL
- 회사관리자여부 (IS_ADMIN)
DEPT (부서)
- PK (ID) — Primary key — NOT NULL
- FK (CORP_ID) — Foreign key → CORP.PK — NOT NULL
DEPT_USER (부서사용자)
- PK (ID) — Primary key — NOT NULL
- FK (DEPT_ID) — Foreign key → DEPT.PK — NOT NULL
- FK (USERS_ID) — Foreign key → USERS.PK — NOT NULL
- Field
MENU (메뉴)
- PK (ID) — Primary key — NOT NULL
- 권한 (AUTH)
- 기능권한 (FUNC_AUTH_TYPE)
USERS (사용자)
- PK (ID) — Primary key — NOT NULL
- 그룹관리자여부 (IS_ADMIN)