hmiServer
Tables (9)
Area
- AreaId — INT(36) — Primary key — NOT NULL
- AreaName — VARCHAR(255) — NOT NULL
Comment
- CommentId — INT(36) — Primary key — NOT NULL
- WellId — INT(36) — Foreign key → Well.WellId — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- Comment — TEXT
Data
- id (Key) — INT(36) — Primary key — NOT NULL
- WellId — INT(36) — Foreign key → Well.WellId — NOT NULL
- FlowRate (Flow) — Float
- StaticPressure (Static) — FLOAT
- DiffPressure (Diff) — FLOAT
- CasingPressure (Cassing) — FLOAT
- Temperature (Temp) — FLOAT
- Roads — FLOAT
- CurrentTime — TIMESTAMP — NOT NULL
Status
- StatusId — INT(36) — Primary key — NOT NULL
- WellId — INT(36) — Foreign key → Well.WellId — NOT NULL
- AreaId — INT(36) — Foreign key → Well.AreaId — NOT NULL
- Status — VARCHAR(255) — NOT NULL
Turbine
- turbineID (TurbineId) — INT(36) — Primary key — NOT NULL
- Name (name) — VARCHAR — NOT NULL
- max (Max) — Float
- min (Min) — Float
TurbineData
- id — INT(36) — Primary key — NOT NULL
- turbineID (TurbineId) — INT(36) — Foreign key → Turbine.turbineID — NOT NULL
- Pressure — FLOAT
- Temperature — FLOAT
- RPM — FLOAT
- WATT (Watt) — FLOAT
- CurrentTime — TIMESTAMP
User
- id — VARCHAR(36) — Primary key — NOT NULL
- TypeId — INT(36) — Foreign key → UserType.TypeId — NOT NULL
- UserId — VARCHAR(36) — NOT NULL
- UserName — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
UserType
- TypeId — INT(36) — Primary key — NOT NULL
- Type — VARCHAR(255) — NOT NULL
Well
- WellId — INT(36) — Primary key — NOT NULL
- AreaId — INT(36) — Foreign key → Area.AreaId — NOT NULL
- 이름 (WellName) — VARCHAR(255) — NOT NULL
- 위도 (Latitude) — FLOAT — NOT NULL
- 경도 (Longitude) — FLOAT — NOT NULL
- 상태 (Status) — ENUM — "Open","Close", "NoComms"