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)