qwe

Tables (7)

freeradius_access_log (Untitled)

  • id (Key) — UUID — Primary key — NOT NULL
  • calledstcalledstation_id (Field) — text
  • callingstation_id (Field2) — text
  • location_data (Field3) — text
  • message_auth (Field4) — text
  • nas_identifier (Field5) — text
  • nas_ipaddr (Field6) — text
  • nas_port_type (Field7) — text
  • password (Field8) — text
  • result (Field9) — text
  • ruckus_bssid (Field10) — text
  • ruckus_location (Field11) — text'
  • ruckus_scg_cblade_ip (Field12) — bigint
  • ruckus_ssid (Field13) — text
  • ruckus_vlan_id (Field14) — bigint
  • ruckus_wlan_id (Field15) — bigint
  • ruckus_wlan_name (Field16) — text
  • ruckus_zone_name (Field17) — text
  • servicetype (Field18) — text
  • username (Field19) — text

freeradius_expired_user (Untitled2)

  • username (Field) — text — Primary key
  • ap_mac (Field2) — text

freeradius_permission (CopyOfUntitled2)

  • username (Field) — text — Primary key
  • enc_clientmac (Field2) — text
  • enc_ipaddress (Field3) — text
  • expired_epoch (Field4) — bigint
  • password (Field5) — text
  • plan (Field6) — text
  • reg_date (Field7) — bigint
  • volume (Field8) — bigint

mac_user_map (Untitled5)

  • mac_address (Key) — text — Primary key — NOT NULL
  • created_ts (Field) — bigint
  • user_id (Field2) — uuid

radius_acct_log (Untitled3)

  • acct_session_id (Key) — text — Primary key — NOT NULL
  • event_timestamp (Key2) — bigint — Primary key — NOT NULL
  • acct_authentic (Field) — text
  • acct_input_octets (Field2) — bigint
  • acct_output_octets (Field3) — bigint
  • acct_session_time (Field4) — bigint
  • acct_status_type (Field5) — text
  • acct_terminate_cause (Field6) — text
  • called_station_id (Field7) — text
  • calling_station_id (Field8) — text
  • framed_ip_address (Field9) — text
  • nas_identifier (Field10) — text
  • nas_ip_address (Field11) — text
  • ruckus_bssid (Field12) — text
  • ruckus_ssid (Field13) — text
  • ruckus_vlan_id (Field14) — bigint
  • ruckus_wlan_id (Field15) — bigint
  • username (Field16) — text

temp_acct_log (CopyOfUntitled3)

  • acct_session_id (Key) — text — Primary key — NOT NULL
  • event_timestamp (Key2) — bigint — Primary key — NOT NULL
  • acct_session_time (Field4) — bigint
  • acct_status_type (Field5) — text

wakeup_permission (Untitled4)

  • user_id (Key) — UUID — Primary key — NOT NULL
  • device_mac (Field) — SET<text>
  • device_mac_history (Field2) — MAP<text,bigint>
  • expire_epoch (Field3) — bigint
  • plan (Field4) — text
  • unique_code (Field5) — text
  • use_volume (Field6) — bigint
  • volume (Field7) — bigint