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)