user

Tables (13)

alarm_log (CopyOfdevice_environment)

  • device_code (id) — Auto_int — Primary key — NOT NULL
  • alarm_type (name) — varchar(10)
  • alarm_message (type) — varchar(255)
  • time (address) — datetime

device_camera

  • device_code — varchar(50) — Primary key — NOT NULL
  • device_name (name) — varchar(50)
  • device_type (type) — varchar(10)
  • camera_ip (ip) — varchar(16)
  • camera_id (make) — varchar(50)
  • camera_pw (password) — varchar(255)
  • api_key — varchar(255) — NOT NULL
  • plant_code (id) — varchar(50) — Foreign key → plant_info.plant_code — NOT NULL
  • camera_url (url) — varchar(255)
  • camera_type — varchar(10)

device_environment

  • device_code (id) — varchar(50) — Primary key — NOT NULL
  • device_name (name) — varchar(50)
  • device_type (type) — varchar(10)
  • device_address (address) — varchar(16)
  • device_make (make) — varchar(50)
  • plant_code — varchar(50) — Foreign key → plant_info.plant_code — NOT NULL

device_position

  • device_code (id) — varchar(50) — Primary key — NOT NULL
  • device_name (name) — varchar(50)
  • device_type (type) — varchar(10)
  • device_address (mac_address) — varchar(16)
  • device_make (make) — varchar(50)
  • device_nfc (Field) — varchar(255)
  • plant_code — varchar(50) — NOT NULL

live_environment

  • id — bigint — Primary key — NOT NULL
  • device_address — varchar(16)
  • device_type — varchar(10)
  • value — float
  • alarma (alarm) — boolean
  • status — varchar(10)
  • time — datetime
  • plant_code — varchar(50)
  • plant_name — varchar(50)
  • area — varchar(20)

live_position

  • id — bigint — Primary key — NOT NULL
  • mac_address — varchar(16)
  • device_type — varchar(10)
  • x — float
  • y — float
  • z — float
  • time — datetime
  • user_name — varchar(20)
  • plant_name — varchar(50)
  • battery — float
  • button_alarm — boolean
  • area — varchar(20)
  • plant_code — varchar(50)
  • accelration (acceleration) — varchar(50)

plant_code_trend_environment_yyyy

  • id — bigint — Primary key — NOT NULL
  • device_address — varchar(16)
  • device_type — varchar(10)
  • value — float
  • alarm — boolean
  • status — varchar(10)
  • time — datetime
  • plant_name — varchar(50)
  • area — varchar(20)

plant_code_trend_position_yyyy

  • id — bigint — Primary key — NOT NULL
  • mac_address — varchar(16)
  • device_type — varchar(10)
  • x — float
  • y — float
  • z — float
  • time — datetime
  • user_name — varchar(20)
  • plant_name — varchar(50)
  • battery — float
  • button_alarm — boolean
  • area — varchar(20)
  • accelration (acceleration) — varchar(50)

plant_info (plant)

  • plant_code (id) — varchar(50) — Primary key — NOT NULL
  • plant_name (site_name) — varchar(50)
  • plant_number (number) — int
  • plant_address_front (address_front) — varchar(100)
  • plant_address_remainder (address_remainder) — varchar(100)
  • plant_height (height) — float
  • plant_width (width) — float
  • plant_depth (depth) — float
  • plant_zip_code (zip_code) — int

user

  • user_id (id) — varchar(20) — Primary key — NOT NULL
  • user_pw (password) — varchar(255)
  • user_name (name) — varchart(20)
  • user_last_login (last_login) — datetime
  • user_contact (TEL or H.P) — varchart(20)
  • user_token (jwt) — varchart(255)
  • user_refresh_value (refresh_time) — varchart(255)
  • user_is_verified (verify) — boolean
  • user_device_token (push_alarm) — varchart(255)

user_log (CopyOfuser_role)

  • id — auto — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • log_type — varchar(6)
  • log_content — varchar(255)

user_role

  • id — auto — Primary key — NOT NULL
  • plant_code — varchar(50) — Foreign key → plant_info.plant_code — NOT NULL
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL

worker_info (CopyOfdevice_position)

  • worker_name (name) — varchar(50)
  • worker_contact (type) — varchar(10)
  • worker_company (mac_address) — varchar(16)
  • worker_department (make) — varchar(50)
  • device_code (id2) — varchar(50) — Foreign key → device_position.device_code — NOT NULL