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"