그룹포털 - 결재
테이블 (3)
Untitled (USR_GLOBAL)
- Key (USER_ID) — 기본 키 — NOT NULL
- Field (DEPT_ID)
- Field2 (DEPT_NAME)
- Field3 (COMMUNITY_ID)
- Field4 (SV_ID)
- Field5 (NAMES)
- Field6 (LINE_ORDER)
- Field7 (STATUS)
- Field8 (LICENSE)
- Field9 (MNGR_TYPEABS_F)
- Field10 (AUDIT_F)
- Field11 (LOG_MAKE_F)
- Field12 (NEW_COUNT_F)
- Field13 (UNREAD_COUNT_F)
- Field14 (TOTAL_COUNT_F)
- Field15 (SEXS)
- Field16 (SANC_BOX_F)
- Field17 (RECV_SEND_F)
- Field18 (SANC_PASSWD_CHK_F)
- Field19 (NOTY_TYPE)
- Field20 (ANC_RET_NOTY_F)
- Field21 (ANC_END_NOTY_F)
- Field22 (MAIL_NOTY_TYPE_F)
- Field23 (MAIL_NOTY_B)
- Field24 (BOARD_NOTY_F)
- Field25 (SANC_ARV_NOTY_F)
- Field26 (SANC_PROC_NOTY_F)
- Field27 (GSCH_NOTY_F)
- Field28 (SMS_MAIL_NOTY_F)
- Field29 (SMS_GSCH_NOTY_F)
- Field30 (SMS_BBOARD_NOTY_F)
- Field31 (SMS_RET_NOTY_F)
- Field32 (SMS_ENC_NOTY_F)
- Field33 (SMS_ARV_NOTY_F)
- Field34 (SMS_PROC_NOTY_F)
- Field35 (SMS_END_NOTY_F)
- Field36 (CLOUD_NOTY_F)
- Field37 (MENU_TYPE)
- Field38 (SEC_LEVEL)
- Field39 (SEQ)
- Field40 (LOCK_F)
- Field41 (IN_CONTROLLER_F)
- Field (OUT_CONTROLLER_F)
- Field2 (SIGNER_F)
- Field3 (MAIL_ALT_RECV_F)
- Field4 (SANC_ALT_RECV)
- Field5 (SANC_ALT_rECV2)
- Field6 (SYSTEM_LOG_F)
- Field7 (PASSWD_FAIL_COUNT)
- Field (PASSWD_DATE)
- Field2 (OTHER_OFFICE_F)
- Field3 (REPORT_CONTROL_F)
- Field4 (LAW_CONTROL_F)
- Field5 (AUTO_AGREE_F)
- Field6 (EMP_CODE)
- Field8 (EMP_CODE2)
- Field9 (POS_ID)
- Field10 (RANK_ID)
- Field11 (DUTY_ID)
- Field12 (DUTY_NAME)
- … +24
부서트리 (DEPT_TREE)
- Key (PAR_ID) — 기본 키 — NOT NULL
- Key2 (DEPT_ID) — 기본 키 — NOT NULL
조직도 (DEPT_GLOBAL)
- 커뮤니티 ID (COMUNITY_ID) — Char — 기본 키 — NOT NULL
- 부서 ID (DEPT_ID) — Char — 기본 키 — NOT NULL
- 서버ID (SV_ID)
- 부서명 (DEPT_NAME)
- Field3 (DEPT_NAME2)
- Field4 (PAR_ID)
- Field5 (SEQ)
- Field6 (REP_F)
- Field7 (RECV_BOX_f)
- Field8 (BOX_F)
- Field9 (STATUS)
- 감사부서여부 (AUDIT_F)
- Field11 (LOG_MAKE_F)
- Field (INKE_DEPT_F)
- Field2 (IN_CONTROLLER_F)
- Field3 (OUT_CONTROLLER_F)
- Field4 (SYSTEM_LOG_F)
- Field5 (ABBREVIATION)
- Field6 (ABBREVIATION2)
- Field (DEPT_CODE)
- Field2 (NUMBERING)
- Field3 (EPT_NUMBERING_FSENDER1)
- Field4 (SENDER2)
- Field5 (REP_DEPT_ID)
- Field6 (STAT_DEPT_ID)
- Field7 (MODIFY_USER_ID)
- Field8 (MODIFY_DATE)
- Field9 (COUNTRY_CODE)
- Field10 (TIME_DIFF)
- Field11 (FAX)
- Field12 (HOME_URL)
- Field13 (E_MAIL)
- Field14 (PHONE)
- Field15 (ZIP)
- Field (ADDRESS)
- Field2 (ADDRESS2)
- Field3 (INTRO)
- Field4 (REPORT_CONTROL_F)
- Field5 (LAW_CONTROL_F)
- Field6 (USE_EDMS_F)
- Field7 (SITE_ID)
- Field (DEPT_FLOW_END_f)
- Field2 (DEPT_NAME_ENG)
- Field3 (LOCALE)
- Field4 (OMPLIANCE_F)