ㄴㄴㄴ
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