I have two tables in a ClickHouse database. The first table, named "sites", represents sites (points of presence) where a mobile operator installs its equipment. The second table, named "sites_op_status", represents the operational status of the sites in the first table, which is updated every 10 minutes.
Here are the details of each column in the "sites" table:
key: old key of a site
sitename: unique ID of the site
region: geographical region in Saudi Arabia
city: city of Saudi Arabia
type: type of site, which can be "pop" (datacenter), "RAN" (GSM radio site), "cell enhancer" (cell enhancer), "corporate offices" (offices of operator), "NAME_1" (NAME_1/pilgrim sites activated only during NAME_1 season), "MW repeater" (microwave repeaters only without other GSM equipment), "SNFN" (consortium transport locations), "TB" (technical building, which can also be a datacenter or a rented datacenter), "TB,RAN" (both coexist), "TB,SNFN" (both coexist), or "WIFI" (site serving public Wi-Fi)
lat: latitude
long: longitude
location_type: some description of the site
mns_vendor: the managed service managing this site
dateofactivity: represents the ready-for-service date
status: "active" means operational, "NAME_1" means only available during NAME_1
province: province of Saudi Arabia
rank_: showing importance of site based on revenue generated, tiering as T1, T2, T3, with T1 as highest
tech: available only for GSM and Wi-Fi sites, values can be either "WIFI" or which GSM technology, for example, "4G" and "5G" site will be "4G5G," all GS Respond with more than 250 words.
user