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