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