gisvc

Tables (3)

TB_CODE_AUTHORITY (권한)

  • IDX (순번) — NUMBER(38,0) — Primary key — NOT NULL
  • AUTHORITY_NAME (권한명) — VARHCHAR2(20)
  • CREATE_ID (생성일자) — DATE

TB_CODE_ROLE (역할)

  • IDX (순번) — NUMBER(38,0) — Primary key — NOT NULL
  • ROLE_NAME (역할명) — VARCHAR2(10)
  • CREATE_ID (생성일자) — DATE

TB_CODE_USERS (유저)

  • IDX (사용자순번) — NUMBER(38,0) — Primary key — NOT NULL
  • USERSIDO (시도) — VARCHAR2(50)
  • USERSGG (시군구) — VARCHAR2(50)
  • USERCODE (지역코드) — VARCHAR2(5)
  • SIDOCODE (시도코드) — VARCHAR2(2)
  • USERGROUP (사용자그룹코드) — VARCHAR2(4)
  • MAPX (X좌표) — VARCHAR2(7)
  • MAPY (Y좌표) — VARCHAR2(7)
  • GUBUN (소속구분) — VARCHAR2(50)
  • WORKXML_ID (보건소XML ID) — VARCHAR2(30)
  • WORKXML_PW (보건소XML PW) — VARCHAR2(30)
  • WORKXML_DES (작업지시) — VARCHAR2(2000)
  • BUILD_YEAR (구축년도) — DATE
  • CREATE_YEAR (생성일자) — DATE
  • CHK_BUILD (구축구분) — VARCHAR2(1)
  • HIDDEN_TIME (작업자별궤적관리시간숨김여부) — VARCHAR2(1)
  • CHEMICAL_TYPE (작업지시 약품 단위 표시) — VARCHAR2(1)