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