ERD_181129

델파이 교육 중 데이터베이스 교육에 사용 될 DB의 ERD

테이블 (5)

Channel (channel)

  • Channel ID (chid) — Integer — 기본 키 — NOT NULL
  • Channel Axis (chaxis) — Char(10)
  • Channel Name (chname) — Char(100)
  • Sensor ID (sensorid) — Integer — 외래 키 → Sensor.Sensor ID — NOT NULL
  • Logger ID (loggerid) — Integer — 외래 키 → Data Logger.Logger ID — NOT NULL
  • Logger Index (loggerindex) — Integer

Data (data)

  • Date (datetime) — Timestamp — 기본 키 — NOT NULL
  • Channel ID (chid) — Integer — 외래 키 → Channel.Channel ID — NOT NULL
  • RMS (rms) — Double
  • Average (avg) — Double
  • Minimum (min) — Double
  • Maximum (max) — Double

Data Logger (logger)

  • Logger ID (loggerid) — Integer — 기본 키 — NOT NULL
  • Logger Name (loggername) — Char(100)
  • Logger Serial Number (loggerserial) — Char(100)
  • IP (ip) — Char(15)
  • Port (port) — Integer
  • Sampling (sampling) — Integer
  • SIte ID (siteid) — Integer — 외래 키 → Site (Location).SIte ID — NOT NULL

Sensor (sensor)

  • Sensor ID (sensorid) — Integer — 기본 키 — NOT NULL
  • Axis Count (axiscount) — Integer
  • Sensor Name (sensorname) — Char(100)
  • Sensor Serial Number (sensorserial) — Char(100)

Site (Location) (site)

  • SIte ID (siteid) — Integer — 기본 키 — NOT NULL
  • Site Name (sitename) — Char(100)