iot-cloud-v0.7
Tables (20)
customer_iot
- id — varchar(10) — Primary key — NOT NULL — global
- type — varchar(20) — NOT NULL — customer
- name — varchar(100) — NOT NULL — customer
- customer_code — varchar(20) — customer
- contract_id — varchar(20) — contract
- status — varchar(20) — customer
- status_reason — varchar(40) — reason
- location_id — varchar(10) — location
- postal_code — varchar(10) — postal
- address1 — varchar(200)
- address2 — varchar(200)
- contact_person_name — varchar(100) — contact
- contact_person_dept_name — varchar(100) — contact
- contact_email — varchar(100) — NOT NULL — contact
- contact_phone_no — varchar(20) — contact
- contact_mobile_no — varchar(20) — contact
- general_manager_ids — varchar(300) — general
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
detector_app_iot
- id — varchar(50) — Primary key — NOT NULL — detector
- name — varchar(200) — NOT NULL — detector
- version — varchar(20) — NOT NULL
- maker — varchar(50) — detector
- event_types — varchar(200) — NOT NULL — event
- description — varchar(200) — NOT NULL
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
detector_iot
- id — varchar(50) — Primary key — NOT NULL — detector
- customer_code — varchar(20) — NOT NULL — customer
- detector_app_id — varchar(20) — NOT NULL — detector
- name — varchar(200) — NOT NULL — detector
- event_type — varchar(40) — detector
- description — varchar(200)
- installed_on — varchar(20)
- connection_status — varchar(20) — NOT NULL — detector
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp — date
- updated_by — varchar(20) — user
device_detector_map_iot
- id — varchar(20) — Primary key — NOT NULL — device
- device_id — varchar(20) — NOT NULL — device
- detector_id — varchar(20) — NOT NULL — detector
- created_at — timestamp
- created_by — varchar(20)
device_event_map_iot
- id — varchar(20) — Primary key — NOT NULL — device
- device_id — varchar(20) — NOT NULL — device
- event_id — varchar(20) — NOT NULL — event
- created_at — timestamp
- created_by — varchar(20)
device_iot
- id — varchar(20) — Primary key — NOT NULL — device
- customer_code — varchar(20) — NOT NULL — customer
- type — varchar(20) — NOT NULL — device
- name — varchar(100) — NOT NULL — device
- maker — varchar(50) — device
- model_no — varchar(20) — device
- product_no — varchar(20) — device
- serial_no — varchar(20) — device
- ip — varchar(20) — device
- gateway_name — varchar(50) — edge
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
device_status_hst_iot
- id — varchar(20) — Primary key — NOT NULL — device
- customer_code — varchar(20) — NOT NULL — customer
- device_id — varchar(20) — NOT NULL — device
- detector_id — varchar(20) — detector
- status — varchar(20) — NOT NULL — device
- metrics — json — metrics
- created_at — timestamp — date
device_status_iot
- device_id — varchar(20) — Primary key — NOT NULL — device
- customer_code — varchar(20) — NOT NULL — customer
- status — varchar(20) — NOT NULL — device
- status_reason — varchar(40) — status
- metrics — jsonb — device
- last_status_detected_at — timestamp — date
- last_event_detected_at — timestamp — date
- updated_at — timestamp
event_hst_iot
- id — varchar(20) — Primary key — NOT NULL — event
- customer_code — varchar(20) — NOT NULL — customer
- device_id — varchar(20) — device
- event_id — varchar(20) — event
- event_type — varchar(40) — event
- p1 — varchar(200) — event
- p2 — varchar(200) — event
- p3 — varchar(200)
- p4 — varchar(200)
- p5 — varchar(200)
- p6 — varchar(200)
- p7 — varchar(200)
- p8 — varchar(200)
- p9 — varchar(200)
- p10 — varchar(200)
- detected_at — timestamp — date
- created_at — timestamp — date
event_iot
- id — varchar(20) — Primary key — NOT NULL — event
- detector_app_id — varchar(20) — NOT NULL — detector
- event_type — varchar(40) — NOT NULL — event
- event_property_config — jsonb — event
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
event_raw_data_iot
- id — varchar(20) — Primary key — NOT NULL — event
- event_history_id — varchar(20) — NOT NULL — event
- media_type — varchar(10) — media
- relative_path — varchar(1000) — file
- detected_at — timestamp — date
- created_at — timestamp — date
group_device_map_iot
- id — varchar(20) — Primary key — NOT NULL — group
- group_id — varchar(20) — NOT NULL — group
- device_id — varchar(20) — NOT NULL — device
- created_at — timestamp
- created_by — varchar(20)
group_iot
- id — varchar(20) — Primary key — NOT NULL — group
- customer_code — varchar(20) — NOT NULL — customer
- name — varchar(100) — NOT NULL — group
- description — varchar(300) — description
- group_managers — varchar(500) — group
- twitter_ids — varchar(500)
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
group_user_map_iot
- id — varchar(20) — Primary key — NOT NULL — group
- group_id — varchar(20) — NOT NULL — group
- user_id — varchar(20) — NOT NULL — user
- created_at — timestamp
- created_by — varchar(20)
notice_device_map_iot
- id — varchar(20) — Primary key — NOT NULL — notice
- notice_rule_id — varchar(20) — NOT NULL — notice
- device_id — varchar(20) — NOT NULL — device
- created_at — timestamp
- created_by — varchar(20)
notice_history_iot
- id — varchar(20) — Primary key — NOT NULL — notice
- customer_code — varchar(20) — NOT NULL — customer
- group_id — varchar(20) — NOT NULL — group
- notice_rule_id — varchar(20) — NOT NULL — notice
- user_id — varchar(20) — NOT NULL — user
- device_id — varchar(20) — NOT NULL — device
- event_id — varchar(20) — NOT NULL — event
- contact_account — varchar(20) — NOT NULL — contact
- sent_at — timestamp — Datetime
- result_code — varchar(20) — result
- created_at — timestamp
notice_target_iot
- id — varchar(20) — Primary key — NOT NULL — notice
- notice_rule_id — varchar(20) — NOT NULL — notice
- user_id — varchar(20) — NOT NULL — user
- user_contact_id — varchar(20) — user
- day_of_week — varchar(30) — day
- time_range — jsonb — json
- contact_type — varchar(100) — contact
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
notice_template_iot
- id — varchar(20) — Primary key — NOT NULL — notice
- customer_code — varchar(20) — NOT NULL
- event_id — varchar(20) — NOT NULL — event
- name — varchar(100) — NOT NULL
- template_type — varchar(20) — NOT NULL — template
- contact_type — varchar(100) — contact
- file_path — varchar(1000)
- text_message — varchar(2000)
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
user_contact_iot
- id — varchar(20) — Primary key — NOT NULL — global
- customer_code — varchar(20) — NOT NULL — customer
- user_id — varchar(50) — NOT NULL — user
- contact_type — varchar(50) — NOT NULL — contact_type
- contact_name — varchar(100) — NOT NULL — contact
- access_token — varchar(500) — access
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)
user_iot
- id — varchar(20) — Primary key — NOT NULL — global
- customer_code — varchar(20) — NOT NULL — customer
- login_id — varchar(20) — NOT NULL — login
- password — varchar(100) — NOT NULL — password
- name — varchar(100) — NOT NULL — name
- email — varchar(100) — NOT NULL — email
- mobile_no — varchar(20)
- phone_no — varchar(20) — phone
- role — varchar(20) — NOT NULL — system
- account_status — varchar(20) — NOT NULL — account
- status_reason — varchar(40) — status
- last_login_time — timestamp
- last_logout_time — timestamp
- login_fail_count — integer
- last_access_token_issued_at — timestamp
- last_refresh_token_issued_at — timestamp
- last_refresh_expire_at — timestamp
- password_changed_at — timestamp
- created_at — timestamp
- created_by — varchar(20)
- updated_at — timestamp
- updated_by — varchar(20)