그룹포털 - 결재

테이블 (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)