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 (생성일)