Modules

테이블 (15)

A module (Untitled3)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • ID (Key3) — Number — 외래 키 → User.ID — NOT NULL
  • Stage (Field) — Enum — NOT NULL
  • Read_status (Field2) — Enum — NOT NULL
  • Messege (Field3) — varchar — NOT NULL
  • Date (Field4) — date — NOT NULL
  • Field5 — varchar — NOT NULL

B module (CopyOfUntitled3)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • Date (Field) — date — NOT NULL
  • Field2 — int — NOT NULL
  • Field3 — Enum — NOT NULL

D module (CopyOfCopyOfUntitled3)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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

Modules (모듈)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • Field5 — int — NOT NULL
  • Type (종류) — varchar — NOT NULL
  • Control (Field) — Enum — NOT NULL
  • Field2 — int — NOT NULL
  • Field3 — int
  • Status (Field4) — Enum — NOT NULL
  • Field6 — Enum
  • Field7 — Enum

Modules_log (CopyOf모듈)

  • Key — date — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • Field5 — int — NOT NULL
  • Type (종류) — varchar — NOT NULL
  • Control (Field) — Enum — NOT NULL
  • Field2 — int — NOT NULL
  • Field3 — int
  • Status (Field4) — Enum — NOT NULL
  • Field6 — Enum
  • Field7 — Enum

SMPS (CopyOfUntitled6)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • SMPS#1 (Field) — int — NOT NULL
  • SMPS#2 (Field2) — int — NOT NULL
  • SMPS#3 (Field7) — int — NOT NULL
  • SMPS#4 (Field8) — int — NOT NULL
  • Date (Field3) — date — NOT NULL

User (Untitled7)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • id (Field) — varchar — NOT NULL
  • password (Field2) — varchar — NOT NULL
  • Field3 — Enum — NOT NULL

입출수측 측정량 (Untitled4)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — 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
  • Date (Field7) — date — NOT NULL
  • Field8 — int — NOT NULL
  • Field9 — int — NOT NULL

전력 (Untitled11)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • Field — int — NOT NULL
  • Field2 — int — NOT NULL
  • Status (Field3) — Enum — NOT NULL

전력_log (Untitled6)

  • ID (Key) — Number — 기본 키 — NOT NULL
  • ID (Key2) — Number — 외래 키 → Modules.ID — NOT NULL
  • Field — double — NOT NULL
  • Field2 — int — NOT NULL
  • Date (Field7) — date — NOT NULL