Modules v.2
테이블 (18)
A module (Untitled3)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field3) — date — NOT NULL
- Field — int — NOT NULL
- Field2 — int — NOT NULL
- field (Field4) — int — NOT NULL
- field (Field5) — int — NOT NULL
- Field6 — int — NOT NULL
Alarm (Untitled5)
- Alarm_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field4) — date — NOT NULL
- Stage (Field) — Enum — NOT NULL
- Read_status (Field2) — Enum — NOT NULL
- Messege (Field3) — varchar — NOT NULL
- Field5 — varchar — NOT NULL
- update (Field6) — date — NOT NULL
- User_ID (Key2) — Number — 외래 키 → User.User_ID — NOT NULL
B module (CopyOfUntitled3)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field4) — date — NOT NULL
- Field — int — NOT NULL
- Field2 — int — NOT NULL
- Field3 — int — NOT NULL
- Field5 — int — NOT NULL
- Field6 — int — NOT NULL
- Field7 — int — NOT NULL
C module (CopyOfCopyOfCopyOfUntitled3)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field4) — date — NOT NULL
- Field — int — NOT NULL
- Field2 — int — NOT NULL
- Field3 — int — NOT NULL
- Field5 — int — NOT NULL
- Field6 — int — NOT NULL
- field (Field7) — int — NOT NULL
Control_log (Untitled8)
- Control_log_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field) — date — NOT NULL
- Control_Type (Field5) — Enum — NOT NULL
- Field2 — int — NOT NULL
- Field3 — Enum — NOT NULL
- Field4 — time — NOT NULL
- User_ID (Key2) — Number — 외래 키 → User.User_ID — NOT NULL
- Sensor_ID (Key3) — Number — 외래 키 → Sensor.Sensor_ID — NOT NULL
D module (CopyOfCopyOfUntitled3)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field4) — date — NOT NULL
- TOC (Field2) — double — NOT NULL
- TSS (Field3) — double — NOT NULL
- Field — int — NOT NULL
- Field5 — int — NOT NULL
- Field6 — int — NOT NULL
E module (CopyOfCopyOfCopyOfCopyOfUntitled32)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field) — date — NOT NULL
- field (Field2) — int — NOT NULL
- field (Field3) — time — NOT NULL
- field (Field4) — double — NOT NULL
- Field5 — int — NOT NULL
- Field6 — int — NOT NULL
- Field7 — int — NOT NULL
F module (CopyOfCopyOfCopyOfUntitled32)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field) — date — NOT NULL
- field (Field2) — int — NOT NULL
- field (Field3) — time — NOT NULL
- field (Field4) — int — NOT NULL
- Field5 — int — NOT NULL
- Field6 — int — NOT NULL
- Field7 — int — NOT NULL
Module (CopyOfCopyOfUntitled32)
- Module_ID (Key) — Number — 기본 키 — NOT NULL
- field (Field5) — Enum — NOT NULL
- Field — Enum — NOT NULL
- insert (Field2) — date — NOT NULL
- update (Field3) — date — NOT NULL
- Modules_ID (Key2) — Number — 외래 키 → Modules.Modules_ID — NOT NULL
- User_ID (Key3) — Number — 외래 키 → User.User_ID — NOT NULL
- User_ID (Key4) — Number — 외래 키 → User.User_ID — NOT NULL
ModuleData_log (CopyOfUntitled32)
- Data_log_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field3) — date — NOT NULL
- field (Field5) — Enum — NOT NULL
- Field6 — int — NOT NULL
- Module_ID (Key2) — Number — 외래 키 → Module.Module_ID — NOT NULL
Module_log (CopyOfCopyOfCopyOfUntitled322)
- Module_log_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field) — date — NOT NULL
- field (Field5) — Enum — NOT NULL
- Field2 — Enum — NOT NULL
- Module_ID (Key2) — Number — 외래 키 → Module.Module_ID — NOT NULL
Modules (모듈)
- Modules_ID (Key) — Number — 기본 키 — NOT NULL
- Field5 — int — NOT NULL
- Type (종류) — varchar — NOT NULL
- Control (Field) — Enum — NOT NULL
- Field3 — int
- Status (Field4) — Enum — NOT NULL
- Field7 — Enum
- insert (Field2) — date — NOT NULL
- update (Field8) — date — NOT NULL
- User_ID (Key2) — Number — 외래 키 → User.User_ID — NOT NULL
- User_ID (Key3) — Number — 외래 키 → User.User_ID — NOT NULL
Modules_log (CopyOf모듈)
- Modules_log_ID (Key) — date — 기본 키 — NOT NULL
- Field5 — int — NOT NULL
- Type (종류) — varchar — NOT NULL
- Control (Field) — Enum — NOT NULL
- Field3 — int
- Status (Field4) — Enum — NOT NULL
- Field7 — Enum
- Modules_ID (Key2) — Number — 외래 키 → Modules.Modules_ID — NOT NULL
Sensor (CopyOfUntitled)
- Sensor_ID (Key) — Number — 기본 키 — NOT NULL
- Sensor_Type (Field) — Enum — NOT NULL
- Field2 — Enum — NOT NULL
- Module_ID (Key2) — Number — 외래 키 → Module.Module_ID — NOT NULL
SensorData_log (Untitled)
- Sensor_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field2) — date — NOT NULL
- Sensor_Type (Field) — Enum — NOT NULL
- Data (Field3) — int — NOT NULL
- Module_ID (Key2) — Number — 외래 키 → Module.Module_ID — NOT NULL
Sensor_log (CopyOfCopyOfUntitled)
- Sensor_ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field3) — date — NOT NULL
- Sensor_Type (Field) — Enum — NOT NULL
- Field2 — Enum — NOT NULL
- Module_ID (Key2) — Number — 외래 키 → Module.Module_ID — NOT NULL
User (Untitled7)
- User_ID (Key) — Number — 기본 키 — NOT NULL
- id (Field) — varchar — NOT NULL
- password (Field2) — varchar — NOT NULL
- Field3 — Enum — NOT NULL
- Field4 — date — NOT NULL
- Field5 — date — NOT NULL
입출수측 측정량 (Untitled4)
- ID (Key) — Number — 기본 키 — NOT NULL
- Date (Field7) — date — NOT NULL
- pH (Field) — double — NOT NULL
- NH-4 (Field2) — double — NOT NULL
- TOCs (Field3) — double — NOT NULL
- TSS (Field4) — double — NOT NULL
- T-N (Field5) — double — NOT NULL
- T-P (Field6) — double — NOT NULL
- Field8 — int — NOT NULL
- Field9 — int — NOT NULL