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)