드론GPS
테이블 (8)
TB_DRON
- DN_OID — VARCHAR(12) — 기본 키 — NOT NULL
- DN_NAME — VARCHAR(12) — NOT NULL
- DN_DESC — VARCHAR(12) — NOT NULL
TB_DRONPROJECT
- DP_OID — VARCHAR(12) — 기본 키 — NOT NULL
- DN_OID — VARCHAR(12) — 외래 키 → TB_DRON.DN_OID — NOT NULL
- US_UID — VARCHAR(20) — 외래 키 → TB_USER.US_UID — NOT NULL
- DP_NAME — VARCHAR(30) — NOT NULL
- DP_STATUS — VARCHAR(1) — NOT NULL
- DP_CNT — INTEGER — NOT NULL
- DP_COMPCNT — INTEGER — NOT NULL
- DP_DESC — VARCHAR(255)
- DP_USE — VARCHAR(1) — NOT NULL
- INS_DT — TIMESTAMP — NOT NULL
- COMP_DT — TIMESTAMP
TB_IMGMETA
- IM_OID — VARCHAR(14) — 기본 키 — NOT NULL
- DP_OID — VARCHAR(12) — 외래 키 → TB_DRONPROJECT.DP_OID — NOT NULL
- IM_NAME — VARCHAR(20) — NOT NULL
- IM_EXT — VARCHAR(20) — NOT NULL
- IM_ADRES — VARCHAR(200) — NOT NULL
- IM_W — INTEGER — NOT NULL
- IM_H — INTEGER — NOT NULL
- IM_GPSX — DOUBLE — NOT NULL
- IM_GPSY — DOUBLE — NOT NULL
- IM_GPSZ — DOUBLE — NOT NULL
- IM_VFOV — DOUBLE
- IM_HFOV — DOUBLE
- IM_YAW — DOUBLE — NOT NULL
- IM_PITCH — DOUBLE — NOT NULL
- IM_ROLL — DOUBLE — NOT NULL
- IM_GYAW — DOUBLE — NOT NULL
- IM_GPITCH — DOUBLE — NOT NULL
- IM_GROLL — DOUBLE — NOT NULL
- IM_DESC — VARCHAR(255)
- IM_STATUS — VARCHAR(1) — NOT NULL
- IM_USE — VARCHAR(1) — NOT NULL
- INS_DT — TIMESTAMP — NOT NULL
TB_IMGRESULT
- IR_OID — VARCHAR(16) — 기본 키 — NOT NULL
- DP_OID — VARCHAR(12) — 외래 키 → TB_DRONPROJECT.DP_OID — NOT NULL
- IM_OID — VARCHAR(14) — 외래 키 → TB_IMGMETA.IM_OID — NOT NULL
- IR_X1 — INTEGER — NOT NULL
- IR_Y1 — INTEGER — NOT NULL
- IR_X2 — INTEGER — NOT NULL
- IR_Y2 — INTEGER — NOT NULL
- IR_CLASS — INTEGER — NOT NULL
- IR_REAL_X — DOUBLE — NOT NULL
- IR_REAL_Y — DOUBLE
- IR_REAL_Z — DOUBLE
- INS_DT — TIMESTAMP
TB_USER
- US_UID — VARCHAR(20) — 기본 키 — NOT NULL
- US_PWD — VARCHAR(50) — NOT NULL
- US_NAME — VARCHAR(30) — NOT NULL
- US_DESC — VARCHAR(255) — NOT NULL
- INS_DT — TIMESTAMP
- EDT_DT — TIMESTAMP
- LOGIN_DT — TIMESTAMP
chuncheon_dem
- rid — integer — NOT NULL
- rast — raster
- gangwon-do_pkey — PRIMARY
- 10) — =
- 10) — =
chuncheon_dem_tin
- geom — geometry
- ins_dt — timestamp
- src_dem — text
spatial_ref_sys
- srid — integer — 기본 키 — NOT NULL
- auth_name — character
- auth_srid — integer
- srtext — character
- proj4text — character