ATC+

테이블 (21)

CAM1 데이터 (TN_CAM1_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM2 데이터 (TN_CAM2_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM3 데이터 (TN_CAM3_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM4 데이터 (TN_CAM4_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM5 데이터 (TN_CAM5_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM6 데이터 (TN_CAM6_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

CAM7 데이터 (TN_CAM7_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

ICT 조사장치 데이터 (TN_ICT_RAWDATA)

  • 수집ID (COLLECT_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • 수정일자 (UPDT_YMD) — TIMESTAMP
  • 폴더명 (FOLDER_NM) — VARCHAR(20)
  • Field

LiDAR 데이터 (TN_LIDAR_RAWDATA)

  • PCD ID (PCD_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)

멀티카메라_이미지프로세싱_프로젝트 (MULTICAM_IMGPROC_PROJECT)

  • 프로젝트ID (PRJ_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 프로젝트명 (PRJ_NM) — VARCHAR(60)
  • 폴더ID (FOLDER_ID) — VARCHAR(100)
  • 작업단계 (TASK_STTUS) — VARCHAR(10)
  • 등록일시 (REG_DT) — timestamp
  • 수정일시 (MDFCN_DT) — timestamp
  • 영상좌표계 (ORG_SRID) — NUMERIC(10)
  • 영상지오이드고 (ORG_GEOID) — VARCHAR(10)
  • 이미지해상도 (IMG_RES) — VARCHAR(10)
  • 삭제여부 (DEL_YN) — VARCHAR(1)

이미지프로세싱_폴더 (IMGPROC_FOLDER)

  • 폴더ID (FOLDER_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 폴더명 (FOLDER_NM) — VARCHAR(20)
  • Field

정제 스테레오 카메라 전처리 (TN_RFN_STEREOCAM)

  • ST이미지ID (STIMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • LEasting (LEAST_X) — NUMERIC(7,11)
  • LNorthing (LNORTH_Y) — NUMERIC(7,11)
  • LUp (LUP_Z) — NUMERIC(7,11)
  • LRoll (LROLL) — NUMERIC(7,11)
  • LPitch (LPITCH) — NUMERIC(7,11)
  • LYaw (LYAW) — NUMERIC(7,11)
  • L파일경로 (LFILE_PATH) — VARCHAR(2000)
  • REasting (REAST_X) — NUMERIC(7,11)
  • RNorthing (RNORTH_Y) — NUMERIC(7,11)
  • RUp (RUP_Z) — NUMERIC(7,11)
  • RRoll (RROLL) — NUMERIC(7,11)
  • RPitch (RPITCH) — NUMERIC(7,11)
  • RYaw (RYAW) — NUMERIC(7,11)
  • R파일경로 (RFILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)
  • 입면정사영상 (FORTHO_PATH) — VARCHAR(2000)
  • 수치표면모델 (DSM_PATH) — VARCHAR(2000)

정제 파노라마 데이터 (TN_RFN_PANO360)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM1 데이터 (TN_RFN_CAM1_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM2 데이터 (TN_RFN_CAM2_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM3 데이터 (TN_RFN_CAM3_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM4 데이터 (TN_RFN_CAM4_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM5 데이터 (TN_RFN_CAM5_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM6 데이터 (TN_RFN_CAM6_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제CAM7 데이터 (TN_RFN_CAM7_RAWDATA)

  • 이미지ID (IMG_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집정제ID — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → 정제가공관리.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • GPSTime (GPS_TIME) — NUMERIC(10,10)
  • Easting (EAST_X) — NUMERIC(7,11)
  • Northing (NORTH_Y) — NUMERIC(7,11)
  • Up (UP_Z) — NUMERIC(7,11)
  • Roll (ROLL) — NUMERIC(7,11)
  • Pitch (PITCH) — NUMERIC(7,11)
  • Yaw (YAW) — NUMERIC(7,11)
  • Rotation_00 (R00) — NUMERIC(7,11)
  • Rotation_01 (R01) — NUMERIC(7,11)
  • Rotation_02 (R02) — NUMERIC(7,11)
  • Rotation_10 (R10) — NUMERIC(7,11)
  • Rotation_11 (R11) — NUMERIC(7,11)
  • Rotation_12 (R12) — NUMERIC(7,11)
  • Rotation_20 (R20) — NUMERIC(7,11)
  • Rotation_21 (R21) — NUMERIC(7,11)
  • Rotation_22 (R22) — NUMERIC(7,11)
  • 파일경로 (FILE_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)

정제가공관리 (TN_RFN_PROMGMT)

  • 수집정제ID (COLLECT_RFN_ID) — VARCHAR(100) — 기본 키 — NOT NULL
  • 수집ID (COLLECT_ID) — VARCHAR(100) — 외래 키 → ICT 조사장치 데이터.수집ID — NOT NULL
  • 등록일자 (REGIST_YMD) — TIMESTAMP
  • 수정일자 (UPDT_YMD) — TIMESTAMP
  • 폴더명 (FOLDER_NM) — VARCHAR(20)
  • 폴더경로 (FOLDER_PATH) — VARCHAR(2000)
  • 정제거리 (RFN_DST) — NUMERIC(3,10)