ksensor

Tables (6)

bulkFile (Bulkfile)

  • bulkFileId (벌크파일ID) — Primary key — NOT NULL
  • datasetId (데이터셋ID2) — Foreign key → dataset.datasetId — NOT NULL

code (공통 코드)

  • codeId (코드ID) — Primary key — NOT NULL
  • cdVal (Field)
  • cdNm (코드명)

dataset (데이터셋)

  • datasetId (데이터셋ID) — Primary key — NOT NULL

dataset sensor (데이터셋센서)

  • datasetSensorId (데이터셋센서ID) — Primary key — NOT NULL
  • datasetId (데이터셋ID) — Foreign key → dataset.datasetId — NOT NULL
  • sensorId (센서ID) — Foreign key → sensor.sensorId — NOT NULL
  • sensorTypeCd (센서유형코드)
  • dataTypeCd (데이터유형코드)

dataset sensor param (데이터셋센서파람)

  • datasetSensorParamId (파람ID) — Primary key — NOT NULL
  • datasetSensorId (데이터셋센서ID) — Foreign key → dataset sensor.datasetSensorId — NOT NULL

sensor (센서)

  • sensorId (센서ID) — Primary key — NOT NULL