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