org

Tables (5)

mngr_info (매니저정보)

  • mngr_sn (매니저 번호) — Primary key — NOT NULL
  • org_sn (조직번호)
  • org_cd (조직코드)
  • mngr_id (매니저이름) — varchar
  • mngr_phone (전화번호) — varchar

org_info (조직정보)

  • org_sn (조직번호) — int — Primary key — NOT NULL
  • org_cd (조직코드) — varchar — Primary key — NOT NULL
  • org_root_sn (최상단조직번호) — int
  • org_parent_sn (부모조직번호) — int
  • org_sort (정렬번호) — int
  • org_nm (조직명) — varchar
  • org_head_id (조직본부아이디(코드)) — varchar
  • create_dt (생성일) — date

org_perm_def (조직별권한정의)

  • org_cd (조직코드) — Primary key — NOT NULL
  • perm_id (권한 아이디) — Primary key — NOT NULL
  • perm_yn (Field)

perm_code (권한코드정보)

  • perm_id (권한아이디) — Primary key — NOT NULL
  • perm_cd_nm (권한명)
  • perm_type (권한유형)
  • perm_desc (권한설명)

perm_mappng (권한매핑)

  • perm_sn (권한번호) — Primary key — NOT NULL
  • perm_id (권한아이디)
  • perm_yn (권한허용 여부)
  • create_dt (생성일)