Modules v.3

Tables (12)

AI (Untitled)

  • AI_ID (Key) — Number — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Module_ID (Key2) — Number — Foreign key → Module_point.Module_ID — NOT NULL

Alarm_log (Untitled5)

  • Alarm_ID (Key) — Number — Primary key — NOT NULL
  • Date (Field4) — date — 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 — Foreign key → User.User_ID — NOT NULL
  • AI_ID (Key3) — Number — Foreign key → AI.AI_ID — NOT NULL
  • DI_ID (Key4) — Number — Foreign key → DI.DI_ID — NOT NULL

Control (CopyOfUntitled8)

  • Control_log_ID (Key) — Number — Primary key — NOT NULL
  • Control_Type (Field5) — Enum — NOT NULL
  • insert (Field) — date
  • update (Field2) — date
  • User_ID (Key2) — Number — Foreign key → User.User_ID — NOT NULL
  • Module_ID (Key3) — Number — Foreign key → Module_point.Module_ID — NOT NULL

Control_history (CopyOfCopyOfUntitled8)

  • Control_log_ID (Key) — Number — Primary key — NOT NULL
  • date (Field) — date
  • Control_Type (Field5) — Enum — NOT NULL
  • User_ID (Key2) — Number — Foreign key → User.User_ID — NOT NULL
  • Module_ID (Key3) — Number — Foreign key → Module_point.Module_ID — NOT NULL

Control_log (Untitled8)

  • Control_log_ID (Key) — Number — Primary key — 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 — Foreign key → User.User_ID — NOT NULL
  • Module_ID (Key3) — Number — Foreign key → Module_point.Module_ID — NOT NULL

DI (CopyOfUntitled)

  • DI_ID (Key) — Number — Primary key — NOT NULL
  • Field
  • Field2
  • Field4
  • Module_ID (Key2) — Number — Foreign key → Module_point.Module_ID — NOT NULL

ModuleData_log (CopyOfUntitled32)

  • Data_log_ID (Key) — Number — Primary key — NOT NULL
  • Date (Field3) — date — NOT NULL
  • field (Field5) — Enum — NOT NULL
  • Field6 — int — NOT NULL
  • Module_ID (Key2) — Number — Foreign key → Module_point.Module_ID — NOT NULL

Module_history (CopyOfCopyOfCopyOfUntitled322)

  • Module_log_ID (Key) — Number — Primary key — NOT NULL
  • Date (Field) — date — NOT NULL
  • field (Field5) — Enum — NOT NULL
  • Field2 — Enum — NOT NULL
  • Field3 — Enum — NOT NULL
  • Module_ID (Key2) — Number — Foreign key → Module_point.Module_ID — NOT NULL
  • User_ID (Key3) — Number — Foreign key → User.User_ID — NOT NULL

Module_point (CopyOfCopyOfUntitled32)

  • Module_ID (Key) — Number — Primary key — NOT NULL
  • field (Field5) — Enum — NOT NULL
  • Field — Enum — NOT NULL
  • Field4 — Enum — NOT NULL
  • insert (Field2) — date — NOT NULL
  • update (Field3) — date — NOT NULL
  • Modules_ID (Key2) — Number — Foreign key → Modules.Modules_ID — NOT NULL
  • User_ID (Key3) — Number — Foreign key → User.User_ID — NOT NULL
  • User_ID (Key4) — Number — Foreign key → User.User_ID — NOT NULL

Modules (모듈)

  • Modules_ID (Key) — Number — Primary key — NOT NULL
  • Field5 — int — NOT NULL
  • Type (종류) — varchar — 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 — Foreign key → User.User_ID — NOT NULL
  • User_ID (Key3) — Number — Foreign key → User.User_ID — NOT NULL

Modules_log (CopyOf모듈)

  • Modules_log_ID (Key) — date — Primary key — NOT NULL
  • Field5 — int — NOT NULL
  • Type (종류) — varchar — NOT NULL
  • Field3 — int
  • Status (Field4) — Enum — NOT NULL
  • Field7 — Enum
  • Modules_ID (Key2) — Number — Foreign key → Modules.Modules_ID — NOT NULL

User (Untitled7)

  • User_ID (Key) — Number — Primary key — NOT NULL
  • id (Field) — varchar — NOT NULL
  • password (Field2) — varchar — NOT NULL
  • Field3 — Enum — NOT NULL
  • Field4 — date — NOT NULL
  • Field5 — date — NOT NULL