ㄴㄴㄴ

Tables (9)

ap_history_data

  • ap_mac (Key2) — text — Primary key — NOT NULL
  • aggr_monthly (Key3) — int — Primary key — NOT NULL
  • timestamp (Key) — bigint — Primary key — NOT NULL
  • aggr_hourly (Field) — bigint
  • aggr_daily (Field2) — int
  • client_num (Field3) — int
  • rx_bytes (Field4) — bigint
  • tx_bytes (Field5) — bigint

apstats (CopyOfUntitled)

  • ap_mac (Key) — text — Primary key — NOT NULL
  • auth_clients (Field) — int
  • device_name (Field3) — text
  • rx_bytes (Field4) — bigint
  • timestamp (Field5) — bigint
  • total_boot_client (Field6) — int
  • total_con_client (Field7) — int
  • tx_bytes (Field8) — bigint
  • ap_ip (Key2) — text — NOT NULL
  • ap_state (Key3) — text — NOT NULL

clientstats (CopyOfap_history_data)

  • date (Key2) — text — Primary key — NOT NULL
  • hour (Key) — int — Primary key — NOT NULL
  • client_mac (Key3) — text — Primary key — NOT NULL
  • client_auth_mode (Field) — text
  • client_hostname (Field2) — text
  • client_ipaddress (Field3) — text
  • client_model_name (Field4) — text
  • client_os_type (Field5) — text
  • rx_bytes (Field6) — bigint
  • ssid (Field7) — text
  • tx_bytes (Field8) — bigint

connected_user_history (CopyOfCopyOfap_history_data)

  • client_mac (Key2) — text — Primary key — NOT NULL
  • aggr_monthly (Key3) — int — Primary key — NOT NULL
  • timestamp (Key) — bigint — Primary key — NOT NULL
  • aggr_daily (Field) — int — Primary key
  • aggr_hourly (Field2) — int — Primary key
  • ap_mac (Field3) — text
  • ap_name (Field4) — text
  • email (Field5) — text
  • email_type (Field6) — text
  • rx_bytes (Field7) — bigint
  • tx_bytes (Field8) — bigint
  • user_id (Field9) — uuid

new_auth_client (CopyOfCopyOfap_history_data2)

  • date (Key2) — text — Primary key — NOT NULL
  • client_mac (Key3) — text — Primary key — NOT NULL
  • client_auth_mode (Field) — text
  • client_hostname (Field2) — text
  • client_ipaddress (Field3) — text
  • client_model_name (Field4) — text
  • client_os_type (Field5) — text
  • rx_bytes (Field6) — bigint
  • ssid (Field7) — text
  • tx_bytes (Field8) — bigint

view_ap_data_hourly (CopyOfap_history_data2)

  • ap_mac (Key2) — bigint — Primary key — NOT NULL
  • aggr_monthly (Key3) — int — Primary key — NOT NULL
  • timestamp (Key) — bigint — Primary key — NOT NULL
  • aggr_hourly (Field) — int
  • aggr_daily (Field2) — int
  • client_num (Field3) — int
  • rx_bytes (Field4) — bigint
  • tx_bytes (Field5) — bigint

view_ap_history_data_daily (CopyOfCopyOfap_history_data22)

  • ap_mac (Key2) — text — Primary key — NOT NULL
  • aggr_monthly (Key3) — int — Primary key — NOT NULL
  • timestamp (Key) — bigint — Primary key — NOT NULL
  • aggr_hourly (Field) — int
  • aggr_daily (Field2) — int
  • client_num (Field3) — int
  • rx_bytes (Field4) — bigint
  • tx_bytes (Field5) — bigint

view_ap_history_data_hourly (CopyOfCopyOfCopyOfap_history_data22)

  • ap_mac (Key2) — text — Primary key — NOT NULL
  • aggr_monthly (Key3) — int — Primary key — NOT NULL
  • timestamp (Key) — bigint — Primary key — NOT NULL
  • aggr_hourly (Field) — int
  • aggr_daily (Field2) — int
  • client_num (Field3) — int
  • rx_bytes (Field4) — bigint
  • tx_bytes (Field5) — bigint

view_clientstats_data (CopyOfCopyOfap_history_data3)

  • date (Key2) — text — Primary key — NOT NULL
  • hour (Key) — text — Primary key — NOT NULL
  • client_mac (Key3) — text — Primary key — NOT NULL
  • client_hostname (Field2) — text
  • client_ipaddress (Field3) — text
  • client_model_name (Field4) — text
  • client_os_type (Field5) — text