드론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