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)